1.下载MySQL,我用的是mysql-8.0.11-winx64
https://dev.mysql.com/downloads/mysql/
2.解压到目录D:\MySql
3.在D:\MySql\mysql-8.0.11-winx64目录下新建my.ini,键入代码如下
[mysqld]
#mysql安装目录
basedir = D:\MySql\mysql-8.0.11-winx64
#设置mysql数据库的存放目录
datadir = D:\MySql\mysql-8.0.11-winx64\data
#设置3306端口
port = 3306
#server_id = ......
#mysql安装目录
basedir = D:\MySql\mysql-8.0.11-winx64
#设置mysql数据库的存放目录
datadir = D:\MySql\mysql-8.0.11-winx64\data
#设置3306端口
port = 3306
#server_id = ......
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#mysql服务器的编码
character-set-server = utf8mb4
#mysql服务器的编码
character-set-server = utf8mb4
performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256
table_definition_cache = 400
table_open_cache = 256
[mysql]
#mysql默认编码
default-character-set = utf8mb4
#mysql默认编码
default-character-set = utf8mb4
[client]
#mysql客户端默认编码
default-character-set = utf8mb4
#mysql客户端默认编码
default-character-set = utf8mb4
4.上述步骤完成后将mysql的路径添加到系统变量中
5.管理员身份打开CMD
6.安装数据库mysqld –install
7.数据库初始化mysqld –initialize-insecure(没有密码生成,密码为空)
8.启动服务器net start MySQL
9. 登录mysql -uroot –p
10.usemysql;
11.修改密码ALTER USER'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
这里的localhost对应本地,如果是远程访问 mysql的话,需要将localhost改成%;
password是root的密码,使用时也要进行对应修改。
12.打开 Navicat Premium连接即可。