【MySql】Change the root password

悠悠 2024-02-19 13:23 18阅读 0赞

At the initial start up of the server, the following happens, given that the data directory of the server is empty:

*  The server is initialized.
 *  SSL certificate and key files are generated in the data directory.
 *  validate\_password is installed and enabled.

A superuser account ‘root’@'localhost is created. A password for the superuser is set and stored in the error log file. To reveal it, use the following command:

shell> sudo grep 'temporary password' /var/log/mysqld.log

Change the root password as soon as possible by logging in with the generated, temporary password and set a custom password for the superuser account:

shell> mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; #Don't miss ‘；’

> **Note**  
> validate\_password is installed by default. The default password policy implemented by validate\_password requires that passwords contain at least one upper case letter, one lower case letter, one digit, and one special character, and that the total password length is at least 8 characters.

发表评论取消回复

表情：

评论列表（有 0 条评论，18人围观）

还没有评论，来说两句吧...

相关阅读

相关【MySql】Change the root password

At the initial start up of the server, the following happens, given that the data direct

悠悠/ 2024年02月19日 13:23/ 0 赞/ 19 阅读

相关 Mirroring the root volume group

Mirroring the root volume group Last Updated: 2023-03-24 The following scenario expl

Dear 丶/ 2023年10月14日 16:41/ 0 赞/ 36 阅读

相关 ubuntu mysql root password忘记解决办法

登录 mysql -u debian-sys-maint -p 密码在/etc/mysql/debian.cnf里；执行如下命令； mysql> use mysql;

红太狼/ 2023年02月20日 06:41/ 0 赞/ 2 阅读

相关 Oracle- (ORA-28001: the password has expired)

Oracle- （ORA-28001: the password has expired）内容：一、问题二、解决方法内容：

偏执的太偏执、/ 2022年12月28日 06:22/ 0 赞/ 16 阅读

相关 Access denied for user 'root'@ '...' (using password: YES)

在我们连接数据库的时候，有时会出现“Access denied for user ‘root’@ ‘...’ (using password: YES)”错误提示，出现这个问题

布满荆棘的人生/ 2022年10月02日 07:00/ 0 赞/ 77 阅读

相关 Root Password Injection Into Openstack Instance

To inject a root password into Openstack instance on Nova boot, you need to enable it. F

秒速五厘米/ 2022年07月16日 23:56/ 0 赞/ 82 阅读

相关 MySQL—— How to reset the root password

Steps to change password when you have forgotten: 1. Stop MySQL Server /etc/in

淡淡的烟草味﹌/ 2022年03月21日 11:46/ 0 赞/ 177 阅读

相关 ORA-28002 the password will expire

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 转载于:https://www.cnblogs.c

曾经终败给现在/ 2021年11月10日 07:02/ 0 赞/ 160 阅读

相关 CentOS切换root用户一直提示Incorrect password

su是切换用户命令，su root时，输入正确的root命令，却提示Incorrect password，当前用户为普通用户，遇到此问题该如何解决呢？如果设置了whee

深碍√TFBOYSˉ_/ 2021年11月01日 07:50/ 0 赞/ 570 阅读

相关 Access denied for user ‘root‘@‘localhost‘ (using password: YES)

早上还能正常连接数据库,然后搞了一下linux命令,弄了nfs,telnet什么的,再回来数据库就连不了了.Access denied for user 'root'@'loc

柔情只为你懂/ 2021年09月25日 02:32/ 0 赞/ 274 阅读