其实MySQL的安装配置流程网上已经有很多资料了,但是最近在安装MySQL时,自己不记得细节了,又没记过笔记,在网上找的一些方法又出现了一些问题,头疼。
所以这次就把细节记下来,一方面给自己以后安装的时候看,一方面分享一下。
第一步:MySQL官网下载免安装的文件
https://dev.mysql.com/downloads/mysql/
下载之后解压,放在自己准备好的目录,比如我放在了
D:\Program Files\mysql-8.0.14-winx64
然后把 D:\Program Files\mysql-8.0.14-winx64\bin 放在环境变量里。
第二步:准备my.ini文件,下载的文件里好像并没有my.ini,我们可以新建一个,文件里面的代码是:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_bin
init_connect='SET NAMES utf8mb4'
# 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 = D:\Program Files\mysql-8.0.14-winx64
datadir = D:\Program Files\mysql-8.0.14-winx64\data
port = 3306
# server_id = .....
# 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 = 16M
read_rnd_buffer_size = 16M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
要注意,其中的basedir和datadir需要改成自己的地址。datadir那个data文件夹暂时没有没关系。
第三步:
然后管理员权限启动cmd ,进入D:\Program Files\mysql-8.0.14-winx64\bin
PS:如果不是管理员权限启动cmd,之后的命令操作会报错,比如“无法启动~~”
在bin目录,cmd敲
mysqld -install
执行安装服务,这时可以在Windows服务中看到MySQL的服务。
然后敲
mysqld --initialize --console
上面初始化数据库。然后你可以在初始化的最后面看到一个root@localhost:后面有一连串的字母数字符号,这是MySQL为你自动生成的随机密码。记下来,一会要用下。
然后用命令启动
net start mysql
mysql -uroot -p
这时它会提醒你输入密码,把刚刚随机生成的密码输入,然后回车,就进去了。
进去之后,新版本命令set password会报错。应该用
alter user 'root'@'localhost' identified by '123';
把密码改成123。重启MySQL,会发现密码已更新。到此,安装结束。