How to configure mysql after installing it

The configuration method for installing mysql: first open the bin directory of mysql and install the mysql service; then initialize mysql and enable the mysql service; finally log in and verify.

More related free learning recommendations: mysql tutorial(video)

Configuration method for installing mysql:

*Open the command line as an administrator (as shown in the figure below)

①Go to In the bin directory of mysql:

②Install the mysql service: mysqld --install

③Initialize mysql. Here, initialization will generate a random password, as shown in the frame below. Remember this password, which will be used later (mysqld --initialize --console)

④Start the mysql service (net start mysql)

⑤Login verification, whether mysql is installed successfully! (Please note that the random password generated above does not include the space before the previous symbol, otherwise the login will fail). If it is the same as the picture below, it means that your MySQL has been installed successfully! Note, you must first enable the service, otherwise the login will fail and an access denied prompt will appear! ! !

The above is the detailed content of How to configure mysql after installing it. For more information, please follow other related articles on the PHP Chinese website!