How to make mistakes with Mysql and live in peace! :)
1- If you access mysql from the terminal and the error refers to the lack of a directory, then you may have to install mysql-server, like this:
sudo apt-get install mysql-server
2- if you try to enter mysql by phpmyadmin and give the following error: phpmyadmin ERROR - #2002, or something of the kind, it may be that you have two mysql installed and running at the same time, which generates conflicts. To solve this just quit mysql and leave only the xampp running, like this:
cd /etc/init. d
# . /mysql stop
# . /apache stop
-After that, just startar the mysql inside the lampp, like this:
-within the /opt folder:
opt/lampp/lampp start , or , sudo opt/lampp/lampp
-or inside the lampp folder as follows:
sudo . /lampp start
3- if you see an error like: Existing Configuration file (config.inc.php) is not readable... , means that you have given a permission to change the file or run, and this file is read only, and mysql does not start if you do not change the permission, so just type:
-search the file, in my case it looked like this:
cd opt/lampp/phpmyadmin/
-within the /phpmyadmin directory, you have the config.inc.php file, so inside the directory, type:
sudo chmod 700 config.inc.php
-This way the file can be executed by mysql without any interruption.
What operating system xaampp is installed on?
– abfurlan
Ubuntu ().
– user3677610