(Original article, not unauthorized deletion of this statement or change the content of the article without authorization, please indicate the source.)
1. The default is installed as c: / mysql, contains both MySQL and TEST databases, and change the directory to use the following form:
Driver: / newdir / mysql / bin / mysqld --Basedir Driver: / newdir / mysql
2. Install and run mysql in a service, use the following command:
(1) Install: c: / mysql / bin / mysqld-nt -install (2) Run: Net Start MySQL (3) Stop: Net Stop MySQL or mysqladmin -u root -P Shutdown
3. Test if the mysql work is normal, use the following command:
C: / mysql / bin / mysqlshowc: / mysql / bin / mysqlshow -u root -p mysqlc: / mysql / bin / mysqladmin version status proc
4. Set the password of the root user, use the following command:
C: / mysql / bin / mysqladmin -u root password 'new-password'
[Optional] 5. If you use mysql / bin / winmysqladmin.exe, MySQL will create new file my.ini in the Winnt directory and add the following:
[Winmysqladmin] Server = C: /Mysql/bin/mysqld-nt.exe
