Ubuntu18.04 安装Mysql

1. 更新资源

#命令1
sudo apt-get update
#命令2
sudo apt-get install mysql-server

2. 初始化配置

sudo mysql_secure_installation

3. 检查mysql服务状态

systemctl status mysql.service

新建用户/数据库

CREATE USER 'admin'@'%' IDENTIFIED BY '654312';

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '654312' with grant option;

FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS hmi DEFAULT CHARSET utf8 COLLATE utf8_bin;

 CREATE DATABASE IF NOT EXISTS htc1100 DEFAULT CHARSET utf8 COLLATE utf8_bin;

CREATE DATABASE IF NOT EXISTS htc1100_alarm_log DEFAULT CHARSET utf8 COLLATE utf8_bin;

exit

4. 配置远程连接

# 注意：不同 mysql 版本此配置文件位置和名字可能不同

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf # mysql 5.7.23

#找到将bind-address = 127.0.0.1注销
#bind-address      = 127.0.0.1
bind-address      = 0.0.0.0

5. 修改后，重启MySQL服务器

sudo /etc/init.d/mysql restart

6. 检查MySQL服务器占用端口

netstat -nlt|grep 3306