时间:2020-05-15来源:电脑系统城作者:电脑系统城
Linux安装好MySQL后,为了增加数据库的安全性,在安装时会为root用户生成一个临时的随机密码,存放在/var/log/mysqld.log 中。
[root@localhost mysql_bundle]# cat /var/log/mysqld.log | grep temp
2020-05-12T12:05:15.901037Z 1 [Note] A temporary password is generated for root@localhost: .fJJk*j&t4h6
2020-05-12T12:05:18.403371Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
这个.fJJk*j&t4h6就是临时密码。第一次登录就使用这个密码。
登录后输入show databases命令查看数据库中有哪些库,发现出现错误。
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
这条错误语句时说必须使用ALTER USER重设密码才可以执行这条语句。
那么接下来就重置密码吧。
注意:密码要符合复杂度规则,也就是说要包含大小写字母、数字、特殊符号,并且长度不小于八位。否则会报错,如下:
mysql> alter user root@localhost identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql>
设置一个合格的密码。
mysql> alter user root@localhost identified by 'MySQLroot123#';
Query OK, 0 rows affected (0.00 sec)
mysql>
[root@localhost mysql_bundle]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.29 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
[root@localhost mysql_bundle]#
2023-03-19
Centos 7.9安装MySQL8.0.32的详细教程2023-03-19
一步步教你利用Mysql存储过程造百万级数据2023-03-19
利用Mysql定时+存储过程创建临时表统计数据的过程问题描述:MYSQL version 5.6.8command 表结构 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 CREATE TABLE command ( ID INT NOT NULL, NAME VARCHAR(16), D...
2023-03-19
一、Galera Cluster 二、基础环境搭建 三、加入配置参数启动集群 四、 测试 五、ProxySql...
2023-03-17