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

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

1mysql -u root -p
2#输入密码，进入mysql客户
3use mysql
4GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root password...' WITH GRANT OPTION;
5FLUSH PRIVILEGES; #更新权限

忘记重设mysql 的root密码：

1vim /etc/my.cnf
2[mysqld] 
3datadir=/var/lib/mysql  
4socket=/var/lib/mysql/mysql.sock  
5skip-grant-tables #添加这行
6＃保存退出
7
8systemctl restart mysqld
9mysql -u root
10use mysql;
11#MySQL 5.7.6 以及最新版本：
12update user set authentication_string=PASSWORD('new password') where User='root';
13#MySQL 5.7.5 或更早之前的版本:
14update user set password=PASSWORD('new password') where User='root';

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

 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

解决方法：

在 /etc/my.cnf 文件里加上如下：
sql_mode='NO_ENGINE_SUBSTITUTION'
重启Mysql服务

mariadb安装：

1mariadb安装：
2yum install mariadb-server mariadb
3
4mariadb数据库的相关命令是：
5systemctl start mariadb  #启动MariaDB
6systemctl stop mariadb  #停止MariaDB
7systemctl restart mariadb  #重启MariaDB
8systemctl enable mariadb  #设置开机启动
9
10初始化：
11mysql_secure_installation
12
13mariadb配置允许远程访问方式：
14mysql -u root -p
15GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '20161130' WITH GRANT OPTION;
16flush privileges;