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

image.png

安装MySQL

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

登录 MySQL

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';

然后打开 vi /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address = 127.0.0.1

设置成bind-address = 0.0.0.0（设备地址）

腾讯云出现权限不够的问题：
http://bbs.qcloud.com/thread-11554-1-1.html

重新启动（命令如下）：

/etc/init.d/mysql stop

/etc/init.d/mysql start

执行 flush privileges;命令立即生效

flush privileges;

查询数据库的用户（看到如下内容表示创建新用户成功了）

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

使用exit命令退出MySQL

exit