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
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
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