回车 service mysqld start成功了！ mysql- Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock标签：rgb mysql info nbsp mamicode ima run can lazy 本文系统来源：https://www.cnblogs.com/gougou1981/p/14006940.html
1. You don‘t have to change the tmp directory in the my.cnf file. Even adding a second directory, changing fromtempdir =/tmp to =/tmp:/newdir crashed mysql. In 10.04 using MySQL 5.1 you used to have to add the second path other wise you got an error something like can‘t write temp file.... Of course did change the datadir to /MyDisk/myNewDir2. Used the wrong permission flags on my file copy from...
2. rm -f /var/run/mysqld/mysqld.pid 3. chmod 777 ‘/var/run/mysqld/mysqld.sock done error: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2)标签：本文系统来源：http://www.cnblogs.com/bushe/p/4487250.html
(HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)2、解决方法（摘自：http://wenda.haosou.com/q/1364099334067193?src=150）1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动. 另外看看是不是权限问题. 2、确定你的mysql.sock是不是在那个位置， mysql -u 你的mysql用户名 -p -S /var/lib/mysql/mysql.sock 3、试试：service mysqld start ERROR 2002 (HY0...
Next purge MySQL (this will remove php5-mysql and phpmyadmin as well as a number of other libraries so be prepared to re-install some items after this. sudo apt-get purge mysql-server-5.1 mysql-common Remove the folder /etc/mysql/ and it‘s contents sudo rm /etc/mysql/ -R Next check that your old database files are still in /var/lib/mysql/ if they are not then copy them back in to the folder then ...
连接mysql服务器有两种方式：tcp连接，通过socket文件连接。通过socket文件，启动mysql服务，mysql服务会自动生成一个sock文件，生成的sock文件默认放在 --datadir=/var/lib/mysql，mysql默认从/var/lib/mysql目录读取sock文件。 解决办法：1、看看/var/lib/mysql/mysql 有没有mysql.sock文件2、没有mysql.sock，重启mysql服务，看看有没有。3、没有的话，ps aux|grep mysql|grep -v ‘grep‘ 查看mysql服务生成的sock在哪个目录，...
刚刚遇到这个报错，我无语了，我这么个菜逼，咋解决，还好师兄（付付）解决了，付付真棒，在此记录一下，以供学习 Can ‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock ‘(2) "; 1.查日志（首先还是看error.log）,我看了一遍，继续急，师兄看了一遍 2. can‘t create /write to file ‘tmp‘ ，fk,就是/tmp的权限问题，害我干着急 3.报这个错误的原因有很多种，通过日志锁定错误的方式吧 服...
搞定，收工！Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)的解决方法标签：本文系统来源：http://www.cnblogs.com/hxyphp/p/4792964.html
本机登陆mysql数据库，报以下错误：# mysql -u root -p Enter password: ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2) 其它方式登陆尝试：# mysql ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2) # mysql -u root -h localhost -p Enter password: ERROR 2002 (HY000): Can‘t connect to lo...
1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动.另外看看是不是权限问题.2、确定你的mysql.sock是不是在那个位置，mysql -u 你的mysql用户名 -p -S /var/lib/mysql/mysql.sock3、试试：service mysqld start4、如果是权限问题，则先改变权限 #chown -R mysql:mysql /var/lib/mysql[root@localhost ~]# /etc/init.d/mysqld start启动 MySQL： [ 确定 ][root@localhost ~]# mysql -uroot -pERROR 2002 (HY000...
ps -A | grep -i mysql kill 列出来的进程 service mysql start 我的问题就解决了 ---------------------------------------------- Fedora8启动mysql 报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动.另外看看是不是权限问题.2、确定你的mysql.sock是不是在那个位置，mysql -u 你的mysql...
4、如果是权限问题，则先改变权限 #chown -R mysql:mysql /var/lib/mysql[root@localhost ~]# /etc/init.d/mysqld start启动 MySQL： [ 确定 ][root@localhost ~]# mysql -uroot -pERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)原因是，/var/lib/mysql 的访问权限问题。shell> chown -R mysql:mysql /var/lib/mysql接着启动服务器shell> /etc/init.d/mysql start服...
python MySQLdb这个模块是独立的，有自己独立的socket，解决的方法就是找出mysql配置里的socket的地址（比如socket=/tmp/mysql.sock），然后做个软连接 ln -s /tmp/mysql.sock /var/run/mysqld/mysql.sock OperationalError: (2002, “Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2)”)标签：本文系统来源：http://www.cnblogs.com/ziyunlong/p/5888238.html
mysql 登录不进去 提示Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2) shell> chown -R 777/var/lib/mysql 接着启动服务器 shell> /etc/init.d/mysql start 服务器正常启动后察看 /var/lib/mysql 自动生成mysql.sock文件成功开启进入mysql/var/lib/mysql 的访问权限问题 Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)标签：init ges cal chow...
启动mysql 报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动.另外看看是不是权限问题.2、确定你的mysql.sock是不是在那个位置，mysql -u 你的mysql用户名 -p -S /var/lib/mysql/mysql.sock3、试试：service mysqld start4、如果是权限问题，则先改变权限 #chown -R mysql:mysql /var/lib/m...