How to verify that mysql is installed successfully

After MySQL is successfully installed, how to verify that MySQL is successfully installed?

Method to verify successful mysql installation:

1. Command line:
net start mysql
If it can start, it means the installation is successful.
If you want to query the default database, you can use mysqlfont, or directly operate the command line
Enter the bin folder in the installation directory, or configure the environment variables, and then
2, mysql -uroot -p
Then enter the password! ~
ok! ~

3、mysql> status
--------------
E:\MySQL\MySQL Server 5.0\bin\mysql .exe Ver 14.12 Distrib 5.0.15, for Win32 (ia
32)
Connection id:         2
Current database:
Current user:                                                                                                                                                                                                                                       :                    ; gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 28 min 8 sec

Threads: 1 Questions: 6 Slow queries: 0 Opens: 0 Flush tables: 1 Open table
s: 6 Queries per second avg: 0.004

The above is the detailed content of How to verify that mysql is installed successfully. For more information, please follow other related articles on the PHP Chinese website!