遇到的问题是:mysql不能登录
[root@slave1 mysql]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
首先检查mysqld是否启动:service mysql status,发现没有启动,于是,运行service mysqld start,但是报错如下:
[root@slave1 log]# service mysqld start Another MySQL daemon already running with the same unix socket. 正在启动 mysqld:
最后解决:把mysql.sock备份并移动
执行mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
service mysqld start成功启动mysql。
mysql 执行带中文字符的sql乱码:
set names utf8;