GRANT ALL PRIVILEGES ON *.* TO flush the privileges to update any records. CREATE USER USER 'YOUR_NEW_USER' identified by 'YOUR_PASSWORD' Above code is depreciated and you can do this alternative approach. If you’re using a higher version of MySQL like the 8.0, you’ll get an error like “ ERROR 1064 (42000): You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near ‘identified by “Your_password”‘ at line 1“. grant all privileges on *.* to identified by 'YOUR_PASSWORD' Then enter the following commands, make sure to change the default data. To do this, access your mysql via mysql -u -root -p.

To grant a remote access to MySQL server, you need to create a database user with a host wildcard “%”. There are only two causes that cause this problem, either by a database user no remote access or a configuration file. You probably get an error message that says “Driver Error, Can’t connect to MySQL server on ‘YOUR_IP_ADDRESS’ (10061)”. If you recently installed MySQL server in DigitalOcean or Upcloud and you use TablePlus on connecting to the server.

Tableplus connect to mysql