首页 / MYSQL / mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1993字，纯文字阅读大概需要3分钟。

内容图文

mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

linux操作mysql数据库，可以登陆进去，但是操作所有命令都显示You must reset your password using ALTER USER statement before executing this statement，并且使用alter修改密码时，显示密码不符合权限

很多方法都没用，也不知道出了什么问题，我选择利用跳过密码登录后再次修改密码

解决过程：

1、编辑/etc/my.cnf

在[mysqld] 配置部分添加一行

skip-grant-tables

2、保存后重启mysql

[root@localhost etc]# service mysqld restart
Shutting down MySQL. [ OK ]
Starting MySQL. [ OK ]

3、登录数据库重新设置root密码

[root@localhost ~]# mysql -uroot -p mysql
Enter password:

直接回车进入

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.47-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

成功进入，此时使用如下语句修改密码

UPDATE mysql.user SET authentication_string=PASSWORD(‘密码‘) where USER=‘root‘;

退出修改原来修改的文件，删除 /etc/my.cnf文件中添加的“skip-grant-tables”行，重启mysql；

用新设的密码就能正常登录了；

修改成功后，exit退出使用 mysql -uroot -p 命令输入密码进入数据库，可以操作，

mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

标签：sql数据库 localhost orm res database acl modify ase use

本文系统来源：https://www.cnblogs.com/blogofbin/p/11656348.html

内容总结

以上是互联网集市为您收集整理的mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement全部内容，希望文章能够帮你解决mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/513612.html

来源：【匿名】

【上一篇】mysqldump 命令【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement】教程文章相关的互联网学习教程文章

Mysql in statement performance related with its position?【代码】

select* from(selectevent_date,‘2014-12-06‘as active_date,channel_id,new_user_count as new_user_count,1d_retain/new_user_count as 1d_retain_ratefromweb_channel_retainwhereapp_id=-1andevent_date=‘2014-12-05‘andnew_user_count>= 500andchannel_id in (select distinct channel_id from formated_channel_category where type_id=507 ))as f order by 1d_retain_rate desc limit 0,50;The above sql runs less tha...

MySql用statement实现DDL,DML,DQL的操作Demo【代码】

