数据库#1698 - Access denied for user [email protected]解决方法

每次安装都会出现这个问题,这次在此记录一下,嘻嘻
问题如下:
数据库#1698 - Access denied for user [email protected]解决方法
解决方法:
sudo mysql -u root -p
数据库#1698 - Access denied for user [email protected]解决方法
use mysql;
select User,authentication_string,Host from user;
drop user [email protected]‘localhost’;
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘密码’; #可改其他用户
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;

数据库#1698 - Access denied for user [email protected]解决方法
数据库#1698 - Access denied for user [email protected]解决方法
加油!!!
数据库#1698 - Access denied for user [email protected]解决方法