[Solved] Looking for a QuickStart Guide - phpmyadmin

[linuxdad]

I migrated an older mysql DB over to the mysql-MariaDB-5.5.40-1.1.mga3 server, and then installed phpmyadmin on the server.

Unfortunately, all of the previous configurations I used to use for phpmyadmin are no longer working.

Is there a Quick start guide to getting phpmyadmin running on the server that is running apache? I can get the login page, but I am getting the following error:

#2000 Cannot log in to the MySQL server

Thank you.

[oldcodger]

There is not a quick start guide that I am aware of. However I have been through your pain a few times myself.
The first thing is you need to know is that you have the mysqld server running and that you can log in from the command line. If you cannot log in from the command line you need to correct that first. There is very comprehensive help in the Mysql documentation on the Mysql website.

[linuxdad]

Thanks OldCodger. You know my Pain.

[oldcodger]

Can you logon to the mysql server from the command line?

[viking60]

I just installed task-lamp-php and checked phpmyadmin.
It pretty much worked out of the box here.

Things to check:
Is mysqld started?

Code: Select all

sudo systemctl status mysqld

if not start it:

Code: Select all

sudo systemctl start mysqld

At this point I always set up Mysql/MariaDB with

Code: Select all

mysql_secure_installation

Phpmyadmin works out of the box after that when the server is installed with task-lamp-php.

If Phpmyadmin plays tricks on you you can use the one file program Adminer - it is great and not at all hard to configure or set up.

Phpmyadmin can be moody from time to time. sometimes because the default in the config files are changed so that phpmyadmin does not work until you activate it there.

[linuxdad]

Thank you, I was unaware of adminer! Great addition to my tool bag.

[oldcodger]

Thank you, I was unaware of adminer! Great addition to my tool bag.

Never too old to learn !eh.
It's in the bag. Much faster than phpMyAdmin.

[viking60]

Thank you, I was unaware of adminer! Great addition to my tool bag.

Oh it was nothing ...and yes Adminer is a good one.