Tag Archives: navigated

How to Solve Navicat open view error

View ‘orgemp.view_allempinfo’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Right click to open the view design, click the top to optimize SQL and check the view SQL.

Check whether the view table does not exist or the field does not exist.

[Solved] Navicat connection error 1251 compatibility with docker MySQL

# Modify the encryption rules
(1) ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
# Update the user’s password
(2) ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
# Refresh permissions
(3)FLUSH PRIVILEGES;
reconnect the Navicat will solve the problem.

Navicate premium Connecting to a remote Oracle,ORA-12514: TNS:listener does not currently know of service requested in c

Navicate premium, ora-12514: TNS: listener does not currently know of service requested in connect descriptor

Ora-12514: TNS: listener does not currently know of service requested in connect descriptor

many methods on the Internet are to modify tnsnames.ora and listener.ora files, but the results are useless check the tnsnames.ora file and find that the service name is orcl.localdomain instead of orcl by default. Login successfully after modification

ERROR 2000 (HY000): Unknown MySQL error

After the installation of mysql5.7 physical machine, modify the binlog log in my.cnf, restart mysql, log in and connect to MySQL with the client of the machine, and report error 2000 (HY000): unknown MySQL error. This error will also be reported when mysqldump exports data of all tables,

solve:

1. When using systemctl restart mysqld, you can’t connect by using Navicat, but after using systemctl stop mysqld, you can connect by using systemctl start mysqld, but you still can’t export data by using mysqldump connection.

2. Directly back up the data file on MySQL, and then use docker to install mysql5.7, copy the data file to/var/lib/MySQL, a permission error will be reported, and then change the permission to chown mysql:mysql datadir Can be used normally, user name root password root

reference resources: https://dba.stackexchange.com/questions/91712/whats-causing-this-error-2000-hy000-unknown-mysql-error

Error in activation of Navicat premium register

Error in activating Navicat with registration machine

Version: Navicat premium 15

Error on decrypt rrequestf code

Processing: disconnect the network and reload Navicat (delete the registry according to the situation)

It is installed on Disk C by default (installation on disk D may not succeed, when the activation code is returned)

Results: it was successful