#设置root密码
MariaDB [(none)]> use mysql;
MariaDB [mysql]> update user set plugin='mysql_native_password' where user='root';
MariaDB [mysql]> UPDATE user SET password=PASSWORD('root的密码') WHERE user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit;#操作Mysql
$ sudo /etc/init.d/mysql restart
# mysql的其他操作 status、start、stop、restart#开启远程访问
$ sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
# 将bind-address这行注释掉# 或者将127.0.0.1 这个值改为 0.0.0.0# 然后重启
$ sudo /etc/init.d/mysql restart
#设置账号权限
$ mysql -u root -p
$ 输入密码
MariaDB [(none)]> use mysql;
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root的密码' WITH GRANT OPTION;
MariaDB [mysql]> flush privileges;# 设置mysql外网访问
1. 首先需要通过配置路由器内的端口映射来解决外网穿透的问题
2. 修改表,登录mysql数据库,切换到mysql数据库,使用sql语句查看"select host,user from user ;"
mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
mysql>flush privileges;# 注意:最后一句很重要,目的是使修改生效.如果没有写,则还是不能进行远程连接.
3. 授权用户,你想root使用密码从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
flush privileges;
4. 如果你想允许用户root从ip为192.168.1.104的主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.104' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
flush privileges;
5. 修改MySql密码,在MySQL 5.7 password字段已从mysql.user表中删除,新的字段名是“authenticalion_string”.#选择数据库:
use mysql;#更新root的密码:
update user set authentication_string=password('新密码') where user='root' and Host='localhost';#刷新权限:
flush privileges;