小项目搭建服务器安装mysql

拿到服务器第一步

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

外部访问服务器要设置安全组