mysql error
 

Hi,
I have Fedora Core 5 installed on my computer with dual OP Windows XP. Yesterday, I was trying to use MySQL, so I put mysql command on the terminal and it gives me the following error:

ERROR 2002 (HY000): Can't connect to local MySQL Server through Socket '/var/lib/mysql/mysql.sock' (2)

is somebody can help me to figure out?

$10 says you've not started the mysql service.

or
I recall either of those should work..basically they're the same. But if you want mysql to run every time you boot, you'll have to alter your runlevel config.

b0uncer : don't you mean service mysqld (with a 'd')?

I'm running FC5 and mysql isn't a recognised service.

(FYI).

same mysql error
 

I tried both,
and

unfortunately it didn't work and it gives me the same error. Do you mean instead of ? What is the difference between mysql and mysqld?

OK.

Try this : If this does not work, what error is it giving ?

Try : What do you get ?

Look for /usr/share/doc/packages/mysql/manual.pdf or /usr/share/doc/packages/mysql/manual.ps. There are a few things that you need to do after installing mysql to secure it. The manual also has trouble shooting information.

After starting the service you will want to use mysqladmin to give yourself the priviledges you need. Later, you will normally start mysql like:
mysql -u username -p
<password>

Good Luck.

jschiwal : I think parthava has not got the mysqld to start , so he won't be able to use the admin tools yet. Unless we've got past this point

I guess I was jumping ahead a bit. His syntax to start the MySQL monitor didn't look quite right.

He could try (for testing purposes) starting mysql with the command "sudo -u mysql /usr/bin/mysql_safe &"

And then run "mysqladmin -u root -p <rootpassword> status" to verify whether it started or not.
sudo /sbin/chkconfig -l mysql will list the runlevels that mysql should run under. He could use this command to automatically start the server when he boots the machine, assuming the service will start.

Hi The problem has been fixed. I went to /etc/rc.d/init.d/ and then as a root user, I gave the command and that's how I started the daemon. Thank you very much for all your help. I really appreciate it. Thanks to linux community.

no suprise there then... it's *always* that, as you would have seen had you scrolled to the bottom of the page to see all the identical threads.

i have found a web site for learning mysql, and want to share it with this cummunity web site address is
http://adminschoice.sytes.net