共计 1886 个字符,预计需要花费 5 分钟才能阅读完成。
自动写代码机器人,免费开通
本篇文章为大家展示了怎么在 Ubuntu18.04 中安装 mysql5.7.23,内容简明扼要并且容易理解,绝对能使你眼前一亮,通过这篇文章的详细介绍希望你能有所收获。
1、安装服务器和客户端
# 安装 mysql 服务
sudo apt-get install mysql-server
# 安装客户端
sudo apt install mysql-client
# 安装依赖
sudo apt install libmysqlclient-dev
2、检查安装状态
# 检查状态
sudo netstat -tap | grep mysql
出现下图表示安装成功
3、安装完以后配置
mysql5.7 安装完成后普通用户不能进 mysql,原因:root 的 plugin 被修改成了 auth_socket,用密码登陆的 plugin 应该是 mysql_native_password,直接用 root 权限登录就不用密码, 修改 root 密码和登录验证方式
$ sudo su
# mysql
mysql
mysql select user, plugin from mysql.user;
+------------------+-----------------------+
| user | plugin |
+------------------+-----------------------+
| root | auth_socket |
| mysql.session | mysql_native_password |
| mysql.sys | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)
mysql update mysql.user set authentication_string=PASSWORD(123456), plugin= mysql_native_password where user= root
mysql flush privileges;
mysql exit
# exit
$ sudo /etc/init.d/mysql restart
$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22-0ubuntu18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type help; or \h for help. Type \c to clear the current input statement.
mysql
4、配置 mysql 远程登录
# 修改配置文件,注释掉 bind-address = 127.0.0.1
$ sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# 保存退出,然后进入 mysql 服务,执行授权命令:$ mysql -uroot -p
mysql grant all on *.* to root@ % identified by 123456 with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql exit
$ sudo /etc/init.d/mysql restart
上述内容就是怎么在 Ubuntu18.04 中安装 mysql5.7.23,你们学到知识或技能了吗?如果还想学到更多技能或者丰富自己的知识储备,欢迎关注丸趣 TV 行业资讯频道。
向 AI 问一下细节
正文完