- 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
到此这篇关于Ubuntu 18.04.4安装mysql的过程详解 亲测可用的文章就介绍到这了,更多相关Ubuntu 18.04.4安装mysql内容请搜索w3xue以前的文章或继续浏览下面的相关文章希望大家以后多多支持w3xue!