mysql5.7授权root远程登录_mysql5.7忘记root密码，mariadb，授权远程访问

授权远程访问mysql超级用户远程访问：

mysql -u root -p

#输入密码，进入mysql客户

use mysql

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root password...' WITH GRANT OPTION;

FLUSH PRIVILEGES; #更新权限

忘记重设mysql 的root密码：

vim /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-grant-tables #添加这行

＃保存退出

systemctl restart mysqld

mysql -u root

use mysql;

#MySQL 5.7.6 以及最新版本：

update user set authentication_string=PASSWORD('new password') where User='root';

#MySQL 5.7.5 或更早之前的版本:

update user set password=PASSWORD('new password') where User='root';

Mysql5.7的运行SQL语句文件的时候会报下面错误：

of ORDER BY clause is not in GROUP BY clause and contains nonagg