Mysql运维

[ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock

[ERROR] Unable to setup unix socket lock file.

进入/tmp/查看mysql.sock.lock，文件大小为0，直接删除该文件rm -rf mysql.sock.lock
再启动mysql：service mysqld start。即可启动成功

Your password does not satisfy the current policy requirements

//更改密码策略
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

ERROR 1366 (HY000): Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column ‘name’ at row 1

vi /etc/my.cnf

character-set-server=utf8
show create database a;
drop database a;
create database a;

Starting MySQL ERROR! Couldn’t find MySQL server (/usr/local/mysql/bin/mysqld_safe)

//可能和之前安装的mysql冲突
find / -name mysql
/etc/init.d/mysqld

rm -rf /etc/init.d/mysqld

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

//开启super权限
mysql> select super_priv from mysql.user where user = 'xyp9x';
mysql> update mysql.user set super_priv='Y' where user='xyp9x';
mysql> flush privileges;