1、下载软件
[root@localhost src]# wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
2、解压、移动
[root@localhost /]# yum -y install gcc gcc-c++ zlib-devel libtool ncurses-devel libxml2-devel cmake
[root@localhost /]# useradd -s /sbin/nologin -M mysql
[root@localhost /]# mkdir -p /usr/local/mysql
[root@localhost /]# mkdir -p /usr/local/mysql/data/mysql
[root@localhost /]# cd /usr/local/src/
[root@localhost src]# pwd
/usr/local/src
[root@localhost src]# ls
mysql-5.6.-linux-glibc2.-x86_64.tar.gz
[root@localhost src]# tar xf mysql-5.6.-linux-glibc2.-x86_64.tar.gz
[root@localhost src]# cd mysql-5.6.
3、编译、安装
[root@localhost mysql-5.6.]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data/mysql -DWITH_INNOBASE_STORAGE_ENGINE= -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
[root@localhost mysql-5.6.]# make
[root@localhost mysql-5.6.]# make install
[root@localhost mysql-5.6.]# echo $? [root@localhost mysql-5.6.]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.6.]# chmod +x /etc/init.d/mysqld
[root@localhost mysql-5.6.]# chown -R mysql:mysql /usr/local/mysql/data/mysql
[root@localhost mysql-5.6.]# chown -R mysql:mysql /usr/local/mysql/
4、初始化数据库
[root@localhost mysql-5.6.]# cd /usr/local/mysql/scripts/
[root@localhost scripts]# pwd
/usr/local/mysql/scripts
[root@localhost scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/mysql
[root@localhost scripts]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf'? y [root@liveneo- scripts]# vim /etc/my.cnf
# port = .....
# server_id = .....
# socket = ..... datadir = /usr/local/mysql/data/mysql
port =
server_id =
socket = /usr/local/mysql/mysql.sock # Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names =
wait_timeout=
log_bin_trust_function_creators=
max_connections=
5、配置环境变量
[root@localhost scripts]# vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
[root@localhost scripts]# source /etc/profile
[root@localhost scripts]# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!
[root@localhost scripts]# netstat -nlpt | grep mysql
tcp ::: :::* LISTEN /mysqld
[root@liveneo- mysql]# ls
bin COPYING data docs include lib man my.cnf mysql.sock mysql-test README scripts share sql-bench support-files
[root@localhost scripts]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6. Source distribution Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
rows in set (0.00 sec) mysql> exit
Bye
6、给root设置密码
[root@localhost scripts]# mysqladmin -uroot password ""
Warning: Using a password on the command line interface can be insecure.
[root@localhost scripts]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6. Source distribution Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
mysql>
mysql> exit
Bye
7、创建远程连接用户并授权
[root@localhost scripts]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6. Source distribution Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE USER 'user'@'%' IDENTIFIED BY '';
Query OK, rows affected (0.00 sec) mysql> GRANT ALL ON *.* TO 'user'@'%';
Query OK, rows affected (0.00 sec) mysql>