mysql 配置

1.mysql文件位置 

D:\mysql-8.4.4-winx64\

D:\mysql-8.4.4-winx64\my.ini

[mysqld]
basedir=D:\\mysql-8.4.4-winx64
datadir=D:\\mysql-8.4.4-winx64\\data
port=3306

1.5环境变量 path :加一个 

D:\mysql-8.4.4-winx64\bin

2.mysqld install

3.观察  注册表位置:

计算机\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL

D:\mysql-8.4.4-winx64\bin\mysqld MySQL

D:\mysql-8.4.4-winx64\my.ini

4.

mysqld --initialize

mysqld remove

net start mysql

net stop mysql

重置密码 

mysqladmin -u root -p password root;

Access denied for user 'root'@'localhost' (using password: YES)

net stop mysql 停止MySQL服务

新开cmd

mysqld --defaults-file="D:\mysql-8.4.4-winx64\my.ini" --console --skip-grant-tables

新开cmd

mysql -u root mysql

update MySQL.user set authentication_string=password('root') where user='root';
flush privileges;
quit;
 
 
  mysql -u root -p mysql