running mysql

prasan89na · 10-14-2014, 06:42 AM

Successfully installed XAMPP in my Slackware Linux. But when I try to run mysql it says:
bash-4.2$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

XAMPP says that mysql server is already running.

Keith Hedger · 10-15-2014, 03:58 PM

MySql is VERY particular about permissions and ownership after installing it on LFS I run these commands ( as root )

Code:

mysql_install_db --basedir=/usr --datadir=/srv/mysql --user=mysql
chown -R mysql:mysql /srv/mysql

install -v -m755 -o mysql -g mysql -d /run/mysqld
mysqld_safe --user=mysql 2>&1 >/dev/null &

mysqladmin -u root password

mysqladmin -p shutdown

On my system /var/run is symlinked to /run or /run is symlinked to /var/run whatever way you want to put it

astrogeek · 10-15-2014, 04:01 PM

Quote:

Originally Posted by prasan89na

Successfully installed XAMPP in my Slackware Linux. But when I try to run mysql it says:
bash-4.2$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

XAMPP says that mysql server is already running.

Just curious, why install XAMPP on Slackware? (You may have a reason I have not thought of)

Slackware already has everything natively in case you did not know that.

eklavya · 10-17-2014, 01:50 AM

If you want to open mysql command prompt like this

Code:

mysql>

Run the command

Code:

/opt/lampp/bin/mysql

Code:

bash-4.2$ sudo /opt/lampp/bin/mysql

zhjim · 10-17-2014, 02:43 AM

Might be that mysql server not listening on a socket or that it is in a different place. Thus first check if mysql is running

Quote:

ps aux | grep mysql

If its running check the existence of the socket file.

Quote:

ls /var/run/mysql

You might check on the config file of mysql. Might give a hint. (Not sure about the path)

Quote:

less /etc/my.cnf

Or you could run mysqld in debug mode and see what the server says when you try to connect