Can't login to PHPMyAdmin

[kp77]

A few days ago I didn't have this problem, but I cloned laradock yesterday and built new images. Since then I can't login to PHPMyAdmin.

Previously, I could enter either the short version of the container ID hash or the container name (laradock_mysql_1) as Server and it worked. Now if I do this I get this error:

#2005 - Unknown MySQL server host 'laradock_mysql_1' (-2)

I also tried with localhost and 127.0.0.1, but then I get this error on the PHPMyAdmin login page:

#2002 - Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory") — The server is not responding (or the local server's socket is not correctly configured).

Interestingly, I can connect with HeidiSQL without problems using localhost, so my guess is this is related to PHPMyAdmin.

[mauro-ni]

I have the same issue since laradock v. 5.1.0

[zeroc0d3]

Could you try this:
docker-compose build && docker-compose up -d nginx mysql phpmyadmin

Perhaps it will help

[mauro-ni]

This is what i did:
docker-compose build --no-cache nginx mysql phpmyadmin workspace php-fpm applications
docker-compose up -d nginx mysql phpmyadmin

[kp77]

@maurosbu
@zeroc0d3
I tried these, but I get the same error.

[mauro-ni]

@kp77 Sorry, my previous message was an answer for @zeroc0d3. The error persists.

[thorerik]

the hostname you should use is mysql or mariadb depending on which flavour you use.

[kp77]

@thorerik I tried mysql but I got the same error.

#2005 - Unknown MySQL server host 'mysql' (-2)

[zeroc0d3]

@kp77. could you send the log process?

[mauro-ni]

@zeroc0d3 Same feedback when using mysql as host.
#2005 - Unknown MySQL server host 'mysql' (-3)

[kp77]

@zeroc0d3 Could you tell me which log process do you mean, and how I can get it?

I looked at the container logs in Kitematic, but I couldn't see any related records.

[a-h-abid]

@kp77 are you using the latest laradock update? If so, you need to open docker-compose.yml file go to your phpmyadmin section, then the network section and there check if both frontend and backend networks are added.

[mauro-ni]

@a-h-abid thank you.
It is a bug:
https://github.com/laradock/laradock/blob/master/docker-compose.yml#L392-L393

[louiskareem]

Try putting what you have in DB HOST in the server section and use password & username as root.

[neuthral]

i could login with
host: mysql
user: root
pass: root

[neutt22]

@neuthral how come the user and password were root? it works tho! I thought it was secret as specified in the .env file of laradock.

[neuthral]

@neutt22 i have no idea, i found that out by chance, it works good after changing .env password

[andersson83]

@neuthral great one, 24 hours trying to fix de issue... ufff. Thankyou

[murilolivorato]

I cant connec as well , please , ome one can help ?

[ikingye]

change mysql from latest to 5.7
and rebuild
then login with
mysql + root + root

[CROSP]

@neutt22 i have no idea, i found that out by chance, it works good after changing .env password

Thanks, still have the same issue, resolved by changing password in .env file, however root password remained the same root

[maxkossatz]

Had the same issue:
downgrade mysql from 8 to 5.7

by setting MYSQL_VERSION=5.7 in laradock/.env
after that in your .env file see the var called DATA_PATH_HOST and go to that folder, after that delete the mysql folder there and then do the docker-compose build --no-cache mysql and then docker-compose up -d mysql

#1855 (comment)

[m-maharjan]

Solved by changing the authentication method of user default to mysql native password.

go to mysql bash docker-compose exec mysql bash
login using root mysql -u root -p password is root.
then issue following mysql command ALTER USER 'default' IDENTIFIED WITH mysql_native_password BY 'secret';

Now in phpmyadmin login page input server as mysql user default and password secret.

[Hazelwu2]

Solved by changing the authentication method of user default to mysql native password.

go to mysql bash docker-compose exec mysql bash
login using root mysql -u root -p password is root.
then issue following mysql command ALTER USER 'default' IDENTIFIED WITH mysql_native_password BY 'secret';

Now in phpmyadmin login page input server as mysql user default and password secret.

thank you for your kind of help. It's really useful.

[ryansutrisno]

Solved by changing the authentication method of user default to mysql native password.

go to mysql bash docker-compose exec mysql bash
login using root mysql -u root -p password is root.
then issue following mysql command ALTER USER 'default' IDENTIFIED WITH mysql_native_password BY 'secret';

Now in phpmyadmin login page input server as mysql user default and password secret.

thanks for your kind of help. It's work for me. I'm used default setting on .env file just change the DOCKER_HOST_IP and version of node. Everything just default.

[beganovich]

Solved this by using mariadb instead of mysql. Next time, Oracle.

# Accepted values: mariadb - mysql
PMA_DB_ENGINE=mariadb

[sayalok]

go to mysql bash docker-compose exec mysql bash

run this to login mysql -uroot -proot

run below command to update the root user password
ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY '123';