1丽啡、設(shè)置遠(yuǎn)程登錄:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
2谋右、修改用戶密碼,以root為例
- 知道root密碼碌上,需要修改
方法a. 登入數(shù)據(jù)庫(kù)來(lái)修改
# mysql -uroot -p /*輸入密碼進(jìn)入*/
/*第一個(gè)方式:直接編輯數(shù)據(jù)庫(kù)字段*/
MariaDB [(none)]> use mysql;
MariaDB [mysql]> UPDATE user SET password=password('newpassword') WHERE user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit
/*第二個(gè)方式:修改密碼倚评,不用進(jìn)入mysql*/
MariaDB [(none)]> SET password for 'root'@'localhost'=password('newpassword');
MariaDB [(none)]> exit;
忘記密碼:
# systemctl stop mariadb /*先停掉當(dāng)前的mysql進(jìn)程,不然執(zhí)行下一步說(shuō)進(jìn)程已經(jīng)存在*/
# mysqld_safe --skip-grant-tables & /*后臺(tái)直接這個(gè)mysql馏予,界面中還會(huì)出現(xiàn)日志,直接ctrl+c進(jìn)入命令行輸入*/
# ps -ef | grep mariadb /*看進(jìn)程盔性,會(huì)突出顯示--skip-grant-tables*/
mysql 3607 3368 0 18:05 pts/0 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql
--plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --log-error=/var/log/mariadb/mariadb.log
--pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
# mysql /*直接進(jìn)入mysql霞丧,不需要密碼等,執(zhí)行第一步中方法a里兩種方式中任何一種即可*/
MariaDB [(none)]> use mysql;
MariaDB [mysql]> UPDATE user SET password=password('newpassword') WHERE user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit; /*這個(gè)時(shí)候用參數(shù)--skip-grant-tables啟動(dòng)的mysql已經(jīng)會(huì)要求輸入密碼才能進(jìn)入了*/
# pkill mysql /*用pkill來(lái)殺,kill不死冕香,kill之后自動(dòng)起來(lái)一個(gè)*/
# systemctl start mariadb /*啟動(dòng)正常的mysql*/