解决问题:修改密码
第一步:进/etc/my.cnf (自行修改过的如:my.cnf.bak)查看
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid是否被注释掉
修改为:
pid-file=/var/run/mariadb/mariadb.pid
修改my.cnf文件bind-address = 0.0.0.0
第二步:修改密码
service mysql stop
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables
此时能看到
180918 11:31:18 mysqld_safe Logging to '/usr/local/mysql/data/zzs.err'.
180918 11:31:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
再打开另一个控制台登陆
./mysql -u root
use mysql
update user set password=password("root") where user="root";
flush privileges;
exit
ps -A | grep mysql
32486 ? 00:00:00 mysqld_safe
32608 ? 00:00:03 mysqld
杀掉:kill -9 32486 32608
启动mysql:service mysql start
此时远程已经可以访问了。