centos安装mysql5.6.23(源码安装)
下载
1.下载依赖(这一步很必要,编译安装过程需要这些依赖)
yum install -y gcc gcc-c++ cmake ncurses-devel bison Perl
2.下载安装包(windows)
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz
3.下载安装包(linux)
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz
安装
1. 创建用户和组,以及mysql存放目录,以及授权
1.groupadd mysql
2.useradd mysql -g mysql
3.mkdir -p /data/mysql
4.mkdir -p /data/mysqllog
5.chown -R mysql:mysql /data/mysql*
2.编译安装mysql-5.6.23
1.上传到linux安装目录下并解压
tar zxf mysql-5.6.23.tar.gz
2.解压后进入到目录、
cd mysql-5.6.23
3.编译
cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql -DMYSQL_DATADIR=/data/mysql-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_SSL=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_DEBUG=0
4.安装
make && make install
5.初始化数据库表
/opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql
–datadir=/data/mysql/
7.启动mysql
cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
8.如果启动之后登陆不上,关闭防火墙
systemctl stop firewalld.service
9.登陆数据库修改密码
1.添加环境变量
echo ‘export PATH=$PATH:/opt/mysql/bin’ >> /etc/profile
2.授权刷新
source /etc/profile //加载/etc/profile,让其生效
3.登陆数据库更改密码
[root@test ~]# mysql //直接登录,
(root@localhost)[(none)]> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’
identified by ‘密码’ WITH GRANT OPTION; //密码是你配置的mysql的root用户密码。
(root@localhost)[(none)]>flush privileges; //配置生效
(root@localhost)[(none)]>update mysql.user set password=password(‘密码’)
where user=‘root’; //将所有root密码改成密码 ,包括本地登录的
(root@localhost)[(none)]>flush privileges
(root@localhost)[(none)]>\q //退出
4.重启并重新登陆
/etc/init.d/mysqld restart
最后希望大家多多点赞支持!!!!