mysql
I'm use Ubuntu lts 23.10 version,i have lampp installed in my opt directory, i want to use mysql then when execute this command in my command line mysql -u root -p then it show up the mariaDb not mysql. I want to use mysql but i don't know how to change that mariaDb to mysql
9 Replies
LAMP is actually an acronmy for multiple technology stacks. You must have downloaded something that used MariaDB instead of MySQL. You need to go back and make sure you install MySQL.
For the record, MariaDB is a fork of MySQL so most if not all commands should be identical.
they're used interchangibly a lot
afaicr Ubuntu just installs mariadb when you
apt install mysql-serverhttps://ubuntu.com/server/docs/databases-mysql
you just follow the steps there
Thanks for that sir
note that it's very likely to not be worth the effort, mariadb is functionally identical to mysql
The only difference as of MariaDB 11.0.1 is that
mysqldump is now deprecated and only mariadb-dump should be used instead, for things like backups. But otherwise, it's identical in how you use it and performance-wise.
https://mariadb.com/kb/en/mariadb-dump/not to mention mariadb is FOSS and mysql is now controlled by Oracle 🤮
also, mariadb does have some slight memory usage improvements
if you use mysql workbench, you can ignore the warnings
there is a tiny tiny tiny difference in internal databases, but its nothing serious