Ubuntu 环境下远程连接 MySQL 数据库

sudo apt-get update
sudo apt-get install mysql-server
sudo apt-get install libmysqlclient-dev

mysql -u root -p

REATE USER 'username'@'host' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'Ubuntu'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

revoke insert,update,delete,select ON *.* from 'Ubuntu'@'%' IDENTIFIED BY '123456';

flush privileges;

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

exit