需先安装win32 runtime
1.下载mysql压缩包,在解压包的根目录下,新增my-default.ini文件,并进行配置basedir 和datadir
[mysql]
default-character-set=utf8
[mysqld]
basedir=C:\tools\mysql-5.7.18-winx64
datadir=C:\tools\mysql-5.7.18-winx64\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
2.使用管理员权限打开cmd窗口,切换到mysql安装目录中的bin目录下,执行mysqld -install
3.mysqld --initialize
4.net start mysql
5.mysql -u root -p
密码在安装时,会初始化一个随机密码。在data目录下,*.err文件中。
2017-04-22T17:34:04.533447Z 1 [Note] A temporary password is generated for root@localhost: =InKaBDud0B8
6.alter user 'root'@'localhost' identified by 'hello123';
修改mysql服务器字符集:
查看mysql数据库当前连接情况:show full processlist;