mysql服务启动却连接不上的解决方法

2024-02-26 13:47:03 422

root@localhost:~#mysql-uroot-p Enterpassword: ERROR2002(HY000):Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2) root@localhost:~#servicemysqldrestart ShuttingdownMySQL..[OK] StartingMySQL.[OK] root@localhost:~#mysql-uroot-p Enterpassword: ERROR2002(HY000):Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)

root@localhost:~#find/-namemysql.sock /tmp/mysql.sock root@localhost:~#mysql-uroot-p-S/tmp/mysql.sock Enterpassword: WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis1 Serverversion:5.6.15-logSourcedistribution Copyright(c)2000,2011,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. mysql>

root@localhost:~#find/-namemysql.sock /tmp/mysql.sock root@localhost:~#vi/etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql #Defaulttousingoldpasswordformatforcompatibilitywithmysql3.x #clients(thoseusingthemysqlclient10compatibilitypackage). old_passwords=1 #Disablingsymbolic-linksisrecommendedtopreventassortedsecurityrisks; #todoso,uncommentthisline: #symbolic-links=0 #加上下面的这段代码即可 [mysql] socket=/tmp/mysql.sock [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid root@localhost:~#mysql-uroot-p Enterpassword: WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis3 Serverversion:5.6.15-logSourcedistribution Copyright(c)2000,2011,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. mysql>

mysql服务启动却连接不上的解决方法

热门推荐

随机推荐