centos7 mariadb设置初始密码

来源：互联网发布：mac 怎么给文件归类编辑：程序博客网时间：2024/09/21 08:56

通过yum安装mariadb mariadb-server后设置一个初始密码。

首先启动mariadb服务，然后输入mysql进入mariadb控制台：

[root@localhost ~]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

输入 uuse mysql;

MariaDB [(none)]> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

输入修改密码的命令：

update user set password=password("这里替换成你的密码")where user='root';

MariaDB [mysql]> update user set password=password("yoonching")where user='root';Query OK, 4 rows affected (0.00 sec)Rows matched: 4  Changed: 4  Warnings: 0

输入 flush privileges;

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

输入exit退出

MariaDB [mysql]> exitBye

测试：在命令行输入mysql，不带登录信息

[root@localhost ~]# mysqlERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

无法进入。

再测试：带登录信息

root@localhost ~]# mysql -uroot -pyoonchingWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 4Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

密码设置成功！

0 0