Millton0518的专栏

为mysql创建新用户后，使用root用户登录，进行授权，发现以下错误：翻阅了很多csdn文章，瞎掰的太多了。mysql> grant all on performance_schema.* to 'testuser'@'%';ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'performance_schema'mysql> grant all on infor...

登录mysql ，执行以下语句update mysql.user set authentication_string=PASSWORD("密码") where user='root';update mysql.user set plugin="mysql_native_password";flush privileges;quit;重启mysql服务service mysql restart;或者/etc/init.d/mysql restart...