各位大侠,我修改了mysql的my.cnf文件的bind-address后,就不能登录mysql 出现的错误是:
Got an error: Connection error: Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock'
搜索全文,也找不到这个文件,请问如何处理呢?
Got an error: Connection error: Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock'
搜索全文,也找不到这个文件,请问如何处理呢?
你可以重启服务 或者直接不用socket mysql -hlocalhost -uxxx -p
这个方法不行,还是有问题呢。mysql -hlocalhost -u root -p
Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)