Tag Archives: navicat

[Solved] Deploying Tomcat connection in Linux Navicat reports error 2059 – authentication plugin ‘caching_sha2_Password ‘cannot be loaded: + Xi input 9 g

This problem gives me a headache because navicat15.0.26 does not support the newly added encryption method of mysql8.0, caching_sha2_Password, so we need to modify the user’s encryption method. First log in to MySQL,

mysql -uroot -p

This is my configuration information

Mysql 8.0.27
Navicat 15.0.26
tomcat 9.0.54
jdk 1.8.0.65

View encryption method:

show variables like 'default_authentication_plugin';

Log in to the database using the command-line client tool provided with MySQL database, and enter use mysql

Query the original authentication plug-in of MySQL user from the database user table

select user,host,plugin,authentication_string from user;

Replace the authentication plug-in used by the user with MySQL used in the previous version_ native_ password

ALTER USER 'root'@'localhost'IDENTIFIED WITH mysql_native_password BY'root';

Just use Navicat to connect again.

Navicat Import Datas Error: — 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

Error in importing MySQL database from Navicat — 1153 – got a packet bigger than ‘Max_allowed_packet’ bytes

After checking, it turns out that the data table exceeds the maximum value of SQL file read and executed by MySQL by default; The maximum is 16m. My SQL file is 200m, so it cannot be executed

Solution:

Find the file my.cnf in the MySQL installation directory, search [mysqld], and add a sentence below it

max_allowed_packet=400M

Restart MySQL service

This size is set according to the size of your SQL file

Navicat even Oracle reports an error [no matching authentication protocol]

Error Description:

             An error is reported when navicatk connects to Oracle database (all connection settings are normal)

             ORA-28040:No matching authentication protocol

Error reason:

             Missing OCI corresponding to Oracle or missing OCI corresponding to Oracle version

             OCI is a file in the instant client, which is a compact version of ORALCE

Problem solving:

       1. Download the version of instance client according to different Oracle versions

              Oracle 9i or later requires instance client 11; Oracle, 8i need instance client 10

              32-bit download address: http://www.oracle.com/technetwork/topics/winsoft-085727.html

              Note: Navicat only supports 32-bit clients, regardless of whether Navicat itself is 32-bit or 64 bit

                    In addition, to download the basic version, the non basic Lite version does not support Chinese

        2. Place the downloaded instance client in the corresponding file directory in Navicat

            ( (available through Navicat tools – Options – environment – OCI environment)

        3. Select the OCI file in the instant client just added in Navicat tools – Options – environment – OCI environment

File connection (instantclient)_11_2):

            https://share.weiyun.com/5fwQp5t Password: drgtk2

Error in connecting to MySQL via Navicat on MAC

After installing MySQL on the Mac, connect with Navicat, and a connection failure error will pop up in the connection test:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

Find the following solutions online:

1.mysql -u root -p 2.use mysql; 3.alter user 'root'@'localhost' identified with mysql_native_password by '11111111'; 4.flush privileges;

explain:

    1. Root is the user name, localhost is the IP address 127.0.0.1, especially the local machine, mysql_native_Password is the old password verification mechanism, followed by the password for MySQL.

    2. Flush privileges: refresh the system permission related tables of MySQL.

 

As shown in the figure:

Back to Navicat, the personal test is successful!

 

Postscript: some netizens said that the new version would report this error. The MySQL I installed is the latest version 8.0.13. I don’t know if this is the reason.

[Solved] Navicat Connect Oracle :Cannot load OCI DLL, 126

Error in 32-bit system: cannot load OCI DLL, 126

Solution: Navicat menu – tools – > Options – > OCI select oci.dll in bin under Oracle installation directory

Error in Windows Server 2008: cannot load OCI DLL, 126

Oracle 11g R2 is installed on Windows Server 2008 server. When using Navicat to connect Oracle, the following error will be prompted:

Cannot load OCI DLL, 126: Instant Client package is required for Baic and TNS connection ,
For more information: http://wiki.navicat.com/wiki/index.php/Instant_client_required

According to the above link page, Navicat only supports 32-bit instant client. Therefore, although we have installed 64 bit Oracle, we need to download a 32-bit client as Navicat only supports 32-bit http://www.oracle.com/technetwork/topics/winsoft-085727.html 。

Here is the complete solution:

Step 1: download the file from the above address: instantclient-basic-nt-12.1.0.2.0.zip,

Step 2: unzip the installation package to: D]/APP/administrator/product/instantclient_ 2_ 2_ x32

Step 3: open Navicat, select tools → options → other → OCI, and then set OCI library as D: APP/administrator/product/instantclient_ 12_ 2_ X32/oci.dll, set SQL * plus as: D]/APP/administrator/product/11.2.0/dbhome_ 1/BIN/sqlplus.exe.Sure

Step 4: the test is successful

Remote connection with Navicat mysql:Can ‘t connect to MySQL server (10060)

Front end developers must read! Starting from scratch, teach you to build a low code website platform in stages>>>

There are two reasons for this phenomenon, one is that the current user is rejected by the MySQL server, the other is that port 3306 is banned by the firewall and cannot be connected to the port. The solution is as follows:

1. Set remote user access rights:

//Any remote host can access the database

mysql> GRANTALLPRIVILEGESON*.*TO’root’@’%’WITHGRANTOPTION;

//You need to enter a command for the modification to take effect

mysql> FLUSHPRIVILEGES;

//Exit

mysql> EXIT

Sometimes it’s easy to develop ports on the alicloud console

After entering iptables, we found that port 3306 is not open, so we can only tap it in iptables with our hands

2. Open port 3306 in iptables

#/SBIN/iptables iinput PTCP — dport3306-j accept
Restart service

However, this is not recommended as it can cause security issues

  

Note: sometimes it’s not easy to add a port to the console. You might as well go into iptables to see if you really add rules

When using SSH to log in to MySQL, Navicat reported an error: expected key exchange group packet from server

1、 Navicat SSH connection mode

Because the company uses alicloud’s RDS, it needs to connect to the database through the intranet (it does not provide direct public network access). At this time, you can use the SSH method of Navicat to connect to the RDS through a springboard machine

2、 Connection error and solution

Error: SSH: expected key exchange group packet from server

Solution:

1. Upgrade Navicat

2. Modifying the configuration of sshd

[root@Manager ~]#vim /etc/ssh/sshd_config  #Edit the sshd configuration file and add at the end
KexAlgorithms [email protected],ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha1