TipsMake.com - In this article use the Linux operating system Ojuba 2 - 1 based on Fedora 10 framework framework, the user account here is root and suspend all operations of the MySQL database server :
If you want 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 application's source code points to the XAMPP client.
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
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:
But for applications in the system, the following method must be applied:
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.