官网地址:www.mysql.com
下载最新版本:mysql-5.6.20-winx64.msi
安装
选择custom方式修改安装路径
进入:D:\projects\MySQL\MySQL Server 5.6\bin
启动mysql:mysql –u root –p
安装完后密码为空:
设置权限
进入修改密码和远程ftp连接权限
mysql> set password for root =password(‘newPassword’);
mysql> use mysql;
mysql> select host,user,password from user;
mysql> update user set host =’ %’ where user =’ root’;
mysql> use mysql;
mysql> grant all privileges on *.* to root@’%’ identified by “root”;
mysql> select host,user,password from user;
mysql> use mysql;
mysql> update user set host =’ %’ where user =’ root’;