一、下载mysql-5.7.15-winx64.zip
http://dev.mysql.com/downloads/mysql/
二、解压到安装目录
D:\mysql-5.7.15-winx64
建立目录
D:\mysql-5.7.15-winx64\data
三、配置my.ini
http://dev.mysql.com/downloads/mysql/
二、解压到安装目录
D:\mysql-5.7.15-winx64
建立目录
D:\mysql-5.7.15-winx64\data
三、配置my.ini
[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 = .....
# datadir = .....
# port = .....
# server_id = .....
basedir = D:/mysql-5.7.15-winx64
datadir = D:/mysql-5.7.15-winx64/data
port = 3306
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB
# 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 = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
四、初始化
D:\mysql-5.7.15-winx64\bin>mysqld --initialize
D: \ mysql-5.7.15-winx64\bin >mysqld install
四、初始化
D:\mysql-5.7.15-winx64\bin>mysqld --initialize
D: \ mysql-5.7.15-winx64\bin >mysqld install
\>net start mysql
五、初始化密码
D:\Servers\mysql-5.7.15-winx64\data\xxx.err
A temporary password is generated for root@localhost: uvoo!T?js2Ur
\> mysql -uroot -p uvoo!T?js2Ur
mysql>set password=password('root');
六、设置可远程访问
mysql>use mysql;
mysql>update user set host='%' where user='root';
mysql>flush privileges;
设置windows防火墙,开放3306
五、初始化密码
D:\Servers\mysql-5.7.15-winx64\data\xxx.err
A temporary password is generated for root@localhost: uvoo!T?js2Ur
\> mysql -uroot -p uvoo!T?js2Ur
mysql>set password=password('root');
六、设置可远程访问
mysql>use mysql;
mysql>update user set host='%' where user='root';
mysql>flush privileges;
设置windows防火墙,开放3306
七、远程访问验证
# ./mysql -uroot -proot -h192.168.1.102
# ./mysql -uroot -proot -h192.168.1.102
八、初始密码找不到怎么办
\>net stop mysql
D:\mysql-5.7.15-winx64\bin>mysqld_safe --skip-grant-tables
D:\mysql-5.7.15-winx64\bin>mysql -uroot
mysql>use mysql;
mysql>update user set authentication_string=password('root') where user='root';