Ubuntu Mysql Install By The MySQ

一、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.deb
shell> 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