Centos下mysql

1. 查看安装后的临时密码

   grep "temporary password" /var/log/mysqld.log

2. 跳过密码登录验证

   修改文件vi /etc/my.cnf

   添加skip-grant-tables

   重启service mysqld restart

3. 警告：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

   执行：flush privileges;

4. 不小心删了/var/lib/mysql,如何初始化mysql库

   删除数据，启动则自动初始化

   rm -rf /var/lib/mysql

   service mysqld restart