修改MySQL的root用户的密码以及打开远程连接
[root@localhost mysql]# mysql -u root mysql
mysql> use mysql;
mysql> desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力
mysql> update user set Password = password('123456') where User='root'; //设置root用户密码
mysql> select Host,User,Password from user where User='root';
mysql> flush privileges; mysql> exit
重新登录
[root@localhost mysql]# mysql -u root -p Enter password:123456
若还不能进行远程连接,关闭防火墙
[root@localhost]# /etc/rc.d/init.d/iptables stop
启动mysql systemctl start mariadb.service 或者 systemctl start mysqld.service 结束 systemctl stop mariadb.service 或者 systemctl stop mysqld.service 重启 systemctl restart mariadb.service 或者 systemctl restart mysqld.service 开机自启 systemctl enable mariadb.service 或者 systemctl enable mysqld.service
登录MYSQL
--本地连接 mysql –uroot -p --远程连接 mysql –uwgb –hXXX.XXX.XXX.XXX –p