Environment: CentOS 6.3 Minimizes the default installation and configures the network card.
Before installing MySQL, make sure that your Internet connection is normal so that you can download the installation files.
Use the YUM-Y Update directive to upgrade the system to the latest version first.
This installation separates the MySQL data file from the execution file, and if you intend to set it to a different path, pay attention to modifying the corresponding execution command and database initialization script.
# Modify firewall settings, open port 3306
Vi/etc/sysconfig/iptables
-A input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT
# Reboot the firewall for new settings to take effect
Service Iptables Restart
# New User Groups
Groupadd MySQL
# New users
Useradd mysql-g MySQL
# New Database Execution file directory
Mkdir-p/usr/local/mysql
# New Database Data file directory
Mkdir-p/db/mysql/data
# Modify Directory Owner
Chown-r Mysql:mysql/usr/local/mysql
Chown-r Mysql:mysql/db/mysql/data
Chown-r mysql:mysql/usr/local/mysql/.
Chown-r mysql:mysql/db/mysql/data/.
# Edit Path Search Path
Vi/etc/profile
Append 2 lines to the end of the file:
Path=/usr/local/mysql/bin:/usr/local/mysql/lib: $PATH
Export PATH
# Effective Path Search Path
Source/etc/profile
# Edit Hosts file, add native IP and host name
192.168.211.100 Centhost.centdomain
# Install the tools and libraries needed to compile the source code
Yum-y install wget gcc-c++ ncurses-devel cmake make Perl
# Access to source compression package download directory
Cd/usr/src
# Download Source Compression Package
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz/from/http://cdn.mysql.com/
# Unzip the source package
Tar-zxv-f mysql-5.6.10.tar.gz
# into the Extract source directory
CD mysql-5.6.10
# from the mysql5.5, MySQL source installation began to use CMake, the implementation of the source code compiled configuration script.
CMake
-dcmake_install_prefix=/usr/local/mysql
-dmysql_unix_addr=/usr/local/mysql/mysql.sock
-ddefault_charset=utf8
-ddefault_collation=utf8_general_ci
-dwith_myisam_storage_engine=1
-dwith_innobase_storage_engine=1
-dwith_archive_storage_engine=1
-dwith_blackhole_storage_engine=1
-dwith_memory_storage_engine=1
-dwith_readline=1
-denabled_local_infile=1
-dmysql_datadir=/db/mysql/data
-dmysql_user=mysql
-dmysql_tcp_port=3306
# Compile the source code, this step time will be longer, patiently waiting.
Make
# installation
Make install
# Copy configuration file
Cp/usr/local/mysql/support-files/my-default.cnf/etc/my.cnf
# Enter Installation path
Cd/usr/local/mysql
# Execute configuration Script
scripts/mysql_install_db--user=mysql--datadir=/db/mysql/data
# Replication Service startup script
Cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysql
# Start MySQL Service
Service MySQL Start
# set up the boot auto start service
Chkconfig MySQL on
>>>>>>>>>>>>>>> Complete
Modify the password of the MySQL root user and turn on remote connections
mysql> use MySQL;
mysql> desc User;
Mysql> GRANT all privileges in *.* to root@ "%" identified by "root"; The ability to add remote connections to root
mysql> Update user Set Password = Password (' 123456 ') where user= ' root '; Set Root user password
Mysql> Select Host,user,password from User where user= ' root ';
mysql> flush Privileges;
Mysql> exit