CentOS7 安装MySQL5.6
- 检查是否有MariaDB和MySQL,如果有则卸载掉
如果有,则需要用如下命令删除
[root@oracle local]# rpm -e --nodeps mariadb-server-5.5.60
- 下载mysql5.6二进制安装包
wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz
当然也可以离线下载好,然后再上传到对应的服务器中。我这里是用迅雷下载工具下载的,下载完成后,需要用FTP工具上传到指定的服务器中;
-
解压到/usr/local并改名,然后创建软链接
命令:
tar -zxvf mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz -C /usr/local
cd /usr/local/
mv mysql-5.6.42-linux-glibc2.12-x86_64/ mysql-5.6.42
ln -s /usr/local/mysql-5.6.42/ /usr/local/mysql -
创建用户组和用户名
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql -
修改配置文件
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
[root@oracle local]# cat /etc/my.cnf
[mysql]
default-character-set=utf8
[mysqld]
skip-name-resolve
port = 3306
server_id = 1
log_bin = mysql-bin
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /var/lib/mysql/mysql.sock
-
进入mysql目录初始化数据
chown mysql.mysql -R /usr/local/mysql
cd /usr/local/mysql/scripts/
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data -
配置环境变量
echo "export MYSQL_HOME=/usr/local/mysql/ " >> /etc/profile
echo "export PATH=$PATH:$MYSQL_HOME/bin " >> /etc/profile
source /etc/profile -
启动MySQL,并设置开机自启动
mkdir -p /var/lib/mysql
chown -R mysql.mysql /var/lib/mysql/
cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
/etc/init.d/mysqld start -
设置数据库登陆密码
mysqladmin -uroot password ‘123456’ -
设置远程登陆
mysql -uroot -p’123456’
mysql> grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
mysql> flush privileges;