如何解决Mysql数据库报ERROR 1045 28000报错以及MySQL忘记密码的找回方法

这期内容当中小编将会给大家带来有关如何解决Mysql数据库报ERROR 1045 28000报错以及MySQL忘记密码的找回方法，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。案例：Mysql数据库报ERROR 1045 (28000)报错；同时该方法适用于忘记MySQL Password找回；重新安装mysql手动清空mysqld.log日志文件导致初始Password丢失Password修改；案例1：[root@zrbapp02 lib]#[root@zrbapp02 lib]#
mysql -uroot -pmysqlmysql: [Warning] U免费主机域名sing a password on the command line interface can be insecure.ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)[root@zrbapp02 lib]#[root@zrbapp02 lib]#案例2：[root@zrbapp02 ~]#
echo “” > /var/log/mysqld.log —-清空mysqld.log日志文件后查不到[root@zrbapp02 ~]#[root@zrbapp02 ~]#
grep ‘temporary password’ /var/log/mysqld.log –mysqld.log日志文件查不到初始Password[root@zrbapp02 ~]#[root@zrbapp02 ~]#[root@zrbapp02 ~]#
systemctl restart mysqld[root@zrbapp02 ~]#解决方法：
1、修改/etc/my.cnf文件中[mysqld]段增加skip-grant-tables跳过认证[root@zrbapp02 lib]#
vi /etc/my.cnf#socket=/mysqldb/mysql/mysql.sock# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[mysqld]skip-grant-tables## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M#datadir=/var/lib/mysqldatadir=/mysqldb/mysqlsocket=/var/lib/mysql/mysql.sock#socket=/mysqldb/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidwq! —-保存并退出2、重启mysql数据库[root@zrbapp02 lib]# systemctl restart mysqld[root@zrbapp02 lib]#3、免密登录数据库并修改Password[root@zrbapp02 lib]#[root@zrbapp02 lib]#
mysqlWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2Server version: 5.7.25 MySQL Community Server (GPL)Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.mysql>mysql>
show databases;+——————–+| Database |+——————–+| information_schema || mysql || performance_schema || sys |+——————–+4 rows in set (0.24 sec)mysql>mysql>
use mysql;Reading table information for completion of ta免费主机域名ble and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql>mysql>mysql>
update mysql.user set authentication_string=password(‘mysql’) where user=’root’;Query OK, 1 row affected, 1 warning (0.14 sec)Rows matched: 1 Changed: 1 Warnings: 1mysql>mysql>
flush privileges ;Query OK, 0 rows affected (0.00 sec)mysql>mysql>
exitBye[root@zrbapp02 lib]#[root@zrbapp02 lib]#4、注释掉skip-grant-tables[root@zrbapp02 lib]#
vi /etc/my.cnf# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[mysqld]#skip-grant-tables## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M#datadir=/var/lib/mysqldatadir=/mysqldb/mysqlsocket=/var/lib/mysql/mysql.sock#socket=/mysqldb/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidwq! —-保存并退！5、重启mysql数据库[root@zrbapp02 lib]#systemctl restart mysqld[root@zrbapp02 lib]#
6、使用新Password登录数据库[root@zrbapp01 ~]#[root@zrbapp01 ~]# mysql -uroot -pmysqlmysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 4Server version: 5.7.25Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.mysql>mysql>
show databases; –查看数据库时要求使用ALTER USER restPasswordERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql>mysql> alter user’root’@’localhost’ identified by’mysql’; —-重置Password提示Password规则问题，不能使用简单Password；ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsmysql>mysql>若需要设置简单Password则按以下设置Password规则即可；mysql>
set global validate_password_policy=0;Query OK, 0 rows affected (0.00 sec)mysql>
set global validate_password_mixed_case_count=0;Query OK, 0 rows affected (0.00 sec)mysql> set global validate_password_number_count=3;Query OK, 0 rows affected (0.00 sec)mysql>
set global validate_password_special_char_count=0;Query OK, 0 rows affected (0.01 sec)mysql>
set global validate_password_length=3;Query OK, 0 rows affected (0.00 sec)mysql> alter user’root’@’localhost’ identified by’mysql’;Query OK, 0 rows affected (0.00 sec)mysql>mysql>mysql> show databases;+——————–+| Database |+——————–+| information_schema || mysql || performance_schema || sys |+——————–+4 rows in set (0.00 sec)mysql>mysql>
use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql>mysql>上述就是小编为大家分享的如何解决Mysql数据库报ERROR 1045 28000报错以及MySQL忘记密码的找回方法了，如果刚好有类似的疑惑，不妨参照上述分析进行理解。如果想知道更多相关知识，欢迎关注云技术行业资讯频道。

相关推荐: Hadoop HBase配置安装Snappy的详细教程

这篇文章主要介绍“Hadoop HBase配置安装Snappy的详细教程”，在日常操作中，相信很多人在Hadoop HBase配置安装Snappy的详细教程问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Hadoop HBase配…