在MariaDB配置文件/etc/f [mysqld]中加入skip-grant-tables一行:
[Richard@localhost ~]$ sudo vi /etc/f
[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockskip-grant-tables#加入这一行# Disabling symbolic-links is reco
重启服务:
[Richard@localhost ~]$ sudo systemctl restart mariadb.service
进入MariaDB修改root密码:
[Richard@localhost ~]$ mysqlWelcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026Copyright (c) 2000, , Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedMariaDB [mysql]> show tables-> ;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || event || func || general_log|| help_category || help_keyword || help_relation || help_topic|| host || ndb_binlog_index|| plugin|| proc || procs_priv|| proxies_priv || servers || slow_log || tables_priv|| time_zone || time_zone_leap_second|| time_zone_name || time_zone_transition|| time_zone_transition_type || user |+---------------------------+24 rows in set (0.00 sec)MariaDB [mysql]> UPDATE user SET Password = password ( '123456 ) WHERE User = 'root' ; Query OK, 4 rows affected (0.03 sec)Rows matched: 4 Changed: 4 Warnings: 0MariaDB [mysql]> flush privileges;Query OK, 0 rows affected (0.01 sec)MariaDB [mysql]> exit
重启服务即可登陆:
[Richard@localhost ~]$ sudo systemctl restart mariadb.service[Richard@localhost ~]$ mysql -u root -pEnter password: Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026Copyright (c) 2000, , Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> exit