记录人生中的每一次坑!!
Mysql5.7确实太多不同之处,记录一下安装教程
参考网上的两篇教程,结合起来,解决安装问题:
http://jingyan.baidu.com/article/af9f5a2d16fa4d43150a4552.html
http://blog.csdn.net/luomingjun12315/article/details/50863781
接下来是我的步骤:
下载最新的mysql5.7,解压缩到D盘,D:\mysql5.7
配置my.ini
[mysqld]
port = 3306
basedir = D:\mysql5.7
datadir = D:\mysql5.7\data
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB
[mysql]
default-character-set=utf8
进入bin目录,安装mysql:mysqld install
初始化data目录,并且为root账户生成空密码:mysqld --initialize-insecure --user=mysql
启动mysql服务:net start mysql
最后,进入数据库:mysql -uroot -p
默认密码为空,接下来修改root的密码:
use mysql;
update user set authentication_string=PASSWORD("Aswd1234")where user="root";
flush privileges;
大功告成。睡觉!
summer ---