Mysql was installed in Ubuntu and this error occurred when I opened it:
mysql -uroot -p
enter password:
ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded
A face overwhelmed
baidu to only on stackoverflow. It’s a little weird to find something that says’ unix_socket ‘
https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded
And twice, every time I want to use the database, this problem always comes up.
solution:
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Just restart it and you can use it
Read More:
- Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- Solution to error 2002 (HY000) in MySQL
- error C2146: syntax error : missing ‘;’ before identifier ‘fd’
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- MySQL connection error access denied for user ‘root’ @ ‘localhost‘
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)
- Solve MySQL error 2002 (HY000)
- ERROR 2005 (HY000): Unknown MySQL server host
- Sqlog can’t connect to MySQL (1045 error)
- Solution to error 2002 (HY000) in MySQL login startup
- [error handling] when logging into MySQL with CentOS command, an error 1045 (28000) is reported
- Centos7 executes the command service mysqld start and prompts Failed to start mysqld.service: Unit mysqld.service not loaded
- Call to undefined function mysql_ Connect() solution summary
- Redirecting to /bin/systemctl stop mysqld.service
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- [mysql] “Failed to start MySQL Server” error resolution
- mysql problem solving: mysqladmin: connect to server at’localhost’ failed
- mysql Table ‘performance_ schema.session_ Variables’ doesn’t exist solution