欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

MySQL5.7.16绿色版安装教程详解

程序员文章站 2023-12-19 16:10:04
下面给大家介绍下mysql5.7.16绿色版安装教程,具体内容如下所示: 如图所示: 原窗口指令 microsoft windows [版本 10...

下面给大家介绍下mysql5.7.16绿色版安装教程,具体内容如下所示:

如图所示:

MySQL5.7.16绿色版安装教程详解

原窗口指令

microsoft windows [版本 10.0.xxxxx]
(c) 2016 microsoft corporation。保留所有权利。
c:\windows\system32>mysqld --initialize-insecure --console
2016-10-16t21:45:48.466872z 0 [warning] timestamp with implicit default value is deprecated. please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-16t21:45:49.862877z 0 [warning] innodb: new log files created, lsn=45790
2016-10-16t21:45:50.240119z 0 [warning] innodb: creating foreign key constraint system tables.
2016-10-16t21:45:50.457297z 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: e7a7d27d-93e9-11e6-a549-f8a963e68bc7.
2016-10-16t21:45:50.482293z 0 [warning] gtid table is not ready to be used. table 'mysql.gtid_executed' cannot be opened.
2016-10-16t21:45:50.484316z 1 [warning] root@localhost is created with an empty password ! please consider switching off the --initialize-insecure option.
c:\windows\system32>mysqld -install
service successfully installed.
c:\windows\system32>net start mysql
mysql 服务正在启动 .
mysql 服务已经启动成功。
c:\windows\system32>mysql -u root --skip-password
mysql: [warning] using a password on the command line interface can be insecure.
welcome to the mysql monitor. commands end with ; or \g.
your mysql connection id is 2
server version: 5.7.16 mysql community server (gpl)
copyright (c) 2000, 2016, oracle and/or its affiliates. all rights reserved.
oracle is a registered trademark of oracle corporation and/or its
affiliates. other names may be trademarks of their respective
owners.
type 'help;' or '\h' for help. type '\c' to clear the current input statement.
mysql> alter user 'root'@'localhost' identified by 'root2016';
query ok, 0 rows affected (0.00 sec)
mysql> \quit
bye
c:\windows\system32>mysql -h localhost -uroot -p
enter password: ********
welcome to the mysql monitor. commands end with ; or \g.
your mysql connection id is 3
server version: 5.7.16 mysql community server (gpl)
copyright (c) 2000, 2016, oracle and/or its affiliates. all rights reserved.
oracle is a registered trademark of oracle corporation and/or its
affiliates. other names may be trademarks of their respective
owners.
type 'help;' or '\h' for help. type '\c' to clear the current input statement.
mysql>

以上所述是小编给大家介绍的mysql5.7.16绿色版安装教程详解,希望对大家有所帮助

上一篇:

下一篇: