Troubleshoot: mysqladmin connect to server at localhost failed
Connect to a Docker MysQL Container with mysqladmin
The most obvious reason for the “mysqladmin: connect to server at ‘localhost’ failed” message is that MySQL Server is not running. Following is the complete error message.
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2 “No such file or directory”)’
Check that mysqld is running and that the socket: ‘/var/lib/mysql/mysql.sock’ exists!
error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2 “No such file or directory”)’
Check that mysqld is running and that the socket: ‘/var/lib/mysql/mysql.sock’ exists!
Check MySQL Server Status and Start MySQL
First, check whether MySQL is running on your Linux machine.
systemctl status mysqlOr
service mysql statusIf you use MariaDB, Type:
systemctl status mariadbIf Server status is not active, start the MySQL Server:
systemctl start mysqlOr
service mysql startConnect to a Remote MySQL Host
To connect to a remote MySQL Server, you need to use -h option.
mysqladmin -u user -p -h 192.168.1.10 pingConnect to a Docker MySQL Container
If you are trying to run the mysqladmin command on a docker container from the docker host, use the loopback address 127.0.0.1 instead of localhost.
mysqladmin -p -h 127.0.0.1 pingIf you try to connect to a mysql container through the localhost you will get the “mysqladmin: connect to server at ‘localhost’ failed” error message.