Ubuntu

1 sudo apt-get update

2 sudo apt-get install mysql-server

3 sudo mysql_secure_installation # 初始化配置#1VALIDATE PASSWORD PLUGIN can be used to test passwords...Press y|Y for Yes, any other key for No: N (我的选项)#2Please set the password for root here...New password: (输入密码)Re-enter new password: (重复输入)#3By default, a MySQL installation has an anonymous user,allowing anyone to log into MySQL without having to havea user account created for them...Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (我的选项)#4Normally, root should only be allowed to connect from'localhost'. This ensures that someone cannot guess atthe root password from the network...Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (我的选项)#5By default, MySQL comes with a database named 'test' thatanyone can access...Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (我的选项)#6Reloading the privilege tables will ensure that all changesmade so far will take effect immediately.Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (我的选项)4 systemctl status mysql.service # 检查服务器状态

4 systemctl status mysql.service # 检查服务器状态

5 修改mysql 端口号以及将监听地址改为所有 vim /etc/mysql/mysql.conf.d/mysqld.cnf # 编辑配置文件 bind-address            = 0.0.0.0  #将监听ip修改为所有 port            = 3388  # 监听端口修改为3388，可以不改我这是为了安全修改完毕之后重启服务systemctl restart mysql.service 

6 开放mysql远程访问1 登录数据库mysql -u root -p2 切换到数据库mysqluse mysql3 删除匿名用户delete from user where user='';4 增加允许远程访问的用户或者允许现有用户的远程访问给root授予在任意主机（%）访问任意数据库的所有权限mysql> grant all privileges on *.* to 'root'@'%' identified by '这里替换成你想要设置的密码' with grant option;flush privileges;5 退出数据库mysql> exit6 重启数据库sudo service mysql restart