Installation and configuration of MySQL under Linux (Ubuntu) [reprint + Pro Test]

I've always felt a lot of trouble installing MySQL under Linux because it was a bit dizzy when it was installed because of a complicated configuration. Today, you need to connect MySQL with QT under Linux. The installation is equipped with a set.

1) First check if MySQL is installed in the system

Enter sudo netstat-tap inside the terminal | grep MySQL

If not reflected, the installed results are not displayed and are not installed. If shown below, you have installed

2) If it is not installed, install MySQL.

In terminal input sudo apt-get install mysql-server mysql-client

The results of the operation are as follows:

During this installation, you will be asked to enter the password for the root user (managing MySQL database user, non-linux system user), as required. As shown below:

3) test whether the installation was successful:

In terminal input sudo netstat-tap | grep MySQL

The installation succeeds if the following result is present:

4) You can also log in to MySQL test

In the terminal input Mysql-uroot-p next will prompt you to enter the password, enter the correct password, you can enter. As shown below:

5) Some simple management of MySQL:

Start MySQL service: sudo start MySQL

Stop MySQL service: sudo stop MySQL

Modify the administrator password for MySQL: sudo mysqladmin-u root password newpassword

Set up remote access (normally, the 3306 port that MySQL occupies is only listening on IP 127.0.0.1, denying access to other IPs (Netstat can see it). Cancel the local supervisor

Listen to the need to modify the My.cnf file:):

sudo vi/etc/mysql/my.cnf

Bind-address = 127.0.0.1//Find this content and comment

6) MySQL post-installation directory structure analysis (this structure is only for the use of Apt-get install online installation):

Database storage directory:/var/lib/mysql/

Related configuration file directory:/usr/share/mysql

Related Command Storage directory:/usr/bin (mysqladmin mysqldump, etc.)

Startup footstep Storage directory:/etc/rc.d/init.d/

7) MySQL graphical management software

Generally used there are two better, an open source, a commercial charge:

Open Source: MySQL Workbench (Specific usage introduction as I use, I will slowly summarize)

Business: Navicat (chargeable, 30 days experience, then I believe that everyone will have a way)

At this point, the installation and configuration of MYQL under Linux (Ubuntu) is complete.

Thank for reading!

----2014.01.17 by Lzq NY

Original source: http://www.2cto.com/database/201401/273423.html

Installation and configuration of MySQL under Linux (Ubuntu) [reprint + Pro Test]