<div>
You can use the 'msyql' command line program to get results from a different server and the results will show on the 'msyql' command line you are viewing. &nbsp;The 'msyql' command line program is part of the installation of the MySQL server. &nbsp;I do not know if it is available separately.<br />
<br />
Many other programs are available to do that including MySQL Workbench but all the ones I know of are GUI programs, not command line programs. &nbsp;phpMyAdmin can be set up to access remote MySQL server also if you have it running on ServerA's web server.
</div>


You can use the 'msyql' command line program to get results from a different server and the results will show on the 'msyql' command line you are viewing.  The 'msyql' command line program is part of the installation of the MySQL server.  I do not know if it is available separately.

Many other programs are available to do that including MySQL Workbench but all the ones I know of are GUI programs, not command line programs.  phpMyAdmin can be set up to access remote MySQL server also if you have it running on ServerA's web server.

<div>
To clarify, both servers need to install with mySQL first. And I can issue sql command on ServerB to get the result on Server A, ie<br />
<br />
Server B#mysql -uroot -p &nbsp;-h Server A<br />
<br />
Correct ?<br />
<br />
Is it possible to configure a mySQL proxy ?<br />
<br />
Tks
</div>


To clarify, both servers need to install with mySQL first. And I can issue sql command on ServerB to get the result on Server A, ie

Server B#mysql -uroot -p  -h Server A

Correct ?

Is it possible to configure a mySQL proxy ?

Tks

<div>
<div class="content wysiwyg-content">
If I configure MySQL on ServerA &amp;&nbsp;ServerB, on ServerB, can I issue a command on ServerA: mysql -uroot -p -hServerB in order to return the result to ServerA ?<br />
<br />
Is it possible for ServerA be a sql client such that I don't need to install the mysql on it ? Any configuration guide ? Tks
</div>
</div>


If I configure MySQL on ServerA & ServerB, on ServerB, can I issue a command on ServerA: mysql -uroot -p -hServerB in order to return the result to ServerA ?

Is it possible for ServerA be a sql client such that I don't need to install the mysql on it ? Any configuration guide ? Tks

MySQL Configuration

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).