![]() Other machines will not be able to connect unless you modify listen_addresses in the nf file, enable host-based authentication by modifying the $PGDATA/pg_hba.conf file, and restart the server. Remark: Does your remote server support SSH connection? If the answer is yes, you can use Navicat to connect with your remote MySQL server via a SSH tunnel.īelow is the steps that we'd like to assist you to use Navicat to access your remote PostgreSQL server from your desktop:īy default, PostgreSQL only allows connections from the local machine using TCP/IP connections. Please remember to reload the new user privileges setting by running this command in mysql/bin directory of your Linux/Unix server. YourPassword - You can setup a password for your account. YourPublicIP is the public IP address of your PC (can be IP range or use % to allow any host). GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY "YourPassword" YourUserName is the username that you would like to create. You can run the following command in your MySQL server command prompt. If your remote server is running in Linux/Unix platform, please telnet to your remote server (or by SSH). 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |