windows系统 mysql 解压版配置

mysql下载
http://dev.mysql.com/downloads/mysql/

mysql配置文档
http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

解压到目录
E:\mysql-5.6.17-winx64

在目录下新建配置文件
my.ini

[mysqld]
# set basedir to your installation path
basedir=E:\\mysql-5.6.17-winx64
# set datadir to the location of your data directory
datadir=E:\\mysql-5.6.17-winx64\\data


character-set-server=utf8
character_set_client=utf8

启动和停止

mysql-5.6.17-winx64\bin\mysqld --console

mysql-5.6.17-winx64\bin\mysqladmin -u root shutdown

error: Found option without preceding group in config file
缺少[mysqld]

必须要用命令行关闭，否则电脑不重启，系统无法再次启动

修改root密码
http://dev.mysql.com/doc/refman/5.6/en/default-privileges.html

shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd');

修改建用户和授权

CREATE USER `username`@`%` IDENTIFIED BY 'passwd;;;';

GRANT  all privileges ON dbname.* TO 'username'@'%';
GRANT  all privileges ON dbname.* TO 'username'@'localhost';

flush privileges;

MySQL启动和停止的脚本

@echo off

cd D:\mysql-5.6.10-winx64\bin
d:

echo 1、启动MySQL  2、关闭MySQL
SET /p action=请输入命令：
set /a action=%action%*1
if %action% equ 1 (goto start )else (goto shutdown)


:start
echo 启动MySQL。。。。。
start mysqld
goto :end


:shutdown
echo 关闭MySQL。。。。。
mysqladmin -uroot -proot shutdown
goto :end


:end

pause