Installation of MySQL under Ubuntu

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

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.

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

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

directory structure Analysis (this structure is only for use with Apt-get install online installation situation):

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/

MySQL Graphical management software:

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

Open Source: MySQL Workbench

Business: Navicat

Installation of MySQL under Ubuntu