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.
reconnect the Navicat will solve the problem.
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
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 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