MySQL免安裝版環(huán)境變量配置

將下載的MySQL壓縮包解壓到目錄（按個(gè)人習(xí)慣修改）：D:/soft/MySQL

1. 初始化數(shù)據(jù)庫(kù)

   D:/soft/MySQL/bin/mysqld --defaults-file=D:/soft/MySQL/my.ini --initialize-insecure --user=mysql

2. 啟動(dòng)數(shù)據(jù)庫(kù)

   D:/soft/MySQL/bin/mysqld --console

3. 免密碼登錄

   D:/soft/MySQL/bin/mysql -u root --skip-password

4. 重置root密碼

   ALTER USER'root'@'localhost' IDENTIFIED BY 'root';

5. 將MySQL安裝成服務(wù)

   D:/soft/MySQL/bin/mysqld --install MySQL --defaults-file=D:/soft/MySQL/my.ini

6. my.ini 配置文件內(nèi)容

   [mysqld]

   # setbasedir to your installation path

   basedir=D:/soft/MySQL

   # setdatadir to the location of your data directory

   datadir=D:/soft/MySQL/data