Mysql 常见使用场景

数据库

1、将DBName数据库的所有控制权限授予UserName用户。

GRANT ALL PRIVILEGES ON DBName.* TO UserName@'%'; 

2、Mysql关闭或启用外键

Mysql禁用外键

SET FOREIGN_KEY_CHECKS = 0

Mysql启用外键

SET FOREIGN_KEY_CHECKS = 1

3、安装Mysql时出现错误

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

则使用如下方式解决：

ln -s /var/lib/mysql /mysql .sock /tmp/mysql .sock

4、开启Mysql账户远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

5、Mysql客户端命令启用

ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

6、查看Mysql 错误日志

cd /usr/local/mysql/data

会发现有一个后缀为 err 文件，文件名一般为电脑名称，即可在此文件中查看Mysql错误信息

tail -f localhost.localdomain.err

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '66231088' WITH GRANT OPTION;

7、 Centos6.5使用yum安装mysql

http://blog.csdn.net/xxd851116/article/details/22947891