linux自带mariadb初始密码,linux 下修改MariaDB root密码

在MariaDB配置文件/etc/my.cnf  [mysqld]中加入skip-grant-tables一行：mysql

[Richard@localhost ~]$ sudo vi /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-grant-tables　　　　#加入这一行

# Disabling symbolic-links is reco

重启服务：sql

[Richard@localhost ~]$ sudo systemctl restart mysql.service

进入MariaDB修改root密码：socket

[Richard@localhost ~]$ mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 2

Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [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 |

+---------------------------+

rows in set (0.00 sec)

MariaDB [mysql]> UPDATE user SET Password = password ( 'root123' ) WHERE User = 'root' ;

Query OK, 4 rows affected (0.03 sec)

Rows matched: 4 Changed: 4 Warnings: 0

MariaDB [mysql]> flush privileges;

Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]> exit

重启服务便可登录：ui

[Richard@localhost ~]$ sudo systemctl restart mysql.service

[Richard@localhost ~]$ mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 2

Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit