温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
十丈软红中的一粒俗物,仅此而已
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
阅读(4074)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'win7下mysql设置环境变量',
blogAbstract:'之前曾遇到过这个问题，在cmd下输入mysql命令，显示不是内部命令。
今天又一次遇到，故记录解决方法如下：
右击& 计算机——属性——高级系统设置——高级-&环境变量-&系统变量
选择PATH，在其后面添加：你的mysql文件夹路径/bin (如:D:\\wamp\\bin\\mysql\\mysql5.5.8\\bin)
PATH=.......;D:\\wamp\\bin\\mysql\\mysql5.5.8\\bin (注意为追加,不是覆盖)
blogTag:'环境变量',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:7,
publishTime:5,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'十丈软红中的一粒俗物,仅此而已',
hmcon:'0',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}MySQL5.7.16绿色版安装教程详解_mysql绿色版安装教程_词汇网
MySQL5.7.16绿色版安装教程详解
责任编辑：词汇网 发表时间： 13:50:14
这篇文章主要介绍了MySQL5.7.16绿色版安装教程详解的相关资料,本文给大家介绍的非常详细，具有一定的参考借鉴价值，需要的朋友可以参考下 下面给大家介绍下MySQL5.7.16绿色版安装教程，具体内容如下所示：如图所示：原窗口指令Microsoft Windows [版本 10.0.xxxxx](c) 2016 Microsoft Corporation。保留所有权利。C:\WINDOWS\system32>mysqld --initialize-insecure --consoleT21:45:48. [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).T21:45:49. [Warning] InnoDB: New log files created, LSN=-16T21:45:50. [Warning] InnoDB: Creating foreign key constraint system tables.T21:45:50. [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.T21:45:50. [Warning] Gtid table is not ready to be used. Table "mysql.gtid_executed" cannot be opened.T21:45:50. [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.C:\WINDOWS\system32>mysqld -installService successfully installed.C:\WINDOWS\system32>net start mysqlMySQL 服务正在启动 .MySQL 服务已经启动成功。C:\WINDOWS\system32>mysql -u root --skip-passwordmysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. C or \g.Your MySQL connection id is 2Server version: 5.7.16 MySQL Community Server (GPL)Copyright (c) , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type "" 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> \quitByeC:\WINDOWS\system32>mysql -h localhost -uroot -pEnter password: ********Welcome to the MySQL monitor. C or \g.Your MySQL connection id is 3Server version: 5.7.16 MySQL Community Server (GPL)Copyright (c) , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type "" or "\h" for help. Type "\c" to clear the current input statement.mysql>以上所述是小编给大家介绍的MySQL5.7.16绿色版安装教程详解,希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对词汇网网站的支持！
上一集:没有了 下一集:
相关文章：&&&&&&
最新添加资讯
24小时热门资讯
附近好友搜索最新版mysql5.7.16安装备忘录
1、到官网下载mysql 5.7.16 zip包（略）1）右键单击我的电脑-&属性-&高级系统设置(高级)-&环境变量&& && 点击系统变量下的新建按钮& & &&输入变量名：MYSQL_HOME& & &&输入变量值：D:/mysql/mysql-install& & &&即为mysql的自定义解压目录。& &&2）选择系统变量中的Path&& && 点击编辑按钮& & &&在变量值中添加变量值：;%MYSQL_HOME%/bin2、修改新建my.ini文件（以下是安装成功后的配置文件）：# For advice on how to change settings please see# /doc/refman/5.7/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[client]port=3306default-character-set=utf8[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.basedir = D:/mysql/mysql-installdatadir = D:/mysql/mysql-data/dataport = 3306server_id = 1# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.join_buffer_size = 128Msort_buffer_size = 2Mread_rnd_buffer_size = 2M&sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES&3、进入解压路径，执行指令：mysqld&--console4、执行指令：mysqld&&--initialize出现如下错误：意思上应该是少了个名data的文件夹。在my.ini文件的datadir路径后面追加data，同时在对应的路径下新建data文件夹。重新执行指令mysqld&&--initialize。成功通过。5、执行指令：mysqld installDOC提示：Install/Remove of the Service Denied解决方法，打开cmd.exe程序的时候选择“用管理员身份打开”。成功后的截图：6、启动mysql服务：net start mysql7、修改 root 账号的密码1).&修改MySQL的配置文件（my.ini）,在[mysqld]下添加一行skip-grant-tables& & & 2) mysql 重启后，即可直接用 mysql -u root -p 进入(此时密码为空)3) mysql&&update mysql.user set authentication_string=password('XXXX') where user='root' and Host = 'localhost';& 4)&mysql&& & & & 5)&mysql&& & & & 6) 将my.cnf文件还原(删除skip-grant-tables这一行)，重新启动 mysql& & & & 7)&这个时候可以使用 mysql -uroot -pXXXX 进入了& & & & 8) mysql&SET PASSWORD = PASSWORD('123456'); 设置新密码最后截图：
最新教程周点击榜
微信扫一扫