mysql
manbufenglin
技术兴趣:大数据技术、技术架构、JAVA、数据库开发,C#(Asp.NET)等;
展开
-
centos7下安装mysql5.7异常情况
1、初始化数据库/usr/local/xxx/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/xxx/mysql --datadir=/usr/local/xxx/mysql/data --lc_messages_dir=/usr/local/xxx/mysql/share --lc_messages=en_US注:执行上面命令之前,可以先将环境变量PATH设置好。#mysqlexport PATH=$PATH原创 2021-01-14 17:52:13 · 216 阅读 · 0 评论 -
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st
在安装mysql5.7数据库,并初始化数据后进入mysql控制台执行查询命令时,报错提醒:mysql> show databases;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> exitBye解决方法:按提示操作,修改首次用户密码。用root首次密码登录mysql后,执行修改密码命令:m原创 2021-01-14 17:41:53 · 945 阅读 · 0 评论