腾讯云主机Ubuntu1804配置MySQL服务器

# 安装

sudo apt update

sudo apt install mysql-server

 

# 初始化

sudo mysql_secure_installation

#1  VALIDATE PASSWORD PLUGIN can be used to test passwords...     Press y|Y for Yes, any other key for No: n

#2  Please set the password for root here...     New password: ********     Re-enter new password: ********

#3  By default, a MySQL installation has an anonymous user,  allowing anyone to log into MySQL without having to have a user account created for them...     Remove anonymous users? (Press y|Y for Yes, any other key for No) : N

#4  Normally, root should only be allowed to connect from  'localhost'. This ensures that someone cannot guess at  the root password from the network...     Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y 

#5  By default, MySQL comes with a database named 'test' that  anyone can access...     Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N

#6  Reloading the privilege tables will ensure that all changes  made so far will take effect immediately.     Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y

 

# 检查服务状态

systemctl status mysql.service

 

# 配置远程访问

sudo mysql -uroot -p

mysql> grant all privileges on *.* to root@localhost identified by "********";

 

# 新建数据库和用户

mysql> create database xcbase ;        //创建数据库xcbase

mysql> grant all privileges on xcbase.* to robotxc @"%" identified by "********";        //创建用户robotxc并允许其可以从任意机器登入xcbase数据库

 

# 使用SQLyog连入服务器数据库

新建连接，输入主机地址，用户名，密码，端口3306，连接即可

 

# 开放服务器3306端口

如果出现无法连接的问题，需要手动开启3306端口。

1.进入腾讯云控台，新建安全组出入站规则（TCP:3306）并配置到目标云主机上

2.修改mysql的配置文件，先打开/etc/mysql/my.cnf，找到其包含目录下/etc/mysql/mysql.conf.d/mysqld.cnf，修改如下条目

[mysqld]

port=3306

bind-address=0.0.0.0