CentOS安装MySQL

最新推荐文章于 2024-06-29 22:12:22 发布

原创最新推荐文章于 2024-06-29 22:12:22 发布 · 1.1w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #centos

Java 专栏收录该内容

15 篇文章

订阅专栏

本文介绍如何下载并安装MySQL的repo源，通过命令行安装MySQL服务器，并进行基本的配置与密码重置。此外还包含了设置密码策略及更新root用户密码的方法。

下载mysql的repo源

wget https://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpm

安装mysql57-community-release-el7-11.noarch.rpm包

sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
安装这个包后，会获得两个mysql的yum repo源：
    /etc/yum.repos.d/mysql-community.repo，
    /etc/yum.repos.d/mysql-community-source.repo。

安装mysql

sudo yum install mysql-server

重置mysql密码

重新初始化mysql数据库用的表
mysqld --initialize --user=mysql 
sudo chown -R root:root /var/lib/mysql
mysql -u root -p
这行中会有密码
grep 'temporary password' /var/log/mysqld.log
设置密码的验证策略和验证长度
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER USER() IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
[mysqld]
port=3306
# innodb_buffer_pool_size = 128M
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
update user set authentication_string = password('admin') where user = 'root';