//新增用户
grant all privileges on *.* to root@'%' identified by "root";//立即生效
flush privileges;grant select,insert,update,delete,create,drop on to joe@10.163.225.87 identified by ‘123′;grant all on xxxDB.* to xxx@'%';
#
MySQL提示“Checking for tables which need an upgrade, are corrupt or were not closed cleanly”
$ sudo service mysql stop
$ sudo /etc/init.d/apparmor reload
$ sudo service mysql start
或者:
down vote
This error occurs due to multiple installations of mysql. Run the command:
$ ps -A|grep mysql
Kill the process by using:
$ sudo pkill mysql
and then run command:
$ ps -A|grep mysqld
Also Kill this process by running:
$ sudo pkill mysqld
Now you are fully set just run the following commands:
$ service mysql restart
mysql -u root -p