1, first shut down the Linux firewall, execute the command
Chkconfig iptables off
2. Download your own MySQL version https://dev.mysql.com/downloads/mysql/5.6.html#downloads from MySQL official website, go to MySQL Web site, click
3. mysql file after download
Mysql-5.6.40-linux-glibc2.12-i686.tar.gz
Place the downloaded MySQL compressed file in the Linux/usr/local folder and unzip the compressed file
TAR-ZXVF mysql-5.6.40-linux-glibc2.12-i686.tar.gz
Rename the extracted file to MySQL
MV mysql-5.6.40-linux-glibc2.12-i686 MySQL
4. Create MySQL user group and user
Groupadd mysqluseradd-r-G MySQL MySQL
5. Go to MySQL directory and perform the operation of adding MySQL configuration
CP support-files/my-medium.cnf/etc/my.cnf OR: CP support-files/my-default.cnf/etc/my.cnf
Do you want to overwrite? Press Y to enter
6, edit/etc/my.cnf file;
Vi/etc/my.cnf
Add or modify the relevant configuration in the My.cnf file and save the exit after the change is complete
1 # for advice the change settings2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html3 # * * * Don't EDIT this FILE. It ' s a template which 'll be copied to the4 # * * * default location during install, and would be replaced if you5 # * * * * Upgrade to a newer version of MySQL.6 7 [Mysqld]8 9 # Remove Leading # and set to the amount of RAM for the most important dataTen # Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%. One # innodb_buffer_pool_size = 128M A - # Remove Leading # to turn on a very important data integrity Option:logging - # Changes to the binary log between backups. the # Log_bin - - # These is commonly set, remove the # and set as required. - Basedir =/usr/local/mysql + DataDir =/usr/local/mysql/data - Port = 3306 + # server_id = ... A socket =/tmp/mysql.sock at character-set-server = UTF8 - Skip-name-resolve - Log-err =/usr/local/mysql/data/error.log - pid-file =/usr/local/mysql/data/mysql.pid - - # Remove Leading # To set options mainly useful for reporting servers. in # The server defaults is faster for transactions and fast selects. - # Adjust sizes as needed, experiment to find the optimal values. to # join_buffer_size = 128M + # sort_buffer_size = 2M - # read_rnd_buffer_size = 2M the *Sql_mode=no_engine_substitution,strict_trans_tables
7, in the current directory of MySQL to set the Directory access permissions (note the following dot, indicating the current directory)
Chown-r MySQL. chgrp-r mysql. scripts/mysql_install_db--user=mysqlchown-r root. chown-r MySQL Data
8, initialize the data (in Mysql/bin or mysql/scripts under a mysql_install_db executable file initialization database), into the Mysql/bin or mysql/scripts directory, execute the following command
./mysql_install_db--verbose--user=root--defaults-file=/etc/my.cnf--datadir=/usr/local/mysql/data--basedir=/usr /local/mysql--pid-file=/usr/local/mysql/data/mysql.pid--tmpdir=/tmp
9, start MySQL, enter the/usr/local/mysql/bin directory, execute the following command
./mysqld_safe--defaults-file=/etc/my.cnf--socket=/tmp/mysql.sock--user=root &
10, set the boot start, new open shell interrupt, enter the MySQL directory, execute the following command
Cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysqldcp/usr/local/mysql/support-files/mysql.server/ Etc/rc.d/init.d/mysql
chmod 700/etc/init.d/mysqlchkconfig--add mysqldchkconfig--level 2345 mysqld onchown mysql:mysql-r/usr/local/mysql/
Restart Linux
Reboot
View MySQL Status
Service MYSQLD Status
11. Add Remote access Permissions
(1), add MySQL command
ln -s/usr/local/mysql/bin/mysql /usr/bin (mysql installation path)
(2), Change access rights
Log in to MySQL, execute the following command mysql-uroot-p password is empty direct carriage return, run the following two commands grant all privileges on * * to ' root ' @ '% ' identified by ' Duan ' with Grant O ption; Flush privileges;
Quit MySQL
Exit
Restart Linux and you're done.
Reboot
Note: The local access Mysql,root account default is no password, port number default 3306, if you need to modify the root account password, in the/usr/local/mysql/bin directory, execute the following command
./mysqladmin-h 127.0.0.1-p3306-uroot Password ' Duan ' exit
Linux system installation MySQL database