apt-get install mysql-server
y
123456
whereis mysql
cd /etc/mysql/conf.d
cat mysqldump.cnf
修改16M(改大一点)
cd /etc/mysql/mysql.conf.d
vim mysqld.cnf
cd /var/lib/mysql(数据库存放位置)
cd /etc/mysql/mysql.conf.d
vim mysqld.cnf
bind-address =0.0.0.0 (这样就远程连接数据库)
service mysql restart
mysql -u root -p
123456
mysql > grant all privileges on *.* to 'root'@'%' identified by '123456';
公网访问
修改自带的mysql user表。
mysql > grant all privileges on *.* to 'root'@'%' identified by '123456';
flush privileges;
阿里云安全设置上开启端口范围。