mysql-5.6.10-winx64绿色版安装设置
1.解压到你想要的目录;eg:D:\\Software\\mysql-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:\\Software\\mysql-5.6.10-winx64\\bin”(当然你可以自己建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 ...然后输入密码)