Mysql Installation failed error number 1364 Solution

All mysql users know that mysql is very lightweight and powerful. It was basically smooth during the installation and configuration process before mysql 5.5. Since mysql 5.5, after the last step is configured, Execute to apply security settings in the fourth step, an error number conflict occurs. Then, reconfigure the settings. You must delete the previous configurations.

 

If not, do not check Enable root access from remote machines

 

In this way, the database will basically succeed. However, if you do not select this option, your database can only be accessed by your own machine! GOOD LUCK