本文由 发布，转载请注明出处，如有问题请联系我们！ 发布时间: 2021-08-01linux修改root密码命令-linux普通用户修改root密码

终止数据库查询

假如由apt-get或yum安装mysql程序执行:

systemctl stop mysqld

改动my.cnf

应用vim命令开启mysql环境变量my.cnf，在mysqld过程环境变量中加上skip-grant-tables，随后实行wd save。

vi /etc/my.cnf[mysqld]skip-grant-tables

重启数据库查询。

应用命令行工具重启数据库查询。

systemctl start mysqld

改动根登陆密码。

重启数据库查询后，您能够在沒有登陆密码的情形下立即键入和登陆:

./mysql -p Enter password:

你能立即登陆数据库查询。

在mysqlcmd中实行下列指令来改动根登陆密码:

update mysql.user set password=password('newpassword') where user='root'

#将password()中的密码标识符更改成您自身的登陆密码。

关心mysql5.7及之上版本号。

应用升级客户集passsword = password ("123456 ")，在其中user = " root变更根登陆密码时，将提醒下面不正确:

ERROR 1054 (42S22): Unknown column 'passsword' in 'field list'

缘故是MySQL 5.7中的登陆密码字段名早已从mysql.user表格中删掉，新的列名为“authenticalion _ string”。

应用mysqldesc客户；见下文:

------------------------ ----------------------------------- ------ ----- ----------------------- ------- | Field | Type | Null | Key | Default | Extra | ------------------------ ----------------------------------- ------ ----- ----------------------- ------- | Host | char(60) | NO | PRI | | | | User | char(32) | NO | PRI | | | | Select_priv | enum('N','Y') | NO | | N | | | Insert_priv | enum('N','Y') | NO | | N | | | Update_priv | enum('N','Y') | NO | | N | | | Delete_priv | enum('N','Y') | NO | | N | | | Create_priv | enum('N','Y') | NO | | N | | | Drop_priv | enum('N','Y') | NO | | N | | | Reload_priv | enum('N','Y') | NO | | N | | | Shutdown_priv | enum('N','Y') | NO | | N | | | Process_priv | enum('N','Y') | NO | | N | | | File_priv | enum('N','Y') | NO | | N | | | Grant_priv | enum('N','Y') | NO | | N | | | References_priv | enum('N','Y') | NO | | N | | | Index_priv | enum('N','Y') | NO | | N | | | Alter_priv | enum('N','Y') | NO | | N | | | Show_db_priv | enum('N','Y') | NO | | N | | | Super_priv | enum('N','Y') | NO | | N | | | Create_tmp_table_priv | enum('N','Y') | NO | | N | | | Lock_tables_priv | enum('N','Y') | NO | | N | | | Execute_priv | enum('N','Y') | NO | | N | | | Repl_slave_priv | enum('N','Y') | NO | | N | | | Repl_client_priv | enum('N','Y') | NO | | N | | | Create_view_priv | enum('N','Y') | NO | | N | | | Show_view_priv | enum('N','Y') | NO | | N | | | Create_routine_priv | enum('N','Y') | NO | | N | | | Alter_routine_priv | enum('N','Y') | NO | | N | | | Create_user_priv | enum('N','Y') | NO | | N | | | Event_priv | enum('N','Y') | NO | | N | | | Trigger_priv | enum('N','Y') | NO | | N | | | Create_tablespace_priv | enum('N','Y') | NO | | N | | | ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | | | ssl_cipher | blob | NO | | NULL | | | x509_issuer | blob | NO | | NULL | | | x509_subject | blob | NO | | NULL | | | max_questions | int(11) unsigned | NO | | 0 | | | max_updates | int(11) unsigned | NO | | 0 | | | max_connections | int(11) unsigned | NO | | 0 | | | max_user_connections | int(11) unsigned | NO | | 0 | | | plugin | char(64) | NO | | mysql_native_password | | | authentication_string | text | YES | | NULL | | | password_expired | enum('N','Y') | NO | | N | | | password_last_changed | timestamp | YES | | NULL | | | password_lifetime | smallint(5) unsigned | YES | | NULL | | | account_locked | enum('N','Y') | NO | | N | | ------------------------ ----------------------------------- ------ ----- ----------------------- ------- 45 rows in set (0.00 sec)

以上中的Authentication_string是密码字段名。您还可以采用之上字段名密码重置:

mysql> update user set authentication_string=password('123456') where user="root"; Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql> flush priviledges;

重启数据库查询。

更改密码后，注解或删掉my.cnf文档中加上的skip-grant-tables句子，随后重启数据库查询。

降落检测

应用密码再次登陆检测。