1.安装mysql
更新仓库:
sudo apt-get update
安装:
sudo apt-get install mysql-server mysql-client
直接安装完成结束
2.不知道密码状态下打开mysql
查询mysql是否运行:
systemctl status mysql
备注:mysql 打开(systemctl start mysql) 关闭(systemctl stop mysql) 重启命令(systemctl restart mysql)
查询默认的用户名和密码:
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修该密码
设置root账户密码:
CREATE USER 'root'@'%' IDENTIFIED with mysql_native_password BY '这里是你要设置的密码'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; flush privileges;
4.退出数据库
exit
5.用自己设置好的密码登录
mysql -u root -p
输入密码,成功登录,如下.
jokul@jokul-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: 8.0.24-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>
恭喜你,同学 你成功了!
PS:推荐DEEPIN上连接数据库工具用”dbeaver-ce”