Linux ubuntu mysql client

How To Install Only MySQL Client On CentOS/Redhat 6/7/8 or Ubuntu

Question :- I have MySQL database server running on CentOS and I would like to install only MySQL Client without installing MySQL server on the server. Do you have any idea how can I install only MySQL Client on CentOS and Linux based system.

Answer :- Yes, It is very easy to install only MySQL client Program and shared libraries on your Linux based system and no need to install the MySQL database server. Follow the below command to install it on Linux based system.

Client MySQL :- This package is a server/client implementation consisting of a MySQL client and many different client programs and libraries.

MySQL Server :- MySQL server is the most popular open source relational database management system (RDBMS). MySQL has become the leading database choice web-based applications, Used by high profile web properties including Facebook, Youtube, Twitter, Yahoo! and many more.

Install MySQL Client on CentOS/Redhat 6/7/8

You will need to root access privilege to install the below package. Now Open the terminal and login to the Linux system using SSH . Now follow the below command.

# yum install mysql Loaded plugins: downloadonly, fastestmirror, security Loading mirror speeds from cached hostfile * base: mirror.wiredtree.com * extras: mirrors.serveraxis.net * updates: bay.uchicago.edu Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql.x86_64 0:5.1.71-1.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: mysql x86_64 5.1.71-1.el6 base 893 k Transaction Summary ================================================================================ Install 1 Package(s) Total download size: 893 k Installed size: 2.4 M Is this ok [y/N]: y Downloading Packages: mysql-5.1.71-1.el6.x86_64.rpm | 893 kB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mysql-5.1.71-1.el6.x86_64 1/1 Verifying : mysql-5.1.71-1.el6.x86_64 1/1 Installed: mysql.x86_64 0:5.1.71-1.el6 Complete!

Install MySQL Client on Ubuntu and Debian

To install only Client on Ubuntu and Debian based system you will need to use apt-get command. Follow the below command to install Client on Ubuntu.

$ sudo apt-get install mysql-client OR Alternatively $ sudo apt-get install mysql*

Usage

Follow the basic syntax to access your database server using Client.

mysql -u USER-NAME -h MYSQL-DATABASE-SERVER-IP-ADDRESS -p DB-PASSWORD

# mysql -u look_user -h app1.looklinux.com -p look_password Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 170603 Server version: 5.6.27 MySQL Community Server (GPL) Copyright (c) 2000, 2016, 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>

Suggested Read

I hope this article will help to install only Client on your Linux system. If you have any queries and problem please comment in comment section.

Источник

Best MySQL Clients for Ubuntu

MySQL is very popular and one of the most widely used relational database management systems. Written in C and C++, it was developed and released by Oracle Corporation in mid 1995. Since then its popularity has only one direction i.e. northwards. Reason behind ever increasing popularity is that it is open-source and very easy to use, and integrates with various web apps and tools very easily. LAMP (Linux, Apache, MySQL, PHP) is very popular combination and a backbone of various popular applications.There are many MySQL GUI clients for Windows users but if you’re working on Ubuntu then in this article I’m going to introduce you to the 5 best MySQL clients that you can use on Ubuntu and other Linux distributions.

DataGrip

DataGrip is a multi-platform database administration tool developed and published by JetBrains which is popular for developing tools for software programmers and developers. It ships-in with various popular database management tools such as Amazon Redshift, Apache Hive, Azure SQL Database, Microsoft SQL Server and includes MySQL.

Talking about features, it sports very friendly user interface which you will find very easy to use, context-sensitive code compilation, automatic bug detection, and version control integration. Apart from that it has powerful text editor which is very smart and advance, light and dark themes, highly customizable interface and import/export support.

DataGrip has everything a database administrator needs, but there is one thing that might lure you to use other clients and i.e. it is not free and slightly on expensive side.

phpMyAdmin

phpMyAdmin is popular and one of the most widely used database administration tool for MySQL and MariaDB. It is free and open-source MySQL client popular for web hosting services. It has intuitive web interface which you will find very easy to use.

It is one of the best tools for MySQL you will find on internet, reason why I’m saying that is it supports all the features of MySQL such as create, copy, alter, rename, browse and drop databases, tables, etc. databases and tables maintenance, import/export from CSV and SQL, administer multiple servers, multiple formats for database layout graphics, and support for global search.

Considering all the aspects, phpMyAdmin is a reliable MySQL client for Ubuntu.

DBeaver

DBeaver is a free and cross-platform SQL client and database administration tool. It is developed by open-source community especially for developers, SQL programmers, database administrators, and analysts.

Apart from MySQL, it supports other widely used database management tools such as PostgreSQL, SQLite, Firebird, Oracle and many other. It comes with simple yet attractive user interface which is very easy to use.

Talking about the features, it offers connection to various data sources, visual query builder, metadata browser, ER diagrams, data and metadata search, and SQL editor.

It’s not like it has everything perfect because you may find errors in some functions on some occasions.

SQuirreL SQL

SQuirreL SQL is a cross-platform database administration tool which offers code editor that comes with code compilation and syntax highlighting for SQL.

