Access Applications Directly to XAMPP Mysql Server

/etc/init. d/mysqld stop

How Access Applications Directly to XAMPP Mysql Server Works

When needed to use the full function of the LAMP server with just one step, XAMPP is a great solution, but you will not be able to access the MySQL database server using mysql client as usual (/ usr / bin / mysql), but instead, you must use the bundled client application (/ opt / lampp / bin / mysql).

And here are some problems that users often encounter, they have several databases, code snippets and other applications that need access to this database with the mysql client function (/ usr / bin / mysql) is the default mode, but there is no option to change all of the app's source code points to the XAMPP client.

First solution:

Move mysql client entry (/ usr / bin / mysql):

Mv / usr / bin / mysql /usr/bin/mysql. original

Then create a dynamic link to the XAMPP client (/ opt / lampp / bin / mysql) in the same position as follows:

Ln -s / opt / lampp / bin / mysql / usr / bin / mysql

Second solution:

In this method, we will work directly with the sock file, which is responsible for pointing activities directly to the database server. XAMPP regularly saves sock files in the following location:

/opt/lampp/var/mysql/mysql. sock

But for applications in the system, the following method must be applied:

/var/run/mysqld/mysqld. sock

In order for all programs to use the XAMPP database server, we must specify these programs to point to the XAMPP file, or simply, create a link to the XAMPP file in a separate address. Therefore, every program that wants to access the database server must point to the XAMPP server. Use the following command:

Ln -s /opt/lampp/var/mysql/mysql. sock /var/mysql/mysql. sock

After executing this step, the applications are now able to operate, directly accessing the normal database without any hindrance.