Linux安装MySql 与远程连接错误代码1045

最新推荐文章于 2024-01-12 06:42:39 发布

〆清峰ㄟ

最新推荐文章于 2024-01-12 06:42:39 发布

阅读量930

点赞数 2

分类专栏： Linux MySql 文章标签：数据库 linux mysql centos

本文链接：https://blog.csdn.net/weixin_45019350/article/details/109717660

版权

Linux 同时被 2 个专栏收录

11 篇文章 2 订阅

订阅专栏

MySql

4 篇文章 0 订阅

订阅专栏

一、 CentOS在线安装Mysql5.7

//rpm包安装方式卸载
查包名：rpm -qa|grep -i mysql
删除命令：rpm -e –nodeps 包名
//yum安装方式下载
1.查看已安装的mysql
命令：rpm -qa | grep -i mysql
2.卸载mysql
命令：yum remove mysql-community-server-5.6.36-2.el7.x86_64
查看mysql的其它依赖：rpm -qa | grep -i mysql
删除原来安装过的mysql残留的数据（这一步非常重要）
rm -rf /var/lib/mysql

rm -rf /var/lib/mysql

一、通过Yum命令安装

1.下载rpm安装源

官方地址：https://dev.mysql.com/downloads/repo/yum/

rpm文件地址：

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

1）通过wget命令下载文件

[root@localhost ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
--2018-01-08 16:57:46--  https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
正在解析主机 dev.mysql.com (dev.mysql.com)... 137.254.60.11
正在连接 dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 302 Found
位置：https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm [跟随至新的 URL]
--2018-01-08 16:57:48--  https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
正在解析主机 repo.mysql.com (repo.mysql.com)... 23.1.165.122
正在连接 repo.mysql.com (repo.mysql.com)|23.1.165.122|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：25680 (25K) [application/x-redhat-package-manager]
正在保存至: “mysql57-community-release-el7-11.noarch.rpm”
 
100%[==================================================================================================================================================================================================>] 25,680      --.-K/s 用时 0.1s    
 
2018-01-08 16:57:48 (232 KB/s) - 已保存 “mysql57-community-release-el7-11.noarch.rpm” [25680/25680])
 
[root@localhost ~]#

2.安装Mysql

1）安装Mysql源文件

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

2）查看Mysql源是否安装成功

[root@localhost ~]# yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64        MySQL Connectors Community           42
mysql-tools-community/x86_64             MySQL Tools Community                55
mysql57-community/x86_64                 MySQL 5.7 Community Server          227
[root@localhost ~]#

3）安装Mysql服务

先执行：yum module disable mysql
再执行：yum -y install mysql-community-server

4）查看Mysql服务是否安装成功

[root@localhost ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
[root@localhost ~]#

5）修改mysql默认字符集

vi /etc/my.cnf

添加如下内容：

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

-- 在文件最下方添加

[client]
default-character-set=utf8

3.启动Mysql

 systemctl start mysqld

4.修改root登录密码

**查看临时密码**

grep 'temporary password' /var/log/mysqld.log

1）获取root默认密码root@localhost:后面的就是密码（由于Mysql安全策略升级，安装完成后系统自动设置了一个随机密码）

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2018-01-08T09:21:45.780623Z 1 [Note] A temporary password is generated for root@localhost: auw;Nj7J!j/J
[root@localhost ~]#

2）登录Mysql

[root@localhost ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.20
 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
 
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>

3）修改mysql登录密码
先设置一个复杂密码，以免不符合MySQL密码规范，会触发一个报错信息

alter user 'root'@'localhost' identified by 'L@2020';

//查看密码策略
SHOW VARIABLES LIKE 'validate_password%';

参考:
查看密码策略（更改设密方式） SHOW VARIABLES LIKE ‘validate_password%’; 注意显示的字段
配合下面的操作 validate_password.check_user_name | OFF | |
validate_password.dictionary_file | | |
validate_password.length | 4 | |
validate_password.mixed_case_count | 0 | |
validate_password.number_count | 0 | |
validate_password.policy | LOW | |
–
validate_password.special_char_count 把等级调低
set global validate_password.check_user_name = OFF;
set global validate_password.length = 4;
set global validate_password.mixed_case_count=0;
set global validate_password.number_coun=0;
set global validate_password.special_char_count=0;

关闭Mysql密码校验规则，允许设置简单密码

set global validate_password_policy=0;
    
set global validate_password_length=1;
//设置密码
set password=password('密码');

5.配置远程用户登录

mysql> grant all privileges on *.* to 'root'@'localhost' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)

//授权所有人访问
grant all privileges on *.* to 'root' @'%' identified by '123456';  
    
//刷新
flush privileges;

 #查看用户远程权限
mysql> use mysql;
mysql>select Host,User from user\G;

6、//刷新

flush privileges;

重启mysql服务

service mysqld restart

8、设置开机启动

systemctl enable mysqld

systemctl daemon-reload

关闭Linux系统防火墙

systemctl stop firewalld

在阿里云控制台设置防火墙规则

在这里插入图片描述

扩展：修改密码

mysql> alter user 'root'@'localhost' identified by '简单密码';
Query OK, 0 rows affected (0.00 sec)
mysql>

二、mysql远程连接错误代码1045

1、关闭防火墙
2、给mysql添加权限
解决方法：
在远程机上（192.168.30.14）进行设置
登录mysql客户端

use mysql;
执行命令（这是修改远程连接）下面也是的
alter user 'root'@'%' identified with mysql_native_password by '密码';

1、给mysql添加权限
这条语句适用于MySQL8.0之前的

grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option;

而MySQL8.0及之后的，设置远程连接权限要用下面的语句才可以

create user root@'%' identified by '123456';
grant all privileges on *.* to root@'%' with grant option;

root是mysql的root用户
password是mysql的root用户密码

‘%’代表任意IP都可以进行数据库的访问

2、刷新权限

Flush privileges;

3、重启mysql

service mysqld restart

安装参考：https://blog.csdn.net/cocoa_geforce/article/details/110081283
报错参考：
https://blog.csdn.net/qq_36850813/article/details/83717828
error1819：https://blog.csdn.net/calistom/article/details/87939956