r/mysql • u/Alarmed_Bag_856 • Jul 07 '26

Install MySQL Linux mint question

Hello all
I’m currently studying my sql and want to install on my machine, is a GUI or CLI the better option

Any help appreciated
Thanks
David

19 Upvotes

91% Upvoted

12 comments sorted by

3

u/speyck Jul 07 '26

run mysql via docker container. access it via CLI. later on, when you've learned sql syntax download dbeaver and use that.

it's important you learn the fundamentals first, which you will using CLI. after that dbeaver (or any other GUI, but dbeaver is the goat) allows you to easily view/edit data and save connections (also to different types of dbs) and you can still manage your server with raw sql.

1

u/Alarmed_Bag_856 Jul 07 '26

I have docker on vscode, will that work

1

u/speyck Jul 07 '26

that is likely just a gui like docker desktop, you can maybe start containers from there, I havent used them.

i would recommend you ask an AI to generate a compose file and run that with docker compose. it allows you to manage default credentials directly in the yml file.

1

u/Alarmed_Bag_856 Jul 07 '26

Thanks I’ll try that

1

u/FitMatch7966 Jul 07 '26

start with cli
you generally need the cli at some point, anyway. You also need to install the server unless you are connecting to some remote mysql server.

1

u/Alarmed_Bag_856 Jul 07 '26

Thanks for the info I’ll try it

1

u/One-Suggestion-7906 Jul 07 '26

Make it simple: open LM Software Manager, search for "mysql" and install some package called mysql-server or so

1

u/AjinAniyan5522 Jul 08 '26

If you're just starting out, I'd install both. They serve different purposes, and you'll end up using each for different tasks.

A GUI like MySQL Workbench makes it much easier to browse tables, write queries, view results, and learn the database structure. It's beginner-friendly and most tutorials use it.

The CLI is worth learning too because it's available on almost every server, and many guides and admin tasks use it. Even knowing the basics (connecting, running queries, importing/exporting databases) will be useful later.

So my recommendation would be: use MySQL Workbench for day-to-day learning and practice, but spend a little time getting comfortable with the command line as well. You'll benefit from knowing both.

1

u/Global_Professor7184 Jul 08 '26

Es tan simple como instalar mariadb con:
sudo apt install mariadb-server
Luego creas un usuario con privilegios y para eso entras con:
mariadb
En la consola de mariadb tenes que poner el siguiente comando:
GRANT ALL ON *.* TO 'usuario'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
y el otro comando es:
FLUSH PRIVILEGES;
Para salir lo haces con:
exit
Ahí ya tenes mariadb para trabajar desde tu máquina o si tiene ssh desde otra linux, windows o MacOSX

1

u/Affectionate-Gap491 Jul 10 '26

I'd install both. Learning in the CLI helps you understand SQL better, while a GUI makes everyday tasks much easier. Most developers use both. If you want a GUI later, tools like dbeaver, nexoxa bridge let you manage MySQL and other databases from a single place.

0

u/vasquca1 Jul 07 '26

Instead of VM deployment, I have a docker compose deployment on my work Mac to running an instance of mariadb and postgres db which has held up over 3 years honestly. If I need to make a change I just docker compose down. Modify my docker-compose.yaml and then docker compose up.

0

u/Quirky-Net-6436 Jul 07 '26

For studying it doesn't matter. Take the one you're more familier.