navicat alternative

sudo apt-get updatesudo apt-get install wine1.6sudo apt-get install libfreetype6:i386sudo apt-get install libsm6:i386sudo apt-get install libxext6:i386Go to navicat website download installation package, URL: http://www.navicat.com/en/download/download.htmlGo to the download directory, unzip the package:tar-zxvf navicat120_mysql_en. Tar. GZ (currently the latest version) CD into the installation directory to locate the Start_navicat file,sudo./star

Today back up the data on this site, the resulting SQL file is relatively large, of course, this SQL contains more redundant data. With Navicat direct import words, error MySQL server has gone away. As shown in the following illustration: Solutions Open the tools in the Navicat menu, select Server Monitor, then select the database in the left column, click the variable table item in the ri

The Navicat is installed on machine A and the IP address is IPA. The MySQL database is installed on machine B and the IP address is IPB. 1, into the machine B MySQL database command line, input Grant all on *.* to ' root ' in IPA ' identified by ' password '; IPA is the IP address of the authorized machine A, password is the password of the MySQL database in machine B. 2, in Machine A's navicat, estab

In Navicat for Mysql,postgresql and Oracle The error occurred because the MySQL account does not have sufficient permissions to connect to the remote MySQL server. Only "localhost" connections are allowed by default after MySQL installation. Therefore, most server-side scripting programs can easily connect to local databases on local servers. The client computer is blocked by the remote server until the user right is configured. If you want to access

Tags: regex ret mysql 8.0 ann input image connection failed CSDN mysqNote: This article is for mac!! only ProblemAfter installing MySQL successfully, want to get a database to try, but error. Not an error code, but a piece of code:Authentication plugin ‘caching_sha2_password‘ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not foundProbably means that you can't load the authentication plugin ' Caching_sha2_password 'Solve Open System Prefer

Label:*********************general Information******************** Server type: MySQL Connection Name: ApimanagerHost name or IP address: 192.168.8.86 Port: 3306 User name: Apimanager Save Password: True *********************advanced Information******************** Set Location: C:\Users\Administrator\Documents\Navicat\MySQL\servers\apimanager Code: 65001 (UTF-8) Maintain connection interval (seconds): N/A Using the MySQL character set: True Use compr

1, open Mamp software, start service, click Webstart, jump to the management interface, copy the socket corresponding content,A, click Webstartb, copy the contents of the socket2. Open the Navicat and create the connection. In the general options, fill in the information about MySQL with Webstart in the advanced option, the socket in the Webstart is copied and pasted, the test link is successful,A, in the general options, fill in the information about

First you need to prepare a excel,ps with data: The header corresponds to the field name in the database table:　　　　　 Then "File---> Save As. csv file" If you have Chinese in your data, then you need to process the CSV file, otherwise it will fail to import, with EditPlus or other editor (save can modify the encoding format of the editor), open the CSV file, save is to choose the encoding format of Utf-8, (PS: The encoding format of your database is also utf-8). und

Direct use of Navicat via IP connection will report various errors, for example: Error 1130:host ' 192.168.1.80 ' is not allowed to connect to this MySQL server.After personal verification, a solution is obtained, as follows:Authorization law:1. First use localhost to log on to the database you want to connect remotely2. Open the Command Prompt window and enter the following command:Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by '

Refer to Address: 60764420Reprint declaration Address: http://blog.itpub.net/15498/viewspace-2134152Here's how:Use the Columns table information in MySQL's Information_schema library to implementFor example, you need to export the data dictionary information for the IXINNUO_ZXPT library:Open Navicat, select query-new query:Select Table_schema as ' database ', table_name as ' table name ', column_name as ' field name ', Column_type as ' data type ', EX

Tags:--technology info ASE from set OSC use encryption modeExt.: https://www.cnblogs.com/shiysin/p/shiysin.htmlToday under a MySQL8.0, found that navicat connection is not, always error 1251;The reason is that the MySQL8.0 version of the encryption method and MySQL5.0 is not the same, the connection will be error.Tried a lot of ways, and finally found a way to achieve:Change the encryption method　　1. Enter the root account of MySQL from the command li

Label:Recently the computer changed to Mac, a lot of software and win is not the same, is slowly adapting to the original client connection Oracle is PL/SQL develop, the egg is not the Mac version,Use the Navicat, the specific settings are as follows1. New Connection2, the configuration is as follows3, then connect the test, if the luck is good, is the connection success, of course, most of the situation should be the following error,4, Reason analysi

Tags: mysql timer stored procedure cursor1. Creating a stored procedure with a cursorSQL creation:Create PROCEDURE daily_max_avg_online () begindeclare max_online int;declare avg_online int;declare time TIMESTAMP; Declare cur cursor FOR select MAX (Online_num), round (avg (online_num)), Date_format (Statistical_time, '%y-%m-%d ') from Real_time_online_statistics GROUP BY Date_format (Statistical_time, '%y-%m-%d '); open Cur;cur:loopfetch cur into max_ Online,avg_online,time;insert into Daily_max

Using Navicat to connect remote MySQL data error:A friend may come across the use of navicatForMySQL remote connection MySQL database will prompt 10061, 1045 error or 2003-can ' t connect toMySQL on ' 192.168.1.2 ' (10061),The reason for this is that MySQL does not allow remote connections. The simplest way to do this is to copy the code below the MySQL remote Configuration Code grant all privileges on * * to [email protected] '% ' identified by ' you

Label: This error occurs if you want to connect to your MySQL:ERROR 1130:host ' 192.168.1.81 ' isn't allowed to connect to this MySQL serverWorkaround:1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"Mysql-U root-PvmwareMysql>use MySQL mysql>update User Set host = ' mysql>sel

First, change to 32-bit navicat!!!Second, go to Oracle website to download the client you want to connect to the data version.Note: You need to download two files, take 11.2.0.4.0 version as an example, need to download　　　　 instantclient-sqlplus-nt-11.2. 0.4. 0 . zip instantclient-basic-nt-11.2. 0.4. 0. zipUnzip the downloaded file to a place.Then, in the Navicat tools >> options >> Other >>oci, set t

with RootMySQL > GRANT all privileges on * * to ' root ' @ ' 192.168.1.16 ' identified by ' 123456 ' with GRANT option;flush privileges;Parameter description:* * refers to a database. Table so * * for all databases and tables.' Root ' @ '% ' for all hosts.Identified by ' 123456 ' is the password for Telnet.5. Navicat for MySQL Windows-side connection MySQL serverWith SSH channel access, the new connection is configured as follows (two diagrams explai