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
相关推荐
2.5.1. Installing MySQL from RPM Packages on Linux 2.5.2. Installing MySQL on Linux using Native Package Manager 2.6. Installing MySQL on Solaris and OpenSolaris 2.6.1. Installing MySQL on Solaris ...
Installing Oracle Database 11g on Linux
Installing Oracle 10G On Linux
Oracle Database 11g Release 2 (11.2.0.3) RAC On Oracle Linux 6.3 Using VirtualBox This article describes the installation of Oracle Database 11g release 2 (11.2.0.3 64-bit) RAC on Linux (Oracle Linux ...
Installing Oracle RAC 10g Release 2 on Linux x86(中)
installing oracle9i on redhat linux.rar 分布讲述在redhat上安装oracle9i的全过程和注意事项!
Installing STLinux on Ubuntu
Step By Step guide for installing Oracle RAC 11gR2 on Linux
Oracle administration guide + Concepts Oracle + Installing Oracle Database 10 g on Sun Solaris 10 by Using RC
oracle完整安装文档,for linux
Contents ?MySQL C++ Driver Based on JDBC 4.0 Specification ?Installing MySQL Connector/C++ ?Runtime Dependencies ?IDE for Developing C++ ...Appendix I: Installing MySQL Connector/C++ from Source
installing+Oracle+RAC+10g+Release+2+on+Linux+x86
Requirements For Installing Oracle10gR2 On RHEL 5&OEL 5 (x86_64)
\Installing RAC on AIX 001.pdf
Installing RAC on AIX
installing oracle on rhel 5 linux
Installing MIUI on Meizu MX2
2 Installing Qt SDK on X86 Linux 3 Installing Qt Everywhere on a Linux host 3.1 Install and build tslib 3.2 Install Qt Everywhere on a Linux Host 3.3 Install Qt Everywhere 4.6.3 fonts and ...
Chapter 2: Preparing to Install Linux Chapter 3: Installing Linux Chapter 4: Issuing Linux Commands Chapter 5: Installing and Configuring the X Window System Chapter 6: Using the ...
Upgrading from Heartbeat 2.1 clusters not using the CRM 6.1.1. Stopping Heartbeat services 6.1.2. Upgrade software 6.1.3. Enabling the Heartbeat cluster to use Pacemaker 6.1.4. Restarting ...