Installing MySQL on Linux Using Debian Packages from Oracle

1. allow all ip access db.

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '******';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

 2. Linux下mysql安装完后是默认：区分表名的大小写，不区分列名的大小写；

   用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加

bind-address            = 192.168.1.32
lower_case_table_names  = 1
character-set-server    = utf8
collation-server        = utf8_general_ci

 3.  sudo service mysql restart

 

Installing MySQL on Linux Using Debian Packages from Oracle

 

Install http://dev.mysql.com/doc/refman/5.6/en/linux-installation-debian.html

 

    1 . libaio1_0.3.109-4_amd64.deb

    2.  libc6_2.19-0ubuntu6_amd64.deb

    3.  libnuma1_2.0.9~rc5-1ubuntu2_amd64.deb

    4.  mysql-server_5.6.31-1ubuntu14.04_amd64.deb-bundle.tar

 

Librarys  : 

dpkg -i libaio1_0.3.109-4_amd64.deb
dpkg -i libc6_2.19-0ubuntu6_amd64.deb
dpkg -i libnuma1_2.0.9~rc5-1ubuntu2_amd64.deb

 

For a basic installation of the MySQL server, install the database common files package, the client package, the client metapackage, the server package, and the server metapackage (in that order);

shell> sudo tar -xvf mysql-server_MVER-DVER_CPU.deb-bundle.tar
shell> sudo dpkg -preconfigure mysql-community-server_*.deb
shell> sudo dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb

 

If you are being warned of unmet dependencies by dpkg, you can fix them using apt-get:

sudo apt-get -f install

 

    Here are where the files are installed on the system:

• All configuration files (like my.cnf) are under /etc/mysql

• All binaries, libraries, headers, etc., are under /usr/bin and /usr/sbin

• The data directory is under /var/lib/mysql