Centos7在线安装mysql8(Linux安装mysql8)

约定不等于承诺〃 2024-03-29 14:48 85阅读 0赞

### 1：查询服务器信息，然后才能选择相应的安装方法 ###

> ### 1-1：cat /proc/version ###
> 
> ### 1-2：uname -a ###

### 2：安装rpm命令 ###

yum install rpm

### 3：安装前，检测系统是否自带安装mysql ###

rpm -qa |grep mysql

### 4：如果系统已经安装，那需要先卸载旧版本 ###

rpm -e mysql   //普通删除模式
    rpm -e --nodeps mysql //强力删除模式

### 5：线上使用yum命令下载mysql ###

wget http://repo.mysql.com/mysql80-community-release-el7-5.noarch.rpm
    rpm -ivh mysql80-community-release-el7-5.noarch.rpm

### 6：为了避免install安装mysql报错，在安装前添加 ###

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

### 7：为了兼容SQL语句group by问题， 在/etc/my.cnf的【mysqld】添加如下 ###

[mysqld]在尾部追加一行
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

### 8：在初始化之前，在/etc/my.cnf添加 lower\_case\_table\_names=1，忽略数据表名大小写 ###

[mysqld]在尾部追加一行
    lower_case_table_names=1

### 9：使用yum命令安装mysql ###

yum install mysql-server

### mysql权限设置： ###

sudo chown -R mysql.mysql /var/lib/mysql/

sudo chomod 777 -R /var/lib/mysql/

### 初始化mysql ###

mysqld --initialize

### 启动mysql ###

systemctl start mysqld  或者 service mysqld start

### 如果启动不了就再刷新一下 mysql权限设置： ###

sudo chown -R mysql.mysql /var/lib/mysql/

### 查看mysql运行状态 ###

systemctl status mysqld  或者 service mysqld status

### 设置mysql自启动 ###

systemctl enable mysqld

### 查看mysql安装是否成功和版本 ###

mysqladmin --version

### 查看root的临时密码： ###

[root@luxuzhglpt ~]# grep "A temporary password" /var/log/mysqld.log
    2023-01-06T10:19:15.489917Z 1 [Note] A temporary password is generated for root@localhost: r:f:7;x0wcV<

### 如果查看不了临时密码或者临死密码失效 ###

先在etc/my.cnf文件添加 skip\_grant\_tables;

[root@luxuzhglpt ~]# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 5430
    Server version: 8.0.31 MySQL Community Server - GPL
    
    Copyright (c) 2000, 2022, Oracle and/or its affiliates.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
    ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
    Query OK, 0 rows affected (0.01 sec)

### 更改临时密码，更改用户root密码为123456 ###

### 添加授权所以远程用户链接 ###

1：查看mysql数据库下的表user  
2：修改root用户的Host为&，并且拥有全部权限  
2：如果最终远程链接不上必须要注意看字段plugin信息修改为支持navicat链接