mysql apt repository_Ubuntu Mysql Install By The MySQL Apt Repository

一、Adding the MySQL APT Repository

1、Go to the download page for the MySQL APT repository           at http://dev.mysql.com/downloads/repo/apt/.

2、Select and download the release package for your Linux distribution.

3、Install the downloaded release package with the following command, replacing version-specific-package-namewith the name of the downloaded package (preceded by its path, if you are not running the command inside the folder where the package is):

shell> sudo dpkg -i mysql-apt-config_w.x.y-z_all.debshell> sudo apt-get update.x.y-z_all.deb

4、Update package information from the MySQL APT repository with the following command (this step is mandatory):

shell> sudo apt-get update

二、Installing MySQL with APT

shell> sudo apt-get install mysql-server

三、Starting and Stopping the MySQL Server

shell> sudo service mysql status

shell> sudo service mysql stop

shell> sudo service mysql start

四、Remote Connect Mysql

1、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT 2、OPTION; FLUSH PRIVILEGES;

3、modify mysql configure file

Change line

bind-address = 127.0.0.1

to

#bind-address = 127.0.0.1

4、restart mysql server