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