LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Fedora (https://www.linuxquestions.org/questions/fedora-35/)
-   -   mysql and fedora core 2 - problem (https://www.linuxquestions.org/questions/fedora-35/mysql-and-fedora-core-2-problem-236456/)

pcdebb 09-28-2004 10:29 PM

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 :(

meblost 09-28-2004 11:22 PM

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

pcdebb 09-28-2004 11:29 PM

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.

mjmwired 09-29-2004 07:02 PM

You may have already figured this out, but whenever I startup mysql in fedora, I use '/etc/init.d/mysqld start' (as root).

xtremcoder 10-01-2004 08:22 AM

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!

meblost 10-01-2004 08:31 AM

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.

meblost 10-01-2004 08:32 AM

pcdebb-
So you got it working?

pcdebb 10-01-2004 08:59 AM

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)

NoPane 10-01-2004 01:57 PM

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.


All times are GMT -5. The time now is 11:40 PM.