我有一个错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock当我运行mysqld.sock时,似乎不是安装apt-get install mysql-server。我试过find / -name "mysqld.sock",但什么也找不到。
我无法连接到数据库,但我不知道为什么,因为用户名和密码是正确的,我能够通过phpmyadmin本地连接。(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1750)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290
我按照的答案在Ubuntu16.04上设置我的根密码。msql --version给了我以下内容:在回答之后,当我输入UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';时,我得到以下内容:
QueryOK, 1 row
[14-Aug-2014 19:58:53 UTC] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'SERVER IP' (4) in /home/blabbers/public_html/inc