Binary installation MySQL-5.7.4 Database
MySQL 5.7.4 significantly improves query performance, which is doubled from MySQL 5.6. On the test platform, it can reach 512000 read-only QPS per second, while MySQL 5.6 can only reach 250000 QPS. This performance improvement is achieved through its Memcached plug-in. At the same time, this version has also been improved in other aspects of the database, such as reducing the time for establishing database connections, thanks to Facebook's contribution. For details, see
MySQL-5.5.38 universal binary Installation
Download and decompress mysql database
Wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.4-m14-linux-glibc2.5-x86_64.tar.gz
Tar-xvf mysql-5.7.4-m14-linux-glibc2.5-x86_64.tar.gz-C/usr/local/mysql-5.7.4
2. Create mysql users and modify software Permissions
Useradd-r-M-s/sbin/nologin mysql
Chown-R mysql/usr/local/mysql-5.7.4
Chgrp-R mysql/usr/local/mysql-5.7.4
3. Install and initialize the database
Cd/usr/local/mysql-5.7.4/
Scripts/mysql_install_db -- user = mysql -- basedir =/usr/local/mysql-5.7.4/-- datadir =/usr/local/mysql-5.7.4/data/-- mysql must be installed in the mysql root directory; otherwise an error occurs
Cp-a ../support-files/my-default.cnf/etc/my. cnf
Cp-a ../support-files/mysql. server/etc/init. d/mysqld
Cd bin/
./Mysqld_safe -- user = mysql &
Chkconfig -- add mysql
[Root @ db2 scripts] #/etc/init. d/mysqld restart
Shutting down MySQL... [OK]
Starting MySQL... [OK]
[Root @ db2 scripts] #
-------------------------------------- Split line --------------------------------------
Install MySQL in Ubuntu 14.04
MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF
Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL
Build a MySQL Master/Slave server in Ubuntu 14.04
Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS
Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04
MySQL-5.5.38 universal binary Installation
-------------------------------------- Split line --------------------------------------
This article permanently updates the link address: