mysql的使用

安装

1、官网下载：https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.19-winx64-debug-test.zip
2、添加my.ini E:\czy\soft\mysql-8.0.20-winx64\my.ini

[mysqld]
port = 3306
basedir=E:/czy/soft/mysql-8.0.20-winx64
datadir=E:/czy/soft/mysql-8.0.20-winx64/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8

3、初始化服务

• 管理员权限进入cmd
• 进入安装目录：cd E:\czy\soft\mysql-8.0.20-winx64\bin
• mysqld -install
• mysqld --initialize-insecure --user=mysql
• net start mysql
• 注意，此时没有密码，两个回车后输入新免密 mysqladmin -u root -p password
• 进入数据库：mysql -u root -p

navicat连接mysql

- 管理员权限进入cmd，`mysql -u root -p`
- 

ALTER USER 'root'@'localhost' IDENTIFIED BY '你的mysql密码' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的mysql密码'; #修改密码
FLUSH PRIVILEGES; #刷新数据