linux 下装lnmp配置mysql 的一些整理
linux连接mysql“Access denied for user 'root'@'localhost'”问题的解决
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# service mysqld restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql连接linux系统提示“登录出现1130 is not allowed to connect to this MySql server”问题,解决方法
运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
eg:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'root' WITH GRANT OPTION;
用户名和密码、IP换成自己的
1 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; 2 FLUSH PRIVILEGES; 3 UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; 4 FLUSH PRIVILEGES; 5 如果遇到10060,重启
你的指尖,有着改变世界的力量!