mySQL error

timmy · #1 2nd August 2005, 09:21 PM

HI. I'm using Fedora Core 4, and I did a "everything" installtion. I was following this tutorial:
http://stanton-finley.net/fedora_cor...notes.html#Web

But when I try to install mySQL, I get this error:

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

Any idea's why it's not installing?

Any help apreaciated(please keep in mind that i'm a newbie with Linux, so I may not understand some things that you tell me)

BrokenBrick · #2 3rd August 2005, 05:12 AM

Quote:

Originally Posted by timmy

HI. I'm using Fedora Core 4, and I did a "everything" installtion. I was following this tutorial:
http://stanton-finley.net/fedora_cor...notes.html#Web

But when I try to install mySQL, I get this error:

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

Any idea's why it's not installing?

Any help apreaciated(please keep in mind that i'm a newbie with Linux, so I may not understand some things that you tell me)

Did you try just using apt-get to install MySQL? This should do fine, as long as you don't already have MySQL

HACKERS PAL · #3 3rd August 2005, 05:54 AM

Try To Type

Code:

service mysqld start

in the terminal

Regards,

BrokenBrick · #4 3rd August 2005, 06:18 AM

I am having this problem as well. In your case I'd say you should use

Code:

yum install mysql

In my case, mysql.sock does not exist in my system, so I am going to have to post somewhere for help, or else attempt to compile mysql from source on top of my package install, which might be a bad idea, but it appears it might be my only option

incous · #5 3rd August 2005, 12:22 PM

Quote:

Originally Posted by BrokenBrick

I am having this problem as well. In your case I'd say you should use

Code:

yum install mysql

In my case, mysql.sock does not exist in my system, so I am going to have to post somewhere for help, or else attempt to compile mysql from source on top of my package install, which might be a bad idea, but it appears it might be my only option

it's not the problem. he try to run mysql on a pc without mysqld running.
to prevent this, let's install mysql-server first

timmy · #6 3rd August 2005, 01:45 PM

Quote:

Originally Posted by BrokenBrick

Did you try just using apt-get to install MySQL? This should do fine, as long as you don't already have MySQL

Sorry, but I don't know what your talking about ...

Quote:

Originally Posted by incous

it's not the problem. he try to run mysql on a pc without mysqld running.
to prevent this, let's install mysql-server first

I think I enabled mysqld by going to Desktop >System Settings > Server Settings > Services
and put putting a checkmark on mysqld.

DRE.ORGY.NET · #7 3rd August 2005, 03:17 PM

Last time I installed mysql the mysqld did not start due to the databases not being created correctly. you might need to run mysqld_install_db first. That should set up the initial mysql database and allow you to start mysqld (you can do this manually if by typing service mysqld start in a console as root)

timmy · #8 4th August 2005, 12:32 AM

Thanks guys, it works now

All of your comments helped me, thanks!

incous · #9 23rd April 2007, 11:59 AM

Quote:

Originally Posted by timmy

Sorry, but I don't know what your talking about ...

I think I enabled mysqld by going to Desktop >System Settings > Server Settings > Services
and put putting a checkmark on mysqld.

It's good when you have done. When you check this, it's just enable the firewall not to block MySQL port (3306). It's firewall setting.
You must install mysqld and initial the very first DBs follow instruction.

I see that Fedora is not good at packages management.
It's more easier if you use a Debian-based distro (ex. Ubuntu).

Mulciber · #10 23rd April 2007, 09:02 PM

I had this same problem took me the whole day...and still couldnt figure it out. Every time I tried to start mysql or restart in via command line it wouldnt work. I got the same error, but once I did it via the desktop it worked fine!

incous · #11 24th April 2007, 05:16 AM

you should check the mysql server is running or not by command
netstat -nat | grep LISTEN
and check if port 3306 is listening

Mulciber · #12 24th April 2007, 10:29 PM

the problem was that when I checked to see if it was working...I got the same error lol

swantucky · #13 25th April 2007, 05:06 PM

cd /usr/local/mysql/share/mysql
mysql.server start

This starts the mysql.server running and I can run mysql from shell and enter things, but when I try to access anything in the MySQL server from Webmin, I get the same mysql.socket errors. mysqld doesn't show up as a service either, so I can't start it from shell prompt. I can't locate mysld_install_db anywhere on my fc6 box; anyone know where I go with this?

Mulciber · #14 26th April 2007, 04:07 AM

Try going to the desktop and check your services, it should have something like mysqld...make sure that is checked out make sure you save it....