mysql配置

1. 配置环境变量

   xxxbin

2. mysql-win64 创建my.ini 文件

   　[client]
   　　port = 3306
   
   　　default-character-set=utf-8
   
   　　[mysqld]
   #设置为自己MYSQL的数据目录
   basedir=D:mysql-5.7.19-winx64
   #设置为MYSQL的数据目录
   datadir=D:mysql-5.7.19-winx64data
   port = 3306
   character_set_server=utf8
   #跳过安全检查
   skip-grant-tables
   

3. 管理员cmd

   切换到bin目录

   cd /D D:mysql-5.7.19-winx64bin
   mysqld -install
   mysqld --initialize-insecure --user=mysql
   

   [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-O4k692Bq-1640750024882)(C:Users11021AppDataRoamingTyporatypora-user-imagesimage-20211227190854510.png)]

net start mysql 

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-kIkRv73d-1640750024883)(C:Users11021AppDataRoamingTyporatypora-user-imagesimage-20211227190918122.png)]

mysql -u root -p
enter
use mysql;
update user set authentication_string=password('fgj') where user ='root' and Host='localhost';
flush privileges;
quit
注销ini最后一句话

net stop mysql
net start mysql

mysql -u root -p
fgj

mysql -h 127.0.0.1 -P 3306 -u root -p 

sc delete MySQL
s

0.0.1 -P 3306 -u root -p

sc delete MySQL