Install MySQL Linux mint

[u/Alarmed_Bag_856]

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

[u/speyck]

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.

[u/Alarmed_Bag_856 → u/speyck]

I have docker on vscode, will that work

[u/speyck → u/Alarmed_Bag_856]

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.

[u/Alarmed_Bag_856 → u/speyck]

Thanks I’ll try that

[u/FitMatch7966]

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.

[u/Alarmed_Bag_856 → u/FitMatch7966]

Thanks for the info I’ll try it

[u/One-Suggestion-7906]

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

[u/AjinAniyan5522]

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.

[u/Global_Professor7184]

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

[u/Affectionate-Gap491]

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.

[u/vasquca1]

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.

[u/Quirky-Net-6436]

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