mysql 根目录 下 新建 my-3308.conf ``` [mysqld] # mysql根目录 basedir = D:/mysql-5.7 # mysql 数据库存放地址 datadir = E:/mysqldata3308 port = 3308 enable-named-pipe socket = mypipe3308 ``` cmd 管理员方式运行 ``` D:\phpEnv\server\mysql\mysql-5.7\bin\mysqld --install mysqld3308 --defaults-file=D:\phpEnv\server\mysql\mysql-5.7\my-3308.conf ``` 提示 Service successfully installed. 启动 sc start mysqld3308 关闭 sc stop mysqld3308 删除 sc delete mysqld3308 https://blog.csdn.net/xiaodaiwang/article/details/108077931 关闭mysql 服务 mysqld --defaults-file=D:\phpEnv\server\mysql\mysql-5.7\my-3308.conf --skip-grant-tables 另开一个控制台 ``` mysql -P3308 use mysql; update user set authentication_string=password(“root”) where user=“root”; 不行就用, 低版本是这个 update user set password=password(“root”) where user=“root”; flush privileges; ``` mysql -P 3308 -u root -p