![]() ![]() Otherwise, your changes will have no effect until you restart the server.Ģ. If you updated the privileges, you should execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. You can use Navicat's Manage Users Feature to add a new user in table of database. Inside Navicat, you can find a function called "Manage Users"/"Users". If your remote MySQL server is running in Windows platform, we would suggest you to install Navicat in your remote Windows server. ![]() (this is probably not useful)įred, connecting remote MySQL server from the host with IP address 144.155.166.177įred, connecting remote MySQL server from any host in the 144.155.166 class C subnet ![]() IP address or Host value of your desktop's Internet Connectionįred, connecting remote MySQL server from his desktop ""Īny user, connecting remote MySQL server from his desktop ""įred, connecting remote MySQL server from any host in the loc.gov domainįred, connecting remote MySQL server from x.y.net, x.y.com,x.y.edu, etc. Host IP example can be found in the following table. For security concern, we would suggest you to set the host address with a fixed IP or IP range. Please check your Internet connection's public IP address or IP range (To check IP address, please enter the command IPConfig in Windows "Dos" Prompt). How do I configure the privilege system so that I can use Navicat to access my remote server from my desktop?Īpply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for MariaDB, Navicat Premiumīelow is the steps that we'd like to assist you to use Navicat to access your remote MySQL server from your desktop:ġ. ![]()
0 Comments
Leave a Reply. |