# 安装
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