1.第一步 : mysql -u root -p
2.第二步 : GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
3.第三步 : flush privileges;
4.第四步 :bind-address=0.0.0.0,加在/etc/mysql/mysql.conf.d/mysqld.cnf
配置文件里.
防止乱码 character-set-server=utf8(在mysqld.cnf
中的[mysqld] 下)
5.第五步:service mysql restart