Ubuntu18安装mysql

最新推荐文章于 2024-11-08 22:59:30 发布

奋斗中的墨小黑

最新推荐文章于 2024-11-08 22:59:30 发布

阅读量94

点赞数

分类专栏： Mysql 文章标签： mysql

本文链接：https://blog.csdn.net/sinat_36795793/article/details/100130629

版权

Mysql 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

安装
1. sudo apt update
2. sudo apt upgrade
3. sudo apt install mysql-server
4. sudo apt install mysql-client

发现安装过程中没有提示设置密码：

vim /etc/mysql/debian.conf

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = dBZPJZTi2IezJ9G2
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = dBZPJZTi2IezJ9G2
socket   = /var/run/mysqld/mysqld.sock

mysql -u debian-sys-maint -p
输入密码：<dBZPJZTi2IezJ9G2>

use mysql

update user set authentication_string=password('密码') where user='root';

update user set plugin='mysql_native_password';

flush privileges;

quit

/etc/init.d/mysql restart