MySQL Practical third party draw net source building tool Collection

MySQL is a client-server-based DBMS, so in order to use MySQL for the draw net source build, you need a client software to provide MySQL with the command to execute. Enterprise e: 217 1793 408 that is, you need a tool to write and test MySQL scripts.

1. mysql Command line utility

After MySQL is installed, you can use this tool. The login method is as follows:

"1" ctrl+r run cmd start Ms-doc console;

"2" mysql–u user name [–h hostname or IP address]–p password
2. Navicat for MySQL

Navicat for MySQL is a powerful MySQL database management and development tool that provides professional developers with a powerful set of sophisticated tools that are easy to learn for new users. It supports most of the latest MySQL versions of features, including triggers, stored procedures, functions, events, retrieval, permission management, and more.

3, Heidisql

Heidisql is a graphical interface for simplifying your MySQL server and database management. The software allows you to browse your database, manage tables, browse and edit records, manage user permissions, and more. In addition, you can import data from a text file, run SQL queries, synchronize tables between two databases, and export selected tables to other databases or SQL scripts. Heidisql provides a simple and easy-to-use interface for switching SQL queries between database views and labels with syntax highlighting. Other features include Blob and MEMO editing, large SQL script support, user process management, and more.

4. MySQL Workbench

Developed by MySQL, this tool is a cross-platform Visual Database design tool. It is a highly anticipated replacement for the DBDESIGNER4 project, a local graphical tool that supports a wide range of operating systems including Windows, Linux and Os X, with several different versions.

5, PhpMyAdmin

phpMyAdmin is a free software tool, written in PHP, for managing MySQL databases over a network. It supports a large number of MySQL database operations, and its user interface supports most common operations, such as managing databases, tables, fields, associations, indexes, users, permissions, and so on, as well as directly executing SQL statements.

6, SQLyog

SQLyog is a MySQL database Universal management tool. Its community edition is free and open source software, which complies with the GPL license agreement. Most of the features that developers need when using MySQL can be done with a simple click of a mouse, which allows them to view query result sets, query profilers, server messages, table data, table information, and query history through a tabbed interface. In addition, developers can easily create views and stored procedures.

MySQL Practical third party draw net source building tool Collection