MySQL database operations

I finally started to learn MySQL today, but it is too troublesome to use MySQL. I am prompted to use phpMyAdmin to manage the database. But phpMyAdmin is not intelligent and requires configuration, and it is also troublesome to manage the web version, I searched for an installed MySQL management software later.

The software name is navicat8lite_mysql_cs.exe. navicat is a powerful MySQL database management and development tool. Navicat provides professional developers with a powerful enough cutting-edge tool, but it is still easy to learn for new users. Navicat uses an excellent graphical user interface (GUI) that allows you to quickly and easily create, organize, access, and share information in a secure and easier way. Users can have full control over the MySQL database and display different management materials, including a multi-functional graphical management tool for users and access permissions, transfers data from one database to another (Local to remote, remote to remote, remote to local) for file backup. Navicat supports Unicode and multi-line connections between local and remote MySQL servers. Users can browse databases, create and delete databases, edit data, create or execute SQL queries, and manage user permissions (security settings) back up/restore databases, and import/export data (CSV, txt, DBF, and XML file types supported. The new version is compatible with any MySQL 5.0.x server version and supports triggers and binary varbinary/BIT data types.

Resources can be downloaded on csdn: http://download.csdn.net/source/1132398

The software is less than 8 Mb. After downloading the software, select the default one and press Enter. A desktop shortcut will be created. Open navicat. In the displayed logon dialog box, enter the user name and password, and click "test connection". You can log on directly. The test is for fear of incorrect input.

Let's take a look at the simple navicat interface:

You are familiar with the logon interface. The traditional windows Windows are easy to operate and are in full Chinese version. They are similar to SQL Server operations, but they are simpler, the most important thing is that you no longer have to worry about configuration commands and symbols, and you don't have to look up any configuration files.