You should flush the host tables if some of your hosts change IP number or if you get the error message Host 'host_name' is blocked. Reload the privileges from the grant tables in the mysql database.Įmpty the host cache tables. Right-click the connection and select Flush from the pop-up menu. To execute Flush, you must have the Reload privilege, see MySQL/MariaDB Security. To move back the connection to My Connections, simply right-click the connection under Navicat Cloud and choose Move to My Connections.įlush has several variant forms that clear or reload various internal caches, flush tables, or acquire locks. To move the connection under My Connections to Navicat Cloud, right-click the connection under My Connections and choose Move to Navicat Cloud. You can edit the connection information by right-click the connection and choose Connection Properties. Note: Navicat authorizes you to make connection to remote servers running on different platforms, i.e. To connect to a database/schema, simply double-click it in the tree.
If the Show objects in connection tree option is checked at the Options window, all database/schema objects are also displayed in the tree. Then, enter the necessary information in Connection Properties window.Īfter you have created your connections, your databases/schemas appear in the connection tree on the left. To create a new connection, click or choose File -> New Connection. If you are new to the server or 'Net in general' and are not quite sure how things work, you may want to look at:
To start working with your server in Navicat, you should first establish a connection or several connections using the connection window.
0 kommentar(er)
