error connecting to mysql

i was trying to setup an application checked out from svnin my local
machine. i managed to do all that is required except when it came to
the step of creating databases for the application, when i tried to
connect to mysql i got this error

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

i have spent more than 5 hours trying to solve this without any success.

your help please

thanks

i was trying to setup an application checked out from svnin my local
machine. i managed to do all that is required except when it came to
the step of creating databases for the application, when i tried to
connect to mysql i got this error

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

i have spent more than 5 hours trying to solve this without any success.

your help please

Craig White wrote:

your help please

----
remembering that you're running Fedora...

is mysqld service running?

service mysqld status

hi craig,

this is what i got after service mysqld status

[root@localhost /]# service mysqld status
mysqld dead but subsys locked

and mysql -U $USER_IN_DATABSE.YML -p gives

[root@localhost /]# mysql -U -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[root@localhost /]#

what should i do please?

thanks

Craig White wrote:
>> your help please
> ----
> remembering that you're running Fedora...
>
> is mysqld service running?
>
> service mysqld status

>
> hi craig,

this is what i got after service mysqld status

[root@localhost /]# service mysqld status
mysqld dead but subsys locked

Craig White wrote:

[

try 'service mysqld restart'

and see if it stays started and if you then can connect as below
----

it does not want to stay started it timed out as soon as i started the
service

this is what i got after service mysqld restart

[root@localhost /]# service mysqld restart
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost /]#

Craig White wrote:
>>
>>
>> [
> try 'service mysqld restart'
>
> and see if it stays started and if you then can connect as below
> ----

it does not want to stay started it timed out as soon as i started the
service

this is what i got after service mysqld restart

[root@localhost /]# service mysqld restart
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost /]#

sorry for this but am not that good in linux, that's why am asking a
lot of questions.

/var/log/mysqld.log

080903 16:20:18 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080903 16:20:18 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080903 16:20:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080903 16:20:20 InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080903 16:20:24 InnoDB: Started; log sequence number 0 0
080903 16:20:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution
A mysqld process already exists at Wed Sep 3 20:56:28 EAT 2008
A mysqld process already exists at Wed Sep 3 20:57:34 EAT 2008
080903 21:00:02 [Note] /usr/libexec/mysqld: Normal shutdown

080903 21:00:03 [ERROR] bdb: log_archive: DB_ARCH_ABS: No such file or
directory
080903 21:00:03 InnoDB: Starting shutdown...
080903 21:00:08 InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:00:08 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:00:08 mysqld ended

080903 21:00:52 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080903 21:00:52 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080903 21:00:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080903 21:01:02 InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080903 21:01:09 InnoDB: Started; log sequence number 0 0
080903 21:01:10 [ERROR] Can't start server : Bind on unix socket:
Permission denied
080903 21:01:10 [ERROR] Do you already have another mysqld server
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:01:10 [ERROR] Aborting

080903 21:01:10 InnoDB: Starting shutdown...
080903 21:01:13 InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:01:13 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:01:13 mysqld ended

080903 21:05:24 mysqld started
080903 21:05:27 InnoDB: Started; log sequence number 0 43655
080903 21:05:27 [ERROR] Can't start server : Bind on unix socket:
Permission denied
080903 21:05:27 [ERROR] Do you already have another mysqld server
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:05:27 [ERROR] Aborting

080903 21:05:27 InnoDB: Starting shutdown...
080903 21:05:29 InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:05:29 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:05:29 mysqld ended

080903 21:16:40 mysqld started
080903 21:16:44 InnoDB: Started; log sequence number 0 43655
080903 21:16:45 [ERROR] Can't start server : Bind on unix socket:
Permission denied
080903 21:16:45 [ERROR] Do you already have another mysqld server
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:16:45 [ERROR] Aborting

080903 21:16:45 InnoDB: Starting shutdown...
080903 21:16:46 InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:16:46 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:16:46 mysqld ended

080903 22:26:39 mysqld started
080903 22:26:41 InnoDB: Started; log sequence number 0 43655
080903 22:26:42 [ERROR] Can't start server : Bind on unix socket:
Permission denied
080903 22:26:42 [ERROR] Do you already have another mysqld server
running on socket: /var/lib/mysql/mysql.sock ?
080903 22:26:42 [ERROR] Aborting

080903 22:26:42 InnoDB: Starting shutdown...
080903 22:26:46 InnoDB: Shutdown completed; log sequence number 0 43655
080903 22:26:46 [Note] /usr/libexec/mysqld: Shutdown complete

080903 22:26:46 mysqld ended

you must have done something untoward...

try these commands as root

service mysqld stop
rm /var/lib/mysql/mysql.sock
service mysqld start

and see if it stays running

Craig

still not working, this is what i got

[root@localhost /]# service mysqld stop
Stopping MySQL: [FAILED]
[root@localhost /]# rm /var/lib/mysql/mysql.sock
rm: cannot remove `/var/lib/mysql/mysql.sock': No such file or directory
[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost /]#

I would like to see your my.cnf... Just remember that MySQL looks for
the file in these locations:

/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

In that order...

But looking at your log file I think this is your issue:

080903 22:26:42 [ERROR] Can't start server : Bind on unix socket:
Permission denied

this is the content of /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

the rest of the files have nothing in them

What is the permissions on /var/lib/mysql ? the mysql user is going to
need access to this directory.

run chown -R mysql:mysql /var/lib/mysql

heimdull wrote:

What is the permissions on /var/lib/mysql ? the mysql user is going to
need access to this directory.

run chown -R mysql:mysql /var/lib/mysql

it doesn't give any output just another prompt i.e

[root@localhost /]# chown -R mysql:mysql /var/lib/mysql
[root@localhost /]#

is there anything else that i have to do?

heimdull wrote:
> What is the permissions on /var/lib/mysql ? the mysql user is going to
> need access to this directory.
>
> run chown -R mysql:mysql /var/lib/mysql

it doesn't give any output just another prompt i.e

[root@localhost /]# chown -R mysql:mysql /var/lib/mysql
[root@localhost /]#

is there anything else that i have to do?

Craig White wrote:

[root@localhost /]#

is there anything else that i have to do?

----
try restarting mysqld service and see if it keeps running, otherwise,
answer my earlier questions

Craig

Hi craig,

mysqld server does not want to keep on running when started this is
what i get

[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost /]#

and i thought i answered all of your questions can you please be
more specific on the question that you want to be answered?

----
try restarting mysqld service and see if it keeps running, otherwise,
answer my earlier questions

Craig

Hi craig,

mysqld server does not want to keep on running when started this is
what i get

[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost /]#

and i thought i answered all of your questions can you please be
more specific on the question that you want to be answered?

Maybe see if this gives a better output:

# mysqld -umysql --verbose --datadir=/var/lib/mysql

heimdull wrote:

Maybe see if this gives a better output:

# mysqld -umysql --verbose --datadir=/var/lib/mysql

here is the output of mysqld -umysql --verbose
--datadir=/var/lib/mysql

[root@localhost /]# mysqld -umysql --verbose --datadir=/var/lib/mysql
bash: mysqld: command not found

anything else please?

what if i unistall mysql and then re-install it will this help to
solve this problem

what if i unistall mysql and then re-install it will this help to
solve this problem