LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Password
Fedora This forum is for the discussion of the Fedora Project.

Notices


Reply
  Search this Thread
Old 09-28-2004, 11:29 PM   #1
pcdebb
Member
 
Registered: Aug 2003
Location: Brandon, FL
Distribution: Mageia 2
Posts: 81

Rep: Reputation: 15
mysql and fedora core 2 - problem


I recently installed fc2 on a spare machine. uses no monitor and I use putty from my windows machine to connect. if necessary i plug in the monitor to get updates or something. I can't seem to get mysql to run. There isnt much documentation to be found since fedora seems to install stuff in different areas. I've tried many commands.

mysql -u pcdebb -p
password: (i dont know what to enter, so i've tried nothing, or the pass i use to login)

get error: ERROR 2002: Can't connect oto local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

i find that mysql.sock doesnt exist there to begin with. I read on a forum somewhere that if you get this error then that means the daemon isn't running. I've tried various things to make that run but no go.

service mysqld start

gives error : -bash: service: command not found

I've tried a search on the forums here for answers before posting and didn't find anything that worked.

help
 
Old 09-29-2004, 12:22 AM   #2
meblost
Member
 
Registered: May 2004
Location: At Keyboard
Distribution: Mandrake 10.0, SuSE 9.0
Posts: 114

Rep: Reputation: 15
You should have a file called mysqld_safe that you can run as root. There may also be a file called mysql.server that you can put in /etc/init.d and link to from rc dirs to start mysql when your system boots. Try find / -name mysqld_safe -print
 
Old 09-29-2004, 12:29 AM   #3
pcdebb
Member
 
Registered: Aug 2003
Location: Brandon, FL
Distribution: Mageia 2
Posts: 81

Original Poster
Rep: Reputation: 15
actually i found that the service was not running. I had to physically goto the computer and start it and make it start on startup. i've started tinkering and created a table to practice with.
 
Old 09-29-2004, 08:02 PM   #4
mjmwired
Member
 
Registered: Apr 2004
Distribution: CentOS6, CentOS5, F16, F15, Ubuntu, OpenSuse
Posts: 620

Rep: Reputation: 39
You may have already figured this out, but whenever I startup mysql in fedora, I use '/etc/init.d/mysqld start' (as root).
 
Old 10-01-2004, 09:22 AM   #5
xtremcoder
LQ Newbie
 
Registered: Jun 2003
Posts: 14

Rep: Reputation: 0
Quote:
Originally posted by pcdebb
actually i found that the service was not running. I had to physically goto the computer and start it and make it start on startup. i've started tinkering and created a table to practice with.
Sorry to hijack your thread, but you are doing exactly what I want to do: administer my FC2 box through my Windows box. What exactly did you do to accomplish this? I am completely new to linux and am 100% lost! Thanks for the help!
 
Old 10-01-2004, 09:31 AM   #6
meblost
Member
 
Registered: May 2004
Location: At Keyboard
Distribution: Mandrake 10.0, SuSE 9.0
Posts: 114

Rep: Reputation: 15
Check out PuTTY, a telnet and ssh client for windows. This site also contains some other useful programs that will make it easier to do what you want to do.
 
Old 10-01-2004, 09:32 AM   #7
meblost
Member
 
Registered: May 2004
Location: At Keyboard
Distribution: Mandrake 10.0, SuSE 9.0
Posts: 114

Rep: Reputation: 15
pcdebb-
So you got it working?
 
Old 10-01-2004, 09:59 AM   #8
pcdebb
Member
 
Registered: Aug 2003
Location: Brandon, FL
Distribution: Mageia 2
Posts: 81

Original Poster
Rep: Reputation: 15
Quote:
Originally posted by meblost
pcdebb-
So you got it working?
Yes, so far it seems to be working. php and mysql works. (I'm sorry, I thought I responded, but I see I didn't)
 
Old 10-01-2004, 02:57 PM   #9
NoPane
LQ Newbie
 
Registered: Nov 2003
Location: Hitchin, Herts, UK
Distribution: SuSE 9
Posts: 5

Rep: Reputation: 0
May I suggest that you install Webmin on your FC2 box - it makes all sorts of tasks very easy for the newcomer - and the support for MySQL is great. I use it for administering the server and also tweaking data and backing up databases. It also provides an easy way of starting and stopping services at boot time.

As far as administering your box from Windows, track down WinSCP3 which makes copying files really easy. Also, if you've got X running, then TightVNC is worth the effort.
 
  


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 in fedora core 2 jkmartha Linux - Software 1 05-02-2005 04:00 PM
MySQL 5.0.3 - Fedora Core 3 Ryand833 Linux - Software 2 03-30-2005 08:34 AM
Fedora Core 3, MySql Server, mysql started mysql ended OkiTek Fedora 30 01-28-2005 10:15 AM
MySQL in Fedora Core 2 hokagi_ninja Linux - Newbie 8 11-10-2004 10:51 PM
MySQL in Fedora Core 2 hokagi_ninja Linux - Newbie 1 10-26-2004 07:56 AM

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

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

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