Installation and configuration of MySQL under Ubuntu

Although the project is tight, still put some basic knowledge points to share, sharing good open source things, create real value!

The MySQL server installation configuration under Ubuntu is as follows:

I. Installation Method

1. sudo apt-get install Mysql-server2.    Sudoapt-get install Mysql-client3. sudo apt-get install Libmysqlclient-dev

Two. Directory structure

The MySQL and previous directory structures in the new version have changed:

Startup script:/etc/init.d/mysql

Configuration file path:

/etc/mysql

The actual configuration file is as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/04/wKiom1XyOAzx4RvhAAFJFd6Dtlg378.jpg "title=" 1.jpg " alt= "Wkiom1xyoazx4rvhaafjfd6dtlg378.jpg"/>

Configuration file is: mysqld.cnf

Three. Common configuration is as follows

3.1 Let root telnet the configuration method

Use Terminal login: Mysql-u root-p;grant all privileges on * * to [email protected] "%" identified by "password"; flush privileges;

Modify configuration file: Mysqld.cnf

Bind-address = 127.0.0.1

Comment out this line.

3.2 Other

This article from "LINUXQT Jinan high-tech Zone" blog, please be sure to keep this source http://qtlinux.blog.51cto.com/3052744/1693736

Installation and configuration of MySQL under Ubuntu