Installation and simple operation of Ubuntu MySQL

Installation

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

　　　　　　sudo apt-get install Libmysqlclient-dev

Simple management　

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

The test is under the/ETC/MYSQL/MYSQL.CONF.D folder

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.

Installation and simple operation of Ubuntu MySQL