Mysql数据库--修改root密码的几种方法(忘记密码&知道密码) 🔻一、知道密码情况--修改root密码⛳ 1.1 方式1:`alter` 命令修改⛳ 1.2 方式2:`s
alter
命令修改alter user root identified by '新密码';
mysql> use mysql;mysql> alter user root@'localhost' identified by 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql>
set passWord
命令修改set password for 用户名@'用户地址' = '新密码';
mysql> use mysql;mysql> set password for 'root'@'localhost' = 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql>
--init-file
选项启动mysql[root@db-server ~]# systemctl stop mysqld[root@db-server ~]# systemctl status mysqld● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Wed 2023-06-07 11:11:00 CST; 51min aGo Docs: man:mysqld(8) Http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 2450 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE) Process: 2426 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 2450 (code=exited, status=1/FAILURE) Status: "Server shutdown complete" Error: 13 (Permission denied)Jun 07 11:11:00 db-server systemd[1]: Starting MySQL Server...Jun 07 11:11:00 db-server systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILUREJun 07 11:11:00 db-server systemd[1]: Failed to start MySQL Server.Jun 07 11:11:00 db-server systemd[1]: Unit mysqld.service entered failed state.Jun 07 11:11:00 db-server systemd[1]: mysqld.service failed.[root@db-server ~]#
[root@db-server home]# touch init-file[root@db-server home]# vi init-file[root@db-server home]# cat init-file alter user 'root'@'localhost' identified by 'Zyl@123321';[root@db-server home]# pwd/home[root@db-server home]#
[root@db-server home]# chmod 777 init-file[root@db-server home]# chown mysql:mysql init-file[root@db-server home]# lltotal 4-rwxrwxrwx 1 mysql mysql 58 Jun 7 15:56 init-file[root@db-server home]#
###启动命令####mysqld --init-file=/home/init-file --user=mysql &[root@db-server ~]# mysqld --init-file=/home/init-file --user=mysql &[1] 1983[root@db-server ~]#
mysql -u root -pZyl@123321
[root@db-server home]# ps -ef | grep mysqlmysql 1983 1 1 16:28 ? 00:00:13 mysqld --init-file=/home/init-file --user=mysqlroot 2104 2048 0 16:50 pts/1 00:00:00 systemctl start mysqldmysql 2134 1 1 16:50 ? 00:00:00 /usr/sbin/mysqldroot 2150 2048 0 16:50 pts/1 00:00:00 grep --color=auto mysql[root@db-server home]# kill -9 1983
####正常启动mysql###[root@db-server home]# systemctl start mysqld[root@db-server home]# systemctl status mysqld
alter user root identified by '新密码';
mysql> use mysql;mysql> alter user root@'localhost' identified by 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql> mysql>
set password for 用户名@'用户地址' = '新密码';
mysql> use mysql;mysql> set password for 'root'@'localhost' = 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql>
skip-grant-tables
参数,跳过授权验证[root@db-server ~]# systemctl stop mysqld
--skip-grant-tables
参数启动mysql服务[root@db-server ~]# sudo mysqld --skip-grant-tables --user=mysql &[1] 2531[root@db-server ~]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 7Server version: 8.0.32 MySQL CommUnity Server - GPLCopyright (c) 2000, 2023, oracle and/or its affiliates.Oracle is a reGIStered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
skip-grant-tables
参数启动mysql服务注:修改完密码之后,去除该参数--以便保障数据库安全性
。
[root@db-server ~]# vi /etc/my.cnf####添加内容:skip-grant-tables
[root@db-server home]# systemctl start mysqld
alter user root identified by '新密码';
mysql> use mysql;mysql> alter user root@'localhost' identified by 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql> mysql>
set password for 用户名@'用户地址' = '新密码';
mysql> use mysql;mysql> set password for 'root'@'localhost' = 'Zyl@123456';Query OK, 0 rows affected (0.01 sec)mysql>
注:修改完密码之后,去除 skip-grant-tables 参数--以便保障数据库安全性
。
❓ 本篇文章详细介绍了在linux中忘记mysql的root用户密码修改步骤。❓ 温馨提示:不管是工作中,还是学习中,要养成备份的习惯,不要觉得太麻烦,或者觉得没必要,不要存在侥幸心理。❓ 人有的时候总觉得很多事可以偷懒,但是有时候又要为自己的偷懒付出更大的代价。
👈【上一篇】 | 💖The End💖 点点关注,收藏不迷路💖 | 【下一篇】👉 |
来源地址:https://blog.csdn.net/qq_41840843/article/details/131073027
--结束END--
本文标题: Mysql数据库--修改root密码的几种方法(忘记密码&知道密码)
本文链接: https://www.lsjlt.com/news/403269.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0