在centos系统上 ,Mysql 安装后,不用用户名和密码就能能登录
#mysql -uroot
在windows 系统下,同mysql管理工具连接提示无权限
解决办法:
1.#service mysql stop
2. Mysql> /usr/bin/mysqld_safe mysqld_safe --user=mysql --skip-grant-tables --skip-networking & mysql -u root mysql
3.mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pa4ssword' WITH GRANT OPTION
mysql> FLUSH PRIVILEGES
mysql> quit
4.# service mysql start