How to solve 1044/1045 error when installing Navicat in Mysql _ MySQL

Source: Internet
Author: User
How to solve Navicat error 10441045 when installing Navicat in Mysql

BitsCN. comin Navicat for MySQL, PostgreSQL and Oracle
The error occurs because the mysql account does not have sufficient permissions to connect to the remote mysql server.
After mysql is installed, only "localhost" connections are allowed by default. Therefore, most script programs on the server can easily connect to the local database on the local server. The client computer is blocked by the remote server until user permissions are configured.

If you want to access the remote mysql server from your desktop, you must first know the permissions for the mysql system to work.
User information is stored in the user, db, host, tables_priv, and columns_priv tables named "mysql. When the mysql server is started, read the contents of these tables.

MySQL access control involves two phases:
1. the server checks that your desktop (host address or IP address) is accessible.
2. suppose you can connect to the server and check each request to see if you have sufficient permissions to execute it. For example, create a table, delete a table, or modify a table.

The MySQL server uses the User, Db, and Host tables of the MySQL database for access control in two phases.
If your remote server supports SSH connection, your Navicat will be able to connect to the remote MySQL database through the SSH tunnel without any modification to the existing MySQL permission settings. The main advantage of SSH in this tunnel is that it allows us to connect to the port blocked by the firewall on the MySQL server from the back,

Procedure:
You can run the following command at the MySQL server command prompt. Consult your database administrator because they usually have the permission to set permissions.

Grant all privileges on *. * TO 'yourusername' @ '%' identified by "YourPassword ";

Or

Grant all privileges on *. * TO 'yourusername' @ 'yourip' identified by "YourPassword ";

BitsCN.com

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.