![]() GRANT ALL PRIVILEGES ON *. ![]() Please consult with your database administrator as they usually will have administration right to set the privilege. You can run the following command in your MySQL server command prompt. The major benefit of SSH tunneling is that it allows us to connect to a MySQL server from behind a firewall when the MySQL server port is blocked. If your remote server supports SSH connection, your Navicat will be able to connect with remote MySQL databases through SSH tunnel without making any changes to existing MySQL privileges setting. MySQL server uses the User, Db, and Host tables in the MySQL database during both stages of access control. For example, Create table privilege, Drop table privilege or Alter table privilege.
0 Comments
Leave a Reply. |