首页 / MYSQL / MySql 8 You must reset your password using ALTER USER statement before executing this statement

MySql 8 You must reset your password using ALTER USER statement before executing this statement

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MySql 8 You must reset your password using ALTER USER statement before executing this statement，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1120字，纯文字阅读大概需要2分钟。

内容图文

You must reset your password using ALTER USER statement before executing this statement

最近安装mysql8版本时,遇到坑无数,第一无论输入啥,都提示此信息,意思是在执行此语句之前，必须使用alter user语句重置密码

MySql 8 You must reset your password using ALTER USER statement before executing this statement - 文章图片

查询网上使用此语句 alter user user() identified by “123qweR”;
但是提示 Your password does not satisfy the current policy requirements
意思就是密码过于简单,不符合密码设置的策略,看了一下有的人建议修改策略啥的,这里我get一个新的方法,直接将原来mysql的初始化密码修改一下后二位,因为他肯定满足密码策略,策略估计是大小写,字母特殊字符都必须含有
MySql 8 You must reset your password using ALTER USER statement before executing this statement - 文章图片去log文件中查看我的初始化密码,然后将一二个字母修改一下,我只是修改了后一位

alter user user() identified by “26SE>Z%UddNN”;
ok,但是这里我的外网工具还是连接不上mysql,是host地址没有开放,需要设置一下,
use mysql;
update user set host = ‘%’ where user = ‘root’;
flush privileges;

然后连接后发现还是不行,
这次工具连接报错为Client does not support authentication protocol requested by server…；

个人认为是root用户需要修改加密方式,所以还需要执行以下语句
use mysql;
alter user ‘root’@’%’ identified with mysql_native_password by ‘26SE>Z%UddNN’;
flush privileges;

最后大功告成!

内容总结

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

内容备注

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

内容手机端

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

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

来源：【匿名】

【上一篇】Mysql ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes 【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【MySql 8 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 8 You must reset your password using ALTER USER statement before executing this statement

MySql 8 You must reset your password using ALTER USER statement before executing this statement

内容导读

内容图文

内容总结

内容备注

内容手机端

【MySql 8 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 - 最热教程