bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql8 --datadir=/usr/local/mysql8/data /usr/local/mysql8/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 5826 [Server] A temporary password is generated for root@localhost: twi=Tlsi<0O! /usr/local/mysql/bin/mysqld (mysqld 8.0.11) initializing of server has completed
记录自己的临时密码 twi=Tlsi<0O!
以上执行如果报错 bin/mysqld: error while loading shared libraries: libnuma.so.1:
是因为缺少numactl 安装一下即可
12、操作数据库前必须将临时密码设置为别的。
报错信息为 You must reset your password using ALTER USER statement before executing this statement
MySQL版本5.7.6版本开始的用户可以使用如下命令:详情见
1
mysql> ALTER USER USER() IDENTIFIED BY 'your password';
问题集锦
1、MySQL官网下载太慢的解决方法:详情见
2、Navicat远程连接云服务器上的MySQL失败(1251 client does not support authentication protocol requested by server;consider upgrading Mysql client
ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@‘localhost’):详情见
1
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
MySql8配置
1、mysql -u root -p 输入密码
2、初次使用修改密码命令:ALTER USER USER() IDENTIFIED BY 'Xiaoming250';
3、show databases; 显示所有数据库
4、quit; 退出mysql命令行编辑