linux安装Mysql
一、下载
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
选择Linux - Generic
选择Linux - Generic(glibc 2.12)(x86.64-bit)
二、环境配置
rpm -qa | grep mysql
查看是否已有mysql
rpm -e mysql-libs //普通删除
rpm -e --nodeps mysql-libs //强力删除mysql
检查mariadb数据库是否存在,有则卸载
将mysql-5.7.30上传到linux中/opt/mysql目录
三、安装
cd /opt/mysql
tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
重命名
mv mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz mysql-5.7.30
添加系统mysql组合mysql用户
查看是否已存在
cat /etc/group | grep mysql
cat /etc/passwd | grep mysql
不存在,则执行
groupadd mysql
useradd -r -g mysql mysql
安装数据库
创建data目录
cd mysql-5.7.30
mkdir data
将/opt/mysql/mysql-5.7.30的所有者及所属组改为mysql
chown -R mysql.mysql /opt/mysql/mysql-5.7.30
在/opt/mysql/mysql-5.7.30/support-files目录下创建my_default.cnf
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
basedir = /opt/mysql/mysql-5.7.30
datadir = /opt/mysql/mysql-5.7.30/data
port = 3306
socket = /tmp/mysql.sock
character-set-server=utf8
log-error = /opt/mysql/mysql-5.7.30/data/mysqld.log
pid-file = /opt/mysql/mysql-5.7.30/data/mysqld.pid
拷贝,如果提示是否覆盖,y
cp support-files/my_default.cnf /etc/my.cnf
初始化 mysqld
cd /opt/mysql/mysql-5.7.25
./bin/mysqld --initialize --user=mysql --basedir=/opt/mysql/mysql-5.7.30/ --datadir=/opt/mysql/mysql-5.7.30/data/
查看日志
/opt/mysql/mysql-5.7.30/data/mysqld.log
里面包含密码
启动脚本放到开机初始化目录
cp support-files/mysql.server /etc/init.d/mysql
启动mysql
service mysql start
登录
cd /opt/mysql/mysql-5.7.30
./bin/mysql -u root -p
修改密码
set password=password(‘123456’);
grant all privileges on . to root@’%’ identified by ‘123456’;
flush privileges;
添加远程访问权限
use mysql;
update user set host=’%’ where user = ‘root’;
flush privileges;
重启mysql
service mysql stop
service mysql start
service mysql restart