1、MySQL下载地址
MySQL :: Download MySQL Community Server (Archived Versions)https://downloads.mysql.com/archives/community/2、下载解压后进行环境配置
3、进入安装mysql安装目录配置my.ini文件
[mysql]
default-character-set=utf8
[mysqld]
explicit_defaults_for_timestamp=true
[mysqld]
character-set-server=utf8
default-storage-engine=INNODB
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
4、以系统管理员身份运行cmd命令:
mysqld --initialize-insecure
5、安装服务:mysql -install
6、启动服务:net start mysql
7、设置超级管理员身份:mysqladmin -u root password 1234
8、登录MySQL: mysql -uroot -p1234
9、登录成功、创建数据库:create database testdb;
10、删除数据库:drop database testdb;
11、创建数据库前判断数据库是否存在再创建:create database if not exists testdb;