What should I do if MySQL cannot be used after installation?

Here I will only talk about some issues related to MySQL database installation.

I have installed MYSQL before. It seems that I do not need to start the service manually, but I forgot to install the service manually. If mysql is not available just now, it may be that the service is not installed. Check it carefully.

Mysql crash Solution

View the default execution parameters of mysql command line client. Method: Start-> All Programs-> MySQL Server5.5-> MySQL5.5 command line client, right-click Properties. Mainly look at my. ini this, when I installed this, my-small.ini file, renamed my-ini file, save and then start it OK.

If the table has created a foreign key but it has no effect, it may be that the table type is InnoDB.

When logging on remotely, check whether the permissions are granted.