This should work now, but Ubuntu 18.04.1 comes with a MySQL configuration that has a default secure connection that we need to take care of. 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)”. I’m trying to wrap TablePlus - which is a commercial database management tool - as a nix package from the provided *.deb package.If you recently installed MySQL server in DigitalOcean or Upcloud and you use TablePlus on connecting to the server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |