Navicat tools link MySQL "Access denied for user ' root ' @ ' IP '" User remote assignment

Title

Error adding permissions to user with Navicat remote connection database

Connect to MySQL

Mysql-uroot-p;use MySQL;

Change permissions

Use grant all privileges to change the user's remote permissions for some libraries

Grant all privileges the on Library name. Table name to ' user name ' @ ' IP address ' identified by ' password ' with grant Option;flush privileges;

Example

GRANT all privileges on * * to ' root ' @ '% ' identified by ' sjfio3342 ' with GRANT OPTION; Flush privileges;

Description

Library Name: The name of the database to be accessed remotely, all databases using "*"
Table name: The name of the table under the database to be accessed remotely, all tables using "*"
Username: The name of the user to assign to the remote access permission
IP Address: The IP address of the computer that can be accessed remotely, using "%" for all addresses
Password: the password that is used by the user to be assigned to the remote access permission

Navicat tools link MySQL "Access denied for user ' root ' @ ' IP '" User remote assignment