Ubuntu 18.04.4安装mysql的过程详解 亲测可用

下面看下Ubuntu 18.04.4安装mysql的过程，内容如下所示：

1 sudo apt-get update 2 sudo apt-get install mysql-server 3 sudo mysql_secure_installation # 初始化配置 #1 VALIDATE PASSWORD PLUGIN can be used to test passwords… Press y|Y for Yes, any other key for No: N (我的选项) #2 Please set the password for root here… New password: (输入密码) Re-enter new password: (重复输入) #3 By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them… Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (我的选项) #4 Normally, root should only be allowed to connect from localhost. This ensures that someone cannot guess at the root password from the network… Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (我的选项) #5 By default, MySQL comes with a database named test that anyone can access… Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (我的选项) #6 Reloading the privilege tables will ensure that all changes made 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 # 检查服务器状态

running代表无问题

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 -p 2 切换到数据库mysql use mysql 3 删除匿名用户 delete from user where user=; 4 增加允许远程访问的用户或者允许现有用户的远程访问 给root授予在任意主机（%）访问任意数据库的所有权限 mysql> grant all privileges on *.* to root@% identified by 这里替换成你想要设置的密码 with grant option; flush privileges; 5 退出数据库 mysql> exit 6 重启数据库 sudo service mysql restart