通过远程连接Linux版的MySQL

本是古典何须时尚 2023-08-17 16:14 96阅读 0赞

**1、遇到无法连接，如图所示：**

** ![1496987-20190911001003378-1945275562.png][]**

**分析原因：**

**a、执行命令：show databases;**

**             use mysql;**

**![1496987-20190911001023755-777439129.png][]**

**b、接着把数据库的表显示出来：show tables;**

** ![1496987-20190911001049928-939507867.png][]**

**C、我们系统数据库**

**Mysql下的表，查询表user，如果，执行命令：select \* from user;**

**会出现乱码，如图所示：**

** ![1496987-20190911001110148-809207736.png][]**

**我们可以这样执行：select \* from user\\G; 如图所示：**

** ![1496987-20190911001218047-440951575.png][]**

**D、这时，我们需要插入一条语句：select host,user,password from user;**

**如果突然报错：ERROR 1054 (42S22): Unknown column 'password' in 'field list'**

**如图所示：**

** ![1496987-20190911001239545-1345785377.png][]**

**解决问题：**

**（1）查看mysql中表user的结构，直接describe user**

** ![1496987-20190911001259412-24433592.png][]**

![1496987-20190911001308520-1839220617.png][]

**password替换成authentication\_string**

** ****E、直接执行：select host,user,authentication\_string from user;**

** ![1496987-20190911001401713-174750715.png][]**

**F、执行权限命令：grant all privileges on \*.\* to root@'%' identified by 'root';**

** ![1496987-20190911001433593-332148899.png][]**

**g、再次查看权限信息，直接执行：select host,user,authentication\_string from user;**

** ![1496987-20190911001506211-2098136240.png][]**

**多了一个%号**

** ****我们在上图中，如果能看到%，就可以只用客户端连接的，**

**刚开始远程工具无法连接上，**

** ![1496987-20190911001528079-389007501.png][]**

**远程连接linux下的mysql Err1045 Err2003解决办法：**

**关闭防火墙：systemctl stop firewalld.service**

** ![1496987-20190911001545053-1989739955.png][]**

**再次使用远程工具连接，就可连接上！**

**![1496987-20190911001556732-1318671018.png][]**

**熬夜，整理完，问题解决！**

转载于:https://www.cnblogs.com/studygithub5208868/p/11503993.html

[1496987-20190911001003378-1945275562.png]: /images/20230810/ff161ed025724fefac7581323550cde7.png
[1496987-20190911001023755-777439129.png]: /images/20230810/d2b10771b563470aa8936be4c17fc38d.png
[1496987-20190911001049928-939507867.png]: /images/20230810/1a9ce1c16cd344688ff8d511951da26a.png
[1496987-20190911001110148-809207736.png]: /images/20230810/f2088c49f65a4ad49419f23aa0b5def9.png
[1496987-20190911001218047-440951575.png]: /images/20230810/c5b1d212ae81459cbb3846b1f8f32291.png
[1496987-20190911001239545-1345785377.png]: /images/20230810/532a45c7804943a2bd02cf80ea6264a4.png
[1496987-20190911001259412-24433592.png]: /images/20230810/df3bf8bc76574194b9f087b050b0749b.png
[1496987-20190911001308520-1839220617.png]: /images/20230810/2240867b72b2491e9952233ec612d431.png
[1496987-20190911001401713-174750715.png]: /images/20230810/d289ef0e9c15470aa185b12dd5a9fd5d.png
[1496987-20190911001433593-332148899.png]: /images/20230810/d5d6c783ba0548f5822375a3c58a1c14.png
[1496987-20190911001506211-2098136240.png]: /images/20230810/499edd75dfdf4e75a80ebb0607c585e3.png
[1496987-20190911001528079-389007501.png]: /images/20230810/23524ee6789f4c598e85ff8f083e7693.png
[1496987-20190911001545053-1989739955.png]: /images/20230810/2bc3b1a6bb52417d9271dfa0b0d6e283.png
[1496987-20190911001556732-1318671018.png]: /images/20230810/f8cd34d636e64c52a54f60d485fefe51.png