To create a remote user account with root privileges, run the following commands: GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD'; 'USERNAME' is the username to be created. 'IP' is the public IP address of the remote connection. 'PASSWORD' is the password to be assigned for this username. (IP can be replaced with % to allow this user to logon from any host or IP) mysql> FLUSH PRIVILEGES; mysql> exit; Open the command prompt and enter the following commands: net stop MySQL net start MySQL the MySQL service name maybe changes based on the version you installed. In my situation, MySQL version is MySQL Server 5.7. So I use the following command net stop MySQL57 net start MySQL57 MySQL is most likely in STRICT mode. Try running SET GLOBAL sql_mode='' or edit your my.cnf to make sure you aren't setting STRICT_ALL_TABLES or the like.