deepin mysql管理器_deepin mysql安装

1.安装mysql

更新仓库：sudo apt-get update

安装：sudo apt-get install mysql-server mysql-client

问题：安装mysql5.7的过程中 无root密码设置提示 直接安装完成结束

2.不知道密码状态下打开mysql

查询mysql是否运行：sudo netstat -tap |grep mysql

(有显示就表示已运行)

备注：mysql 打开(service mysql start) 关闭(service mysql stop) 重启命令(service mysql restart)

查询默认的用户名和密码：sudo cat /etc/mysql/debian.cnf

baiguo@baiguo-PC:~$ sudo cat /etc/mysql/debian.cnf

# Automatically generated for Debian scripts. DO NOT TOUCH!

[client]

host     = localhost

user     = debian-sys-maint

password = F64nKZ233QkzL8v9

socket   = /var/run/mysqld/mysqld.sock

[mysql_upgrade]

host     = localhost

user     = debian-sys-maint

password = F64nKZ233QkzL8v9

socket   = /var/run/mysqld/mysqld.sock

备注：这样比较麻烦，无法复制密码，可以直接打开你的文件管理器，用管理员身份打开debian.cnf即可查看复制密码

利用默认账户进行登录：mysql -u debian-sys-maint -p(文件中的密码，与p之间不要有空格)

3.进入mysql修该密码

这句必须：update mysql.user set plugin="mysql_native_password" where user="root";

设置root账户密码：update mysql.user set authentication_string=password('这里是你的密码') where user='root'and Host = 'localhost';

4.退出数据库

exit

重新启动数据库

sudo service mysql restart

用自己设置好的密码登录

mysql -u root -p

输入密码,成功登录,如下.

baiguo@baiguo-PC:~$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.7.21-1 (Debian)

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>

原文链接:https://bbs.deepin.org/forum.php?mod=viewthread&tid=169658