1) install MySQL Server> mysqld-install
2) Start the MySQL Server> Net start MySQL
3) connect to MySQL> mysql-H localhost-u root-P
Enter Password: biao12
4) use the query statement
Mysql> select version (), current_date ();
5) Open the Data command> Use Database mydb; // The semicolon ";" cannot be omitted.
How to remove MySQL from system error 1067
1. Correct the MySQL path in the Windows directory (Win2000 is WINNT). The default value is C:/MySQL. If the file does not exist, manually create it.
[Mysqld]
# Set basedir to your installation path
Basedir = D:/MySQL
# Set datadir to the *** of your data directory
Datadir = D:/MySQL/Data
[Winmysqladmin]
Server = D: // MySQL/bin/mysqld-nt.exe
2. Start the service again.
D:/www/MySQL/bin> Net start MySQL
If:
MySQL service is starting
MySQL service started successfully
As shown in the prompt, the service is successfully started.
3. Now you can test whether MySQL works properly. Run the following command:
D:/www/MySQL/bin> mysqlshow
D:/www/MySQL/bin> mysqlshow-u root MySQL
D:/www/MySQL/bin> mysqladmin version status proc
D:/www/MySQL/bin> mysqladmin-u root Shutdown
(After this statement is run, the MySQL service is closed. After the service is started again, MySQL can be used)
4. The default username is root and the password is blank. For more information about how to correct the MySQL user name and password, see MySQL.
PS: from the Internet