Several years ago, I installed MySQL and then moved to MariaDB. Everything ran smoothly. Years past. Recently I installed Mint 19.3. The installation of MariaDB went badly. It is now working working correctly.
What went wrong?
It appears, that overtime, the login (security) process changed. However, the advice provided by many websites on how to install MariaDB/MySQL were never updated. Not their fault.
Now I am seeing new tutorials being posted that address the problems that I had experienced.
How to Install MySQL on Ubuntu 20.04
How to Install MariaDB on Ubuntu 20.04
The two stumbling blocks I experienced related to undertaking a new install of MariaDB and MySQL related to the use of the "
auth_socket" and "
phpMyadmin"
auth_socket
Quote:
|
On Ubuntu, MariaDB root user is authenticated by the auth_socket plugin by default. This plugin works by checking whether the local system user invoking the client program matches the specified MariaDB user name. (from linuxize)
|
phpMyadmin:
Quote:
if you want to login to your MariaDB server as root using an external program such as phpMyAdmin, you have two options.
The first one is to change the authentication method from auth_socket to mysql_native_password.
...
The second, recommended option is to create a new dedicated administrative user with access to all databases. (from linuxize)
|
In conclusion, installing software over time changes. Even the advise provided here will become obsolete eventually. So always check the currency of the advice being provided by tutorials.
