centos安装mysql客户端安装_Centos安装Mysql客户端-CSDN博客

本文链接：https://blog.csdn.net/weixin_39605521/article/details/113559936

本文详细介绍了如何在CentOS系统中判断是否已安装MySQL客户端，以及如何通过yum安装和验证MySQL客户端的过程，最后展示了成功连接并使用MySQL服务器的步骤。

摘要由CSDN通过智能技术生成

一、判断是否已安装MYSQL

which mysql

which mysqldump

输出如下内容表示未安装

[root@centos6 ~]# which mysql

/usr/bin/which: no mysql in (/usr/local/sbin:/usr/local/bin

:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

[root@centos6 ~]# which mysqldump

/usr/bin/which: no mysqldump in (/usr/local/sbin

:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

输入如下内容表示已安装

[root@centos6 ~]# which mysql

/usr/bin/mysql

[root@centos6 ~]# which mysqldump

/usr/bin/mysqldump

二、安装mysql客户端

yum install mysql

再次测试安装情况，步骤同(一、判断是否已安装MYSQL)

which mysql

which mysqldump

三、操作全过程

[root@centos6 ~]# which mysql

/usr/bin/which: no mysql in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

[root@centos6 ~]# which mysqldump

/usr/bin/which: no mysqldump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

[root@centos6 ~]# yum install mysql

已加载插件：fastestmirror

设置安装进程

Loading mirror speeds from cached hostfile

* webtatic: us-east.repo.webtatic.com

解决依赖关系

--> 执行事务检查

---> Package mysql.x86_64 0:5.1.73-8.el6_8 will be 安装

--> 完成依赖关系计算

依赖关系解决

==============================================================================================================================================

软件包架构版本仓库大小

==============================================================================================================================================

正在安装:

mysql x86_64 5.1.73-8.el6_8 base 895 k

事务概要

==============================================================================================================================================

Install 1 Package(s)

总下载量：895 k

Installed size: 2.4 M

确定吗？[y/N]：y

下载软件包：

mysql-5.1.73-8.el6_8.x86_64.rpm | 895 kB 00:00

运行 rpm_check_debug

执行事务测试

事务测试成功

执行事务

正在安装 : mysql-5.1.73-8.el6_8.x86_64 1/1

Verifying : mysql-5.1.73-8.el6_8.x86_64 1/1

已安装:

mysql.x86_64 0:5.1.73-8.el6_8

完毕！

[root@centos6 ~]# which mysql

/usr/bin/mysql

[root@centos6 ~]# which mysqldump

/usr/bin/mysqldump

[root@centos6 ~]# mysql -u root -p -h 127.0.0.1

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 17561945

Server version: 5.6.34 Source distribution

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> show databases

-> ;

+--------------------+

| Database |

+--------------------+

| information_schema |

| db_speaker_server |

| mysql |

| performance_schema |

+--------------------+

5 rows in set (0.00 sec)

mysql> exit;

Bye

[root@centos6 ~]#