How to configure Mysql and the Mysql service cannot be started

Mysql compressed package installation and configuration tutorial

1. First download the Mysql compressed package on the official website, download and unzip it.

#2. Create a new folder data in your Mysql directory. Make sure data is empty

3. Configure the my-default.ini file, your own address, and save it.

##4. Configure the environment variables of mysql environment (If you don’t know how, go to Baidu by yourself), just add it. Don't log in yet.

5. Install Mysql, open the command prompt (administrator), you must be an administrator or you will not have enough permissions. Enter

mysqlld -install and the installation is successful, then enter a very important sentence

mysqld --initialize-insecure --user=mysql

The user name is root and the password is empty

##6. Next start the mysql service

net start mysql

7. Then you can use Navicat to connect with user name root password

Notes

data must be empty

mysqld --initialize-insecure --user=mysql Important

The above is the detailed content of How to configure Mysql and the Mysql service cannot be started. For more information, please follow other related articles on the PHP Chinese website!