Linux环境解决Mysql权限不足
方法操作如下:
# /etc/init.d/MySQL stop(或者/etc/init.d/mysqld stop)
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
# mysql>use mysql ;
mysql> UPDATE user SET Password=PASSWORD('newpassword')where USER='root'and host='root'or host='localhost';//把空的用户密码都修改成非空的密码就行了。
mysql> FLUSH PRIVILEGES;
mysql> quit # /etc/init.d/mysqld restart
# mysql -uroot -p
Enter password:<输入新设的密码newpassword
文章转自:http://www.sojson.com/blog/197.html