亚洲精品久久久久久第一页-人妻少妇精彩视品一区二区三区-91国产自拍免费视频-免费一级a在线播放视频正片-少妇天天日天天射天天爽-国产大屁股喷水视频在线观看-操美女骚穴抽插性爱视频-亚洲 欧美 中文字幕 丝袜-成人免费无码片在线观看

  1. 首頁(yè) > 生活知識(shí) > >

linux普通用戶修改root密碼 linux修改root密碼命令

生活百科linux


linux普通用戶修改root密碼 linux修改root密碼命令

文章插圖
停止數(shù)據(jù)庫(kù)如果是apt-get或yum安裝的mysql執(zhí)行：
systemctl stop mysqld修改my.cnf利用vim命令打開(kāi)mysql配置文件my.cnf，在mysqld進(jìn)程配置文件中添加skip-grant-tables,添加完成后,執(zhí)行wd保存 。
vi /etc/my.cnf[mysqld]skip-grant-tables重啟數(shù)據(jù)庫(kù)利用命令行工具重啟數(shù)據(jù)庫(kù)
systemctl start mysqld修改root密碼重啟數(shù)據(jù)庫(kù)后可以不用密碼直接回車(chē)登陸：
./mysql -p Enter password:可以直接登陸進(jìn)數(shù)據(jù)庫(kù) 。
在mysql命令行下執(zhí)行以下命令修改root密碼：
update mysql.user set password=password('newpassword') where user='root'#將password()中的newpassword字符更改為你自己的密碼
mysql5.7及以上版本注意
當(dāng)使用update user set passsword=password(“123456″) where user=”root”;修改root密碼時(shí)會(huì)提示如下錯(cuò)誤：
ERROR 1054 (42S22): Unknown column 'passsword' in 'field list'這是因?yàn)樵贛ySQL 5.7 password字段已從mysql.user表中刪除，新的字段名是“authenticalion_string”.
可使用use mysql; desc user;查看如下：
+------------------------+-----------------------------------+------+-----+-----------------------+-------+ | 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;重啟數(shù)據(jù)庫(kù)密碼修改完成后，將my.cnf文件中添加的skip-grant-tables語(yǔ)句注釋或刪除掉，然后重啟數(shù)據(jù)庫(kù)即可


以上關(guān)于本文的內(nèi)容，僅作參考！溫馨提示：如遇健康、疾病相關(guān)的問(wèn)題，請(qǐng)您及時(shí)就醫(yī)或請(qǐng)專業(yè)人士給予相關(guān)指導(dǎo)!

「愛(ài)刨根生活網(wǎng)」www.malaban59.cn小編還為您精選了以下內(nèi)容，希望對(duì)您有所幫助：