centos7 安装mysql 没有多余的步骤

qq_37084490

已于 2023-01-26 15:17:34 修改

阅读量188

点赞数

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

于 2023-01-25 16:33:33 首次发布

本文链接：https://blog.csdn.net/qq_37084490/article/details/128761267

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

查找是否存在mysql

rpm -qa | grep mysql
yum -y remove mysql...

安装依赖

yum install -y libaio

添加用户组

groupadd mysql
useradd mysql -g mysql
#下载mysql
https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.40-el7-x86_64.tar.gz
#解压 && 改名称
tar -xvf mysql-5.7.40-el7-x86_64.tar.gz
mv mysql-5.7.40-el7-x86_64 mysql
#创建数据库文件夹
mkdir mysql/data
#授权
chown -R mysql:mysql mysql
chmod -R 755 mysql
#进入mysql目录安装
cd mysql

./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize 

# 初始密码为随机的 s;f?<ozXy30?

准备 /etc/my.cnf, 我安装在 /usr/local/mysql

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
max_connections = 2500
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data 
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
long_query_time=2
slow_query_log=ON
slow_query_log_file=/usr/local/mysql/data/slow.log
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=4
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=1
log-bin=/usr/local/mysql/data/mysql-bin
max_binlog_size=512M 
expire_logs_days=3
server-id=2
gtid-mode=on
enforce-gtid-consistency=on
binlog_format=mixed
explicit_defaults_for_timestamp
wait_timeout=864000
interactive_timeout=864000
innodb_io_capacity=20000
table_open_cache=800


[mysql]
default-character-set=utf8

启动，修改密码和支持远程连接


#启动mysq
./support-files/mysql.server start

ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
#重启服务mysql
service mysql restart 
#做个软链接，将安装目录下的mysql 放在/usr/bin 目录下
ln -s /usr/local/mysql/bin/mysql /usr/bin 
#登录
mysql -uroot -p
#设置root的密码为123456
alter user 'root'@'localhost' identified by '123456'; 
use mysql;
update user set user.Host='%' where user.User='root';

flush privileges;

### 或者这个命令更新密码
UPDATE user SET authentication_string = password ('123456') WHERE User = 'root';