Install MySQL and MySQL-Front_MySQL

Install the MySQL and MySQL-Front mysql-frontbitsCN.com

Today, we have installed MySQL and a MySQL client environment MySQL-Front for MySQL.

The official MySQL website is http://dev.mysql.com/. here you can download the latest website: http://dev.mysql.com/downloads/

At the time of writing this article, the latest version is 5.5.20. You can select 32-bit or 64-bit. you can also choose to download the compression method or use a Windows installer. for new users, it is easier to use a Windows installer.

The specific installation is nothing special.

Connector

Using MySQL in. NET environment, you also need a connector, you can download here: http://dev.mysql.com/downloads/connector/net/

The current version is MySQL 6.4, 5.0, 5.1, and 5.4. MySQL 5.5 and later versions support Windows verification, client table caching, simple connection failover support, and SQL generation for EF framework enhancement.

The simplest installation method is to use the Windows installer, as shown in:

Then select the installation type

If you choose a typical one, install it directly. If you select custom, the following custom page is displayed.

The installation confirmation page and the installation completion page.

Complete page.

Use MySQL in. NET

Official offers a lot of examples, you can view directly here: http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials.html

First, you need to referenceMySql.DataAssembly.

The usage is similar to the use of SQLServer.

using System;using System.Data;using MySql.Data;using MySql.Data.MySqlClient;public class Tutorial1{    public static void Main()    {        string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";        MySqlConnection conn = new MySqlConnection(connStr);        try        {            Console.WriteLine("Connecting to MySQL...");            conn.Open();            // Perform database operations        }        catch (Exception ex)        {            Console.WriteLine(ex.ToString());        }        conn.Close();        Console.WriteLine("Done.");    }}

After installing MySQL, we can use it through the command line interface, similar to using the SQL-Plus command line tool of Oracle.

In this case, we must master a large number of commands. For most users, the GUI is always quite popular. MySQL-Front can solve this problem.

MySQL-Front provides a GUI for MySQL, or Management Studio similar to SQLServer.

Address of the software: http://www.mysqlfront.de/wp/

A friend helped me copy one, but there was a problem after installation. download one here to solve the problem.

On the MySQL site, also found a MySQL Workbench, see the introduction function is similar, but not used,: http://dev.mysql.com/downloads/workbench/5.2.html

I checked the following information:

MySQL Workbench is a visual database design tool recently released by MySQL. This tool is a dedicated tool for designing MySQL databases.

The physical data model you created in MySQL Workbench is called. A physical data model is a data model for a specific RDBMS product. The model in this article will have some unique MySQL specifications. We can use it to generate (forward-engineer) database objects. in addition to tables and columns (fields), we can also contain views.

This article provides a detailed introduction to the MySQL Workbench tutorial (Beginner Edition.

The above is the installation of MySQL and MySQL-Front_MySQL content, more relevant content please pay attention to PHP Chinese network (www.php1.cn )!