wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
rpm -qa | grep mysql
如果安装则卸载:
rpm -e 已经存在的MySQL全名
解压到/usr/local:
sudo tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
修改文件夹名称:
sudo mv mysql-5.7.17-linux-glibc2.5-x86_64/ mysql
进入/etc目录,备份原有my.cnf
sudo cp my.cnf my.cnf.bak
复制mysql/support-files/目录下的my-default.cnf文件,替换原有的my.cnf。
sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
执行:
sudo vim my.cnf
修改,my.cnf文件的以下配置。
[mysql]
default-character-set=utf8
[mysqld]
default-storage-engine=INNODB
character_set_server=utf8
# 忽略大小写
lower_case_table_names=1
basedir = /usr/local/mysql
datadir = /mnt/mysql/data
port = 3306
[mysqld_safe]
log-error=/mnt/mysql/logs/mysql.log
复制/support-files/目录下的mysql.server到/etc/init.d/目录下。
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
创建mysql组:
sudo groupadd mysql
创建mysql用户,并把用户放到mysql组:
sudo useradd -r -g mysql -s /bin/false mysql
-r和-s /bin/fase确保mysql用户不可登录。
sudo chown -R mysql:mysql /usr/local/mysql/
sudo chown -R mysql:mysql /mnt/mysql/
安装和初始化数据库:
cd /usr/local/mysql/bin/
sudo ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mnt/mysql/data
如果执行初始化命令报以下错误:
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
则检查该链接库文件有没有安装使用,命令进行核查。
rpm -qa|grep libaio
如果未安装,则执行以下命令安装:
sudo yum install libaio-devel.x86_64
重新执行以上初始化命令,获得临时密码:
root@localhost: SOA8W%kihjEC
给数据库加密:
sudo ./mysql_ssl_rsa_setup --datadir=/mnt/mysql/data
启动mysql:
sudo ./mysqld_safe --user=mysql &
检查是否启动成功:
ps -ef|grep mysql
进入/usr/local/mysql/bin目录下,执行并输入密码:
./mysql -uroot -p
设置新密码:
set password=password('新密码');
设置mysql的远程访问:
grant all privileges on *.* to root@'%' identified by 'root';
flush privileges;
添加服务mysql
sudo chkconfig --add mysql
设置mysql服务为自启动
sudo chkconfig mysql on
sudo vim /etc/profile
最后一行添加:
export PATH=$JAVA_HOME/bin:/usr/local/mysql/bin:$PATH
使修改生效:
source /etc/profile