免费的seo网站膝,微信管理助手,展示型型网站建设,晋州网站建设重装系统之后准备安装mysql,看到官网上有mysql 5.7.10可以下载就点了,然后就开始了漫长的安装路程,总共折腾差不多一个多小时,最后终于安装成功了,这里把安装过程写下来,给自己做个笔记,也给后来人一个安装提示.1.下载安装包直接点击或者复制之后就可以下载了,不嫌麻烦或者想体…重装系统之后准备安装mysql,看到官网上有mysql 5.7.10可以下载就点了,然后就开始了漫长的安装路程,总共折腾差不多一个多小时,最后终于安装成功了,这里把安装过程写下来,给自己做个笔记,也给后来人一个安装提示.1.下载安装包直接点击或者复制之后就可以下载了,不嫌麻烦或者想体验其他版本的也可以去官网下载,但是请注意,笔记只在5.7.10这个版本下运行成功,其他版本(仅供参考)需要参考官方的安装文档!2.解压缩文件夹到本地磁盘我把文件放在了C:\Program_Files\mysql-5.7.10-winx643.复制my-default.ini为my.ini建议复制一份,或者直接把my-default.ini重命名为my.ini4.填写my.ini相关内容basedirC:\Program_Files\mysql-5.7.10-winx64datadirC:\Program_Files\mysql-5.7.10-winx64\dataport3306路径请替换成自己实际路径!5.环境变量新增环境变量,如下图修改path,注意是修改,增加的是后面我选中的部分%MYSQL_HOME%\bin;6.管理员权限运行[命令提示符]尽量使用管理员权限运行,否则,可能出现无法安装或者无法启动服务等问题!7.执行mysql初始化datamysqld --initialize --console结果如下:C:\Windows\system32mysqld --initialize --console2015-12-25T03:01:33.140732Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation formore details).2015-12-25T03:01:33.140732Z 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 ina future release.2015-12-25T03:01:33.140732Z 0 [Warning] NO_AUTO_CREATE_USER sql mode was not set.2015-12-25T03:01:34.614085Z 0 [Warning] InnoDB: New log files created, LSN457902015-12-25T03:01:34.775606Z 0[Warning] InnoDB: Creating foreign key constraint system tables.2015-12-25T03:01:34.872089Z 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: ceb98c90-aab3-11e5-8ca7-b870f4733564.2015-12-25T03:01:34.872089Z 0 [Warning] Gtid table is not ready to be used. Table mysql.gtid_executedcannot be opened.2015-12-25T03:01:34.891376Z 1 [Note] A temporary password is generated for rootlocalhost: Gs,0spF请注意,最后一句包含我们所需要的初始化密码!!!!8.安装mysql服务,并启动C:\Windows\system32mysqld -installService successfully installed.C:\Windows\system32net start mysqlMySQL 服务正在启动 .MySQL 服务已经启动成功。9.登录mysql并修改密码请注意,我下面的密码和上面的那个初始化密码不一样了,因为我有重新卸载了服务然后重新执行了一遍 7和8 ,因为上面的密码提示我无法登录,C:\Windows\system32mysql -uroot -pih.sQWazK9*7mysql set password for rootlocalhost你的密码;Query OK,0 rows affected (0.00 sec)好了,现在退出mysqlexitBye10.修改远程登录到上面9 的时候本机已经可以正常使用mysql的功能了,不过如果需要远程登录mysql的话需要下面的设置C:\Windows\system32mysql -uroot -p你的密码mysql: [Warning] Using a password on the command lineinterfacecan be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection idis 3Server version:5.7.10MySQL Community Server (GPL)Copyright (c)2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracleis a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Typehelp; or \h for help. Type \cto clear the current input statement.mysqluse mysqlDatabase changedmysql select host,user fromuser;----------------------| host | user |----------------------| localhost | mysql.sys || localhost | root |----------------------2 rows in set (0.00sec)mysql update user set host% where user root;Query OK,1 row affected (0.00sec)Rows matched:1 Changed: 1 Warnings: 0mysql select host,user fromuser;----------------------| host | user |----------------------| % | root || localhost | mysql.sys |----------------------2 rows in set (0.00sec)mysql好了,到这里全部完成了,开始你的mysql之旅吧!
