登录
首页 >  数据库 >  MySQL

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

来源:脚本之家

时间:2022-12-30 20:30:35 106浏览 收藏

本篇文章向大家介绍《Ubuntu 18.04.4安装mysql的过程详解 亲测可用》,主要包括MySQL、安装、Ubuntu18.04.4,具有一定的参考价值,需要的朋友可以参考一下。

下面看下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

到这里,我们也就讲完了《Ubuntu 18.04.4安装mysql的过程详解 亲测可用》的内容了。个人认为,基础知识的学习和巩固,是为了更好的将其运用到项目中,欢迎关注golang学习网公众号,带你了解更多关于mysql的知识点!

声明:本文转载于:脚本之家 如有侵犯,请联系study_golang@163.com删除
相关阅读
更多>
最新阅读
更多>
课程推荐
更多>
评论列表