Demo1Connection connection=null;Statement stmt=null;int result=-1;try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {e.printStackTrace();}try {//创建连接String url="jdbc:mysql://localhost:3306/jdbcdb";connection= DriverManager.getConnection(url, "root", "mysql");} catch (SQLException e) {e.printStackTrace();}try {//创建StatementString sql="CREATE TABLE s_user(id INT PR...

【Mysql 5.7】ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.【代码】【图】

1、通过mysql -uroot -p，输入密码登录后，必须马上修改密码，否则会报错2、将密码修改为123456，依然报错这和mysql 5.7的密码策略（validate_password_policy）有关,validate_password_policy可以取如下值：默认为1即MEDIUM，包含长度、数字、英文大小写、特殊字符校验。长度由validate_password_length配置，默认为8.3、在/etc/my.cnf配置文件中增加4、修改密码为12345678，成功 5、查看当前密码策略 1 mysql> show VARIABLES ...

mysql数据库Jdbc直接操作Statement__delete【代码】

一、代码如下private void deleteMysql() {// TODO Auto-generated method stubjava.sql.Statement sm= null;java.sql.Connection cn = null;ResultSet rs = null;try {//加载驱动程序Class.forName("com.mysql.jdbc.Driver").newInstance();//得到连接cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?user=root&password=&useUnicode=true&characterEncoding=UTF8");sm= cn.createStatement();int i= sm.ex...

mysql-由于BINLOG_FORMAT = STATEMENT,因此使用语句格式将不安全的语句写入二进制日志.【代码】

尝试从Django管理屏幕中插入值时遇到以下错误-Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. Request Method: POST Request URL: *<My URL>* Django Version: 1.3.1 Exception Type: Warning Exception Value: Unsafe sta...

mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement【代码】

mysql初始化密码常见报错问题 1，mysql5.6是密码为空直接进入数据库的，但是mysql5.7就需要初始密码 cat /var/log/mysqld.log | grep password2，然后执行 mysql -uroot -p ，输入上面的到的密码进入，用该密码登录后，必须马上修改新的密码，不然会报如下错误： mysql> use mysql; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.3，如果你想要设置一个简单的测试...

mysql数据库的连接以及增删改查Java代码实现（Statement版）【代码】

数据库： create table t1(id int primary key not null auto_increment,name varchar(32),password varchar(32));insert into t1(name,password) values(admin,123); insert into t1(name,password) values(zhangsan,123); insert into t1(name,password) values(lisi,123);Java代码： mysqlDao.java：package com.dao;import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.S...

mysql binlog_format row and Statement 比较

两种模式的对比： Statement 优点历史悠久，技术成熟；产生的 binlog 文件较小； binlog 中包含了所有数据库修改信息，可以据此来审核数据库的安全等情况； binlog 可以用于实时的还原，而不仅仅用于复制；主从版本可以不一样，从服务器版本可以比主服务器版本高；Statement 缺点：不是所有的 UPDATE 语句都能被复制，尤其是包含不确定操作的时候；调用具有不确定因素的 UDF 时复制也可能出现问题；运用以下函数的语句也不能...

mac mysql error You must reset your password using ALTER USER statement before executing this statement.

安装完mysql 之后，登陆以后，不管运行任何命令，总是提示这个 step 1: SET PASSWORD = PASSWORD(‘your new password‘); step 2: ALTER USER ‘root‘@‘localhost‘ PASSWORD EXPIRE NEVER; step 3: flush privileges;mac mysql error You must reset your password using ALTER USER statement before executing this statement.标签：sql 命令运行 mysql alt tin lte exe local 本文系统来源：http://www....

mysql报错Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage

mysql报错Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage 在执行create table xx as select xx的时候或者在执行 tpcc-mysql的tpcc_load 的时候都会遇到这个错误 1534, HY000, Writing one row to the row-based binary log failedRetrying ... 1197, HY000, Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage; increase this my...

解决mysql的错误 CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: '\xBF\xA5'【代码】

报错： CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: ‘\xBF\xA5‘ 解决方法： $currentPrice = $currentPrice * 1; => $currentPrice 原本是字符串的数字，导致插入数据库失败。=》所以只要改成数字即可。=》字符串的数字，乘以 1 就会变成数字类型。但是有报告了一个Php的错误： Internal Server Error Division by zero An internal error...

【mysql】【You must reset your password using ALTER USER statement before executing this statement报错处理】

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> use mysql; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 解决方式如下： MySQL版本5.7.6版本以前用户可以使用如下命令： mysql> SET PASSWORD = PASSWORD(‘xxxxxxxxx‘); MySQL版本5.7.6版本开始的用户可以使用如下命令： mysql> ...

mysql 5.7密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.【代码】【图】

1、重新修改密码，语句如下：mysql> alter user ‘root‘@‘localhost‘ identified by ‘123‘; Query OK, 0 rows affected (0.00 sec) 2、如果修改过程出现错误（如下），转后面操作：mysql> alter user ‘root‘@‘localhost‘ identified by ‘123‘; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 2.1、这个其实与validate_password_policy的值有关。validate_password_policy有以下...

mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions

, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.解决：查看开发脚本，一个脚本的单个事务中存在以下内容： insert插入到innodb表，update 更新的是mysaim表。联系开发sql拆分两个脚本分开提交，问题解决。mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates ...

Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

, SQLState: HY000 八月 17, 2019 2:04:36 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage; increase this mysqld variable and try again 八月 17, 2019 2:04:36 下午 org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release INFO: HHH000010: On release of batch it still contained ...

首页 / MYSQL / mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement

内容导读

内容图文

内容总结

内容备注

内容手机端

【mysql数据库问题———登录进去无法操作显示You must reset your password using ALTER USER statement before executing this statement】教程文章相关的互联网学习教程文章

Mysql in statement performance related with its position?【代码】

MySql用statement实现DDL,DML,DQL的操作Demo【代码】

【Mysql 5.7】ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.【代码】【图】

mysql数据库Jdbc直接操作Statement__delete【代码】

mysql-由于BINLOG_FORMAT = STATEMENT,因此使用语句格式将不安全的语句写入二进制日志.【代码】

mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement【代码】

mysql数据库的连接以及增删改查Java代码实现（Statement版）【代码】

mysql binlog_format row and Statement 比较

mac mysql error You must reset your password using ALTER USER statement before executing this statement.

mysql报错Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage

解决mysql的错误 CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: '\xBF\xA5'【代码】

【mysql】【You must reset your password using ALTER USER statement before executing this statement报错处理】

mysql 5.7密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.【代码】【图】

mysql error：@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1，updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions

Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

MYSQL - 相关标签

WORD - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程