当前位置： 移动技术网 > IT编程>数据库>Mysql > MySQL5.7.16绿色版安装教程详解

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

2017年12月12日  | 移动技术网IT编程  | 我要评论

下面给大家介绍下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绿色版安装教程详解,希望对大家有所帮助

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网