一、下载:
https://dev.mysql.com/downloads/mysql/
或
https://downloads.mysql.com/archives/community/
或者:https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
二、安装:
1、解压
tar -zxvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
复制到mysql目录
cp -r mysql-5.7.32-linux-glibc2.12-x86_64 /usr/local/mysql
2、添加用户组和用户
groupadd mysql
useradd -g mysql mysql
3、安装
(1)、初始化
cd /usr/local/mysql/ ###切换路径
mkdir ./data ###创建数据文件夹
chown -R mysql:mysql ./ ###修改文件权限
bin/mysqld --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql --initialize ###安装并指定用户和data文件夹位置
#注意初始化命令执行后会生成一个临时root密码
cp share/english/errmsg.sys /usr/share/mysql/english/errmsg.sys ###如果上面命令报错,执行此操作替换文件
(2)、将MySQL服务添加到系统服务中
cp support-files/mysql.server /etc/init.d/mysqld ###复制mysql到服务自动启动里面
chmod 755 /etc/init.d/mysqld ###修改权限为755 也就是root可以执行
ln -fs /usr/local/mysql/bin/mysql /usr/local/bin/mysql ###把mysql安装目录,映射到/usr/local/bin目录下(这样可以在任何地方用mysql命令)
或者
vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin ###加入环境变量
source /etc/profile
(3)、修改配置文件
vim /etc/my.cnf ###修改配置文件
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysql/mysql.log
pid-file=/var/run/mysql/mysql.pid
[client]
socket=/var/lib/mysql/mysql.sock
(4)、创建不存在的目录,并赋权限
mkdir /var/lib/mysql #套接字目录
chown -R mysql:mysql /var/lib/mysql
mkdir /var/run/mysql # 进程文件存放目录
chown -R mysql:mysql /var/run/mysql
mkdir /var/log/mysql # 错误日志存放目录
chown -R mysql:mysql /var/log/mysql
4、启动并修改数据库权限
service mysqld start
mysql -uroot -p'sedgkK6kbw;;'
mysql> set password=password('123456'); ###修改密码
mysql> grant all privileges on *.* to root@'%' identified by '123456' with grant option; ###授权用户登陆
mysql> flush privileges; ###刷新权限表,让修改生效
PS: 设置MySQL服务为开机自启动
chkconfig mysqld on
chkconfig --list |grep mysqld
三、命令:
service mysqld start ###启动服务
service mysqld stop ###关闭mysql
service mysqld restart ###重新启动mysql
service mysqld status ###查看运行状态
其他:
show variables like 'binlog_format'; ###查看binlog_format
show grants for 'root'; ###查看root用户权限
select * from information_schema.innodb_trx; ###查看锁
以上!!!