1、需要扩展安装
yum -y install make bison gcc-c++ cmake ncurses ncurses-devel
2、下载Mysql5.6.19
wget ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz
3、解压安装
tar zxvf mysql-5.6.19.tar.gz cd mysql-5.6.19 cmake -DCMAKE_INSTALL_PREFIX=/mysql/3306 -DMYSQL_DATADIR=/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
4、编译
make && make install
5、安装配置
cd /mysql/3306 chown -R mysql:mysql . cd /opt/mysql-5.6.19 cp support-files/my-default.cnf /etc/my.cnf cp support-files/mysql.server /etc/init.d/mysqld chmod 755 /etc/init.d/mysqld mkdir -p /mysql/data chown -R mysql:mysql /mysql/data /mysql/3306/scripts/mysql_install_db --user=mysql --basedir=/mysql/3306/ --datadir=/mysql/data/
6、启动
service mysqld start
7、测试
[root@mysql mysql-5.6.19]# /mysql/3306/bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.19 Source distribution Copyright (c) 2000, 2014, 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>
8、停止MYSQL
service mysqld stop
9、以安全模式启动MYSQL
/mysql/3306/bin/mysqld_safe --skip-grant-tables &
10、安全模式进入数据库
/mysql/3306/bin/mysql -u root -p
11、修改密码
>use mysql >update user set password=password("新密码") where user="root"; >flush privileges;
12、退出,重启