mysql5.6.10winx64绿色版安装设置

mysql5.6.10winx64绿色版安装设置由刀豆文库小编整理，希望给你工作、学习、生活带来方便”。

mysql-5.6.10-winx64绿色版安装设置

1.解压到你想要的目录;eg:D:Softwaremysql-5.6.10-winx64

2.新建my.ini;

复制一下代码到文件内部：

# Save as “my.ini” in your MySQL installed directory

[mysqld]

# Set MySQL base(installed)directory

# @@ Change to your MySQL installed directory @@

basedir=D:/Software/mysql-5.6.10-winx64

# Set MySQL data directory

# @@ Change to sub-directory “data” of your MySQL installed directory@@

datadir=D:/Software/mysql-5.6.10-winx64/data

character_set_server=utf8

# Run the server on this TCP port number

port=3306

[client]

# MySQL client connects to the server running on this TCP port number

port=3306

default-character-set=utf8

3.环境变量设置：Path中加“:;D:Softwaremysql-5.6.10-winx64bin”(当然你可以自己建mysql变量，然后加到path)

4.进入Command Prompt(方法：windows+r,输入cmd);然后mysqld--install

5.默认root没有密码；输入：mysql-u root 就可以登录了（默认有个空用户你直接mysql也可以进去，只是没啥用）

6.改密码：有几种方法吧，我这只说一直；update mysql.user set paword = paword('你的密码')where user = 'root';

7.flush privileges;(很重要，改权限相关需要)

8.commit;

9.quit;然后重新登录就可以了。（方法：mysq-u root-p...然后输入密码）