linux安装mysql通过yum安装

参考阿里云centos7安装mysql5.7_mysql 5.7 阿里安装源-优快云博客

如果已安装mysql或者安装没成功要删除：Linux下彻底卸载mysql详解 - nicknailo - 博客园

官方安装文档

http://dev.mysql.com/downloads/repo/yum/ 

https://www.51cto.com/article/716705.html

#1、把上面的rpm文件下载下来放到服务器上
#或者在linux系统中通过wget命令下载
wget http://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

#2、下载完成后使用yum命令本地安装yum源
yum localinstall mysql80-community-release-el7-1.noarch.rpm

#3、执行完毕后使用下面的命令检查是否安装成功
yum repolist enabled | grep "mysql.*-community.*"

#4、安装服务器
yum install -y mysql-community-server`


#启动MySQL服务
systemctl start mysqld

#查看服务启动状态
systemctl status mysqld

#开机启动
systemctl enable mysqld

#重新加载开机启动配置
systemctl daemon-reload



#查询默认密码
grep 'temporary password' /var/log/mysqld.log

#登录mysql,用刚才从文件中找到的密码
mysql -uroot -p

#尝试修改密码,使用下面的命令修改root用户的密码
CREATE USER root2@'%' IDENTIFIED BY 'AXB!@#$qwer1234';  -- 创建用户并指定密码
GRANT ALL PRIVILEGES ON *.* TO root2@'%' WITH GRANT OPTION;  --授权
FLUSH PRIVILEGES;

#如果插件问题
vi /etc/my.cnf
加上mysql_native_password=ON


#创建一个能全局访问的用户root
CREATE USER 'root'@'%' IDENTIFIED BY 你的密码'';

#给用户授权任何远程主机都可以访问数据库
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

#输入刷新命令使修改生效
FLUSH PRIVILEGES;




#找到default-authentication-plugin，将其注释取消
default-authentication-plugin=mysql_native_password

#重启服务，使其生效
systemctl restart mysqld


 

查看最新版本

1.下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
 

2.安装mysql源

yum localinstall mysql57-community-release-el7-11.noarch.rpm
 

3.查看是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

4.这个指令可以修改安装版本(一般不用改，默认安装你的5.7)

vim /etc/yum.repos.d/mysql-community.repo
 

5.安装mysql

yum install mysql-community-server
 

6.启动MySql

systemctl start mysqld
systemctl status mysqld
 

7.开机自启

systemctl enable mysqld
systemctl daemon-reload
 

8.修改root本地密码

查看初始密码：

grep 'temporary password' /var/log/mysqld.log
记住给你的初始密码，进去以后首先修改密码

进入mysql

mysql -uroot -p
然后输入初始密码登陆

修改密码（密码要有字母数字和下划线）：

mysql>set password for 'root'@'localhost'=password('你的密码');
或者

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';
注意如果你的密码简单，必须修改两个全局参数：

首先，修改validate_password_policy参数的值，这是在mysql里面设置的

mysql> set global validate_password_policy=0;
再修改密码的长度

mysql> set global validate_password_length=1;
再次执行修改密码就可以了

mysql>set password for 'root'@'localhost'=password('root1234');
或者

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root1234';
 

9.授权所有其他机器登陆

创建用户用来远程连接

GRANT ALL PRIVILEGES ON *.* TO 'itoffice'@'%' IDENTIFIED BY 'itoffice' WITH GRANT OPTION;

（第一个itoffice表示用户名，%表示所有的电脑都可以连接，也可以设置某个ip地址运行连接，第二个itoffice表示密码）。

如果提示弱密码看上面

10.配置默认编码为utf8

修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置，如下所示：

重启mysql

systemctl restart mysqld
在进入mysql后在产看是否修改成功

Mysql> show variables like '%character%';
修改前：

修改后：
 

11.配置文件：/etc/my.cnf 

日志文件：/var/log//var/log/mysqld.log 

服务启动脚本：/usr/lib/systemd/system/mysqld.service 

socket文件：/var/run/mysqld/mysqld.pid 

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_type= 1
query_cache_size= 512M

local-infile=0

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[root@arjenlee ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent

success

[root@arjenlee ~]# firewall-cmd --reload

--------------------- 
作者：unhejing 
来源：优快云 
原文：https://blog.youkuaiyun.com/unhejing/article/details/79893219 
版权声明：本文为博主原创文章，转载请附上博文链接！