It is feature-rich SQL client which offers features such as full-fledge plug-in support, simultaneous sessions with multiple databases, user defined code templates, etc. It is simple and lightweight tool which you will find very reliable and useful.

SQuirrel SQL can be downloaded and installed directly from Ubuntu Software Center.

Emma

Emma is a simple and lightweight database management tool especially developed for Linux and its distro’s such as Ubuntu. It is an ideal tool for beginners in the field of database programming and database administration.

Some of the notable features in emma are SQL editor, create and modify MySQL databases on the go, syntax highlighting support, export to CSV, and many other features.

To install emma on Ubuntu, run the following command in the Terminal or you can directly install it from Ubuntu Software Center.

dbforge Studio for MySQL

dbForge Studio for MySQL is a multi-purpose IDE that was specifically created for MySQL database managers, developers, and administrators. It boasts an intuitive graphical user interface that is well-suited both for those who are only at the beginning of their MySQL and MariaDB journey, as well as for seasoned veterans. Even though the tool was initially developed for Windows, it is now compatible with Linux and macOS.

The rich functionality of the Studio allows for creating and executing queries, developing and debugging T-SQL code, automating database object management, designing, comparing, and synchronizing databases, analyzing table data, and handling routine administration in a blink of an eye. dbForge Studio is a high performance tool and with tons of features you are looking for in a tool.

Conclusion

So these are the best MySQL clients that you can download and install on Ubuntu and other Linux distributions.

About the author

Swapnil Tirthakar

A Software Engineer who loves football and passionate about traveling. I often spend my free time playing with gadgets and exploring new possibilities in tech world. I am Linux enthusiast and have about 6 years of experience in web development. I have good command on Python, Java, SQL and system security.

Источник

Is there a way to only install the mysql client (Linux)? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Are there are any Linux mysql command line tools that don’t require the entire mysql db installation package to be installed? What I’m trying to do is from server #1 (app server), execute mysql commands that will get executed on server #2 (db server). I do not want to run the db on the local server or to install the full blown mysql db.

This is a totally valid question, the answers below are totally relevant, and they totally solve the problem that I had, even if they’re only from the perspective of one specific Linux distro (e.g. yum = RedHat / CentOS and apt = Debian / Ubuntu). So I have an edit to make the question more «Q-and-A-like» in the review queue that I would appreciate if someone could approve.

Recommendation questions are explicitly off-topic. This question is just spawning a stream of package recommendations.

This is a 10+ year old question, but still unedited and weak. A question needs to be much more specific. Foremost problem on this one: What distribution of Linux? ANY question asking «what do I do under Linux ..» should be edited. The answers you will get will tend to be equally as vague, hit & miss and will mention things that are distro specific such as YUM, APT, DNF, PKG along w/ various repo filenames. You can’t get a good, specific answer without a good question.

8 Answers 8

To install only mysql (client) you should execute

To install mysql client and mysql server:

yum install mysql mysql-server 

On a current Fedora system you should use yum install mariadb and yum install mariadb-server . Fedora replace MySQL with MariaDB.

This answer is incorrect. yum install mysql will install the server component as it will try to install mariadb : mariadb.x86_64 : A community developed branch of MySQL

You should consider using mariadb-client instead. See mariadb.com/kb/en/mariadb/yum for detail instructions. In short, you need to 1) Add mariadb repo for yum. 2) run yum install MariaDB-client. That’s it (assuming you are using RH or CentOS). For ubuntu, see answer from Jon Black.

sudo apt-get install default-mysql-client 

Is it only me getting E: Package ‘mysql-client’ has no installation candidate ? ( I run the update command first and still getting this )

[root@localhost administrador]# yum search mysql | grep client community-mysql.i686 : MySQL client programs and shared libraries : client community-mysql-libs.i686 : The shared libraries required for MySQL clients root-sql-mysql.i686 : MySQL client plugin for ROOT mariadb-libs.i686 : The shared libraries required for MariaDB/MySQL clients [root@localhost administrador]# yum install -y community-mysql 

Install MySQL Client: 1. sudo yum install -y dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm 2. sudo rpm —import repo.mysql.com/RPM-GPG-KEY-mysql-2022 3. sudo yum install -y mysql-community-client

If mysql-client is not available, you may use mariadb-client :

sudo apt-get install mariadb-client 

yum -y groupinstall "MYSQL Database Client" 

sudo apt-get install mysql-client-core-5.5 

there are two ways to install mysql client on centOS.

1. First method (download rpm package)

download rpm package from mysql website https://downloads.mysql.com/archives/community/

if you download this rpm package like picture, it’s filename like mysql-community-client-8.0.21-1.el8.x86_64.rpm.

then execute sudo rpm -ivh —nodeps —force mysql-community-client-8.0.21-1.el8.x86_64.rpm can install the rpm package the parameters -ivh means install, print output, don’t verify and check.

if raise error, maybe version conflict, you can execute rpm -pa | grep mysql to find conflicting package, then execute rpm -e —nodeps to remove them, and install once more.

finnaly, you can execute which mysql , it’s success if print /usr/bin/mysql.

2.Second method (Set repo of yum)

Please refer to this official website:

Источник