MySql的下载和安装
MySQL的下载
1.从官网下载mysql,点击官网地址进入官网。
点击MySQL Community Server进入下载页面。
2.下载页面,有两个版本Archive(.zip自己配置安装)和Installer(.mis版本根据提示一步步来即可),根据需求下载。
3.我本人使用手动配置的版本,并开始下载。
4.下载成果展示。
5.我是用Archive,开始安装。
- 解压到安装目录。
- 在安装目录bin同级文件夹中新建my.ini文件,文件内容如下:
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
[client]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
# 设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=D:\\software\\install\\develop\\mysql\\mysql-8.0.21-winx64
# 设置 mysql数据库的数据的存放目录,MySQL 8+ 不需要以下配置,系统自己生成即可,否则有可能报错
# datadir=C:\\web\\sqldata
# 允许最大连接数
max_connections=20
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
6.在cmd中配置文件。win+r —>cmd 打开文件安装位置(我的):D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin
7. 初始化数据库(获得初始密码):mysqld --initialize --console
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld --initialize --console
结果展示(我的初始密码为:aBm!,*w#=8!#)
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld --initialize --console
2020-07-27T09:07:25.604873Z 0 [System] [MY-013169] [Server] D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin\mysqld.exe (mysqld 8.0.21) initializing of server in progress as process 11424
2020-07-27T09:07:25.606240Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-07-27T09:07:25.622634Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-07-27T09:07:26.095317Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-07-27T09:07:27.338525Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: aBm!,*w#=8!#
8.输入以下安装命令:
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld install
结果展示
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld install
Install/Remove of the Service Denied!
9.哎呦喂报错啦,解决办法“以管理员身份运行“cmd”(安装和启动mysql都需要管理员权限偶)。在打开的命令窗口右击查看cmd.exe文件位置,找到cmd.exe文件,鼠标右击–>以管理员身份运行,输入命令D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld install
查看结果Service successfully installed,服务安装成功:
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld install
Service successfully installed
9.启动服务
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>net start mysql
发生系统错误2
系统找不到指定的文件
10.解决办法
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld --remove
Service successfully removed.
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>mysqld --install
Service successfully installed.
D:\software\install\develop\mysql\mysql-8.0.21-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
11.到此,安装完成(初始化密码未修改,需要修改请自行查看mysql的权限修改博客)。