LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 12-07-2003, 10:44 PM   #1
Danielallan
Member
 
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 mysql....help.


>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.

Sincerely,

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

Rep: Reputation: 46
Try this as root:
Code:
cat /var/lib/mysql/slack.err
Post anything error-like entries here.
 
Old 12-08-2003, 02:35 AM   #3
OrphanedLand
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, 04:06 AM   #4
pitiless
LQ Newbie
 
Registered: Sep 2003
Location: Hungary
Distribution: Slackware 9.1
Posts: 4

Rep: Reputation: 0
Hello.

Try this:

su - mysql
mysql_install_db
exit

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

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

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

Then try running mysql.
 
  


Reply


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 02:02 PM
MySQL Install/Running Problem ScooterB Red Hat 3 03-09-2004 07:18 AM
does anyone have mysql running under Fedora? cpv204 Fedora 11 02-07-2004 01:29 PM
running mysql ?? shaahul Linux - Software 1 09-03-2003 02:45 AM
problem running mysql jumper Linux - Software 0 11-16-2001 10:00 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 05:55 PM.

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