版本：Ubuntu_1804、mysql_5.7
sudo apt-get updatesudo apt-get install mysql-server-5.7-
vim /etc/mysql/mysql.conf.d/mysqld.cnf
注釋掉bind-address和skip-external-locking并保存 - mysql默認(rèn)username為root烤惊，密碼為空账嚎，
可以執(zhí)行sudo mysql_secure_installation按照提示初始化密碼略荡。 -
sudo mysql -u root進(jìn)入mysql命令行后褐捻，新建一個mysql管理員賬戶蹬叭。
參照：host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server
具體配置命令：
mysql> CREATE USER '${user_name}'@'localhost' IDENTIFIED BY '${some_pass}';
mysql> GRANT ALL PRIVILEGES ON *.* TO '${user_name}'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER '${monty}'@'%' IDENTIFIED BY '${some_pass}';
mysql> GRANT ALL PRIVILEGES ON *.* TO '${user_name}'@'%'
-> WITH GRANT OPTION;
- 使用mysql客戶端,輸入ip乡摹、端口预明、新建的mysql管理員賬戶缩赛、密碼即可登錄，大功告成撰糠。
