Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 05-19-2020, 07:52 AM   #1
Steve R.
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Mint 19.3
Posts: 457

Rep: Reputation: 92
Installing MariaDB/MySQL

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"

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)
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.

Last edited by Steve R.; 05-27-2020 at 08:25 AM.
Old 05-25-2020, 08:25 PM   #2
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,774

Rep: Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537Reputation: 2537
Agreed: one of my pet peeves is that advice pages often don't have a date stamp (which would help a lot).
A version num statement would be even better


installation, mariadb, mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
I need help (not a tut) installing mysql or mariadb BrainPowered Linux - Newbie 3 01-20-2016 10:19 PM
LXer: Installing Nginx with PHP and MariaDB (as MySQL replacement) on Ubuntu 15.10 (Wiley Werewolf) LXer Syndicated Linux News 0 11-06-2015 03:22 PM
LXer: Installing Lighttpd with PHP (PHP-FPM mode) and MySQL or MariaDB on Ubuntu 15.04 LXer Syndicated Linux News 0 09-29-2015 07:15 PM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 02:11 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration