CentOS7.4安装MYSQL5.6

最新推荐文章于 2021-05-11 10:16:10 发布

alert('这个男人好帅')

最新推荐文章于 2021-05-11 10:16:10 发布

阅读量107

点赞数

分类专栏： mysql 文章标签： mysql linux centos 数据库

本文链接：https://blog.csdn.net/m0_37244234/article/details/105385808

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

CentOS7.4安装MYSQL5.6

- 安装需要的插件
- 关闭selinux

安装需要的插件

yum -y install wget -y  cmake make gcc gcc-c++ kernel-devel m4  ncurses-devel openssl-devel bison* ncurses* build-essential 'perl(Data::Dumper)' socat epel-release

关闭selinux

vi /etc/sysconfig/selinux

在这里插入图片描述

新增用户组

groupadd mysql

新增用户

useradd mysql -g mysql

mkdir -p /usr/local/mysql/db/data

cmake安装mysql(注：时间会有点长，请耐心等待)

cd /tiger/install_package/
tar –zxvf mysql-5.6.14.tar.gz
cd mysql-5.6.14

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=/usr/local/mysql/db/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306

make
make install

chown -R mysql:mysql /usr/local/mysql
mv /etc/my.cnf /etc/my.cnf.bak

执行初始化配置脚本，创建系统自带的数据库和表。

cd /usr/local/mysql
yum install 'perl(Data::Dumper)'
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/db/data/

复制服务启动脚本

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

配置环境变量

vi /etc/profile
export MYSQL_HOME=/usr/local/mysql
export PATH=${APACHE_HOME}/bin:${SUBVERSION_HOME}/bin:${MYSQL_HOME}/bin:$PATH
source /etc/profile

启动MySQL服务

service mysql start
Starting MySQL.. SUCCESS!

设置开机自动启动服务

chkconfig mysql on

修改MySQL用户root的密码

 mysql -u root
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456" WITH GRANT OPTION;
mysql>update user set Password = password('123456') where User='root';
mysql>flush privileges;
mysql>exit;