拿到服务器第一步
sudo apt-get update
sudo apt-get upgrade
第二步
安装mysql
3.mysql 5.7.27
3.1安装
https://dev.mysql.com/downloads/file/?id=477124 # 自己去下载
or
wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.6-1_all.deb
tab 选版本5.7 ok
sudo apt-get update
sudo apt-get install mysql-server
3.2配置
sudo service mysql stop
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
添加一行skip-grant-tables=1---无密码登陆
sudo service mysql start
命令行输入mysql
use mysql;
update user set plugin='mysql_native_password' where user='root';
update user set authentication_string=password('123456') where user='root' and Host = localhost';
update user set host='%' where user = 'root';# 设置外部访问要用
>flush privileges;
>quit
sudo service mysql stop
注释掉skip-grant-tables=1
sudo service mysql start
外部访问服务器要设置安全组