Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Slackware This Forum is for the discussion of Slackware Linux.


  Search this Thread
Old 12-07-2003, 11:44 PM   #1
Registered: Aug 2003
Location: KY
Distribution: Slackware 10/BSD
Posts: 32

Rep: Reputation: 15
Mysql problem, not running?

I am getting this error when trying to start

>root@slack:~# /etc/rc.d/rc.mysqld start
>root@slack:~# Starting mysqld daemon with databases from /var/lib/mysql
>031207 22:39:01 mysqld ended

if you notice it appears like there is a newline missing or something. But that doesn't seem like it would effect starting mysql and keep it running. Also after running this command I try to connect with myslq -u and I get this error.

>root@slack:~# mysql
>ERROR 2002: Can't connect to local MySQL server through socket >'/var/run/mysql/mysql.sock' (2)

I have mysql installed when I installed Slack and I have run the mysql_install_db command, so mysql has been installed correctly.

Any help would be great.


Daniel Allan
Old 12-08-2003, 02:52 AM   #2
Senior Member
Registered: May 2003
Location: Malaysia
Distribution: Slackware, LFS, CentOS
Posts: 1,307

Rep: Reputation: 46
Try this as root:
cat /var/lib/mysql/slack.err
Post anything error-like entries here.
Old 12-08-2003, 03:35 AM   #3
LQ Newbie
Registered: Dec 2003
Distribution: Slackware
Posts: 26

Rep: Reputation: 15
MySQL problem

Hello friend,

1. Check for username called "mysql". If there is not, create one and create group for this "mysql" user...

2. If there is username called "mysql", check your database directory. There are no database files directory in "/var/lib/mysql", check them where are. If you found them in another location, write this information to [mysql] section in your mysql.cnf file:

for example: if you found them in "/usr/local/mysql/data"

datadir = /usr/local/mysql/data

3. If there are database files in "/var/lib/mysql" folder, check the permissions of folder and files in that folder. And set owner to "mysql" set group to "mysql" and set mod to "775".

So MySQL will can access to your database file and it will run correctly...

Love from Turkey
Old 12-08-2003, 05:06 AM   #4
LQ Newbie
Registered: Sep 2003
Location: Hungary
Distribution: Slackware 9.1
Posts: 4

Rep: Reputation: 0

Try this:

su - mysql

/etc/rc.d/rc.mysql restart
Old 12-08-2003, 09:10 AM   #5
LQ Guru
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 250Reputation: 250Reputation: 250
Nope, you need to setup the permissions for mysql after installing the db:

chown -R mysql.mysql /var/lib/mysql

Then try running mysql.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL , is it running? is it there? Raggit Fedora 7 09-14-2005 03:02 PM
MySQL Install/Running Problem ScooterB Red Hat 3 03-09-2004 08:18 AM
does anyone have mysql running under Fedora? cpv204 Fedora 11 02-07-2004 02:29 PM
running mysql ?? shaahul Linux - Software 1 09-03-2003 03:45 AM
problem running mysql jumper Linux - Software 0 11-16-2001 11:00 AM > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 04:44 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration