`

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

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics