mysql5.7压缩版初始化

来源：互联网发布：mac变慢编辑：程序博客网时间：2024/05/09 00:14

初始化数据库目录

mysqld --initialize --user=mysql --console

mysql\mysql-5.7.13-winx64\bin>mysqld --initialize --user=mysql --console2017-01-16T14:59:06.283684Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2017-01-16T14:59:06.283684Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.2017-01-16T14:59:06.283684Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2017-01-16T14:59:06.965045Z 0 [Warning] InnoDB: New log files created, LSN=457902017-01-16T14:59:07.129900Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2017-01-16T14:59:07.238839Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 54352566-dbfc-11e6-baa7-00155d016902.2017-01-16T14:59:07.267716Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2017-01-16T14:59:07.275715Z 1 [Note] A temporary password is generated for root@localhost: ak*09TS/of:4

ak*09TS/of:4：初始化密码

初始化mysql服务

mysqld --install MySQL

启动mysql服务

net start mysql

登录mysql

mysql -uroot -p

重置密码

set password for root@localhost = password('taofangt168');

完成

0 0