mariadb数据库初始化密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';（默认不需要密码,初次设置密码）

 

systemctl stop mariadb

sudo mysqld_safe --skip-grant-tables &

'update mysql.user SET Password=PASSWORD('123456') WHERE User='root';

 

MariaDB [mysql]> -- 为 root@% 设置密码
MariaDB [mysql]> SET PASSWORD FOR 'root'@'%' = PASSWORD('123456');
Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]>
MariaDB [mysql]> -- 为 root@127.0.0.1 设置密码
MariaDB [mysql]> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]>
MariaDB [mysql]> -- 为 root@::1 设置密码（IPv6 localhost）
MariaDB [mysql]> SET PASSWORD FOR 'root'@'::1' = PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]>
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)