MySQL

[vivek patil]

hi,
 
Firstly stop mysql then do following : 
first check max_connection in my.cnf , it should not be more than 256, general setting should be 150. and include this line in my.cnf : socket=/var/lib/mysql/mysql.sock
 
then remove mysql.sock file from /tmp/mysql.sock  and   /var/lib/mysql/mysql.sock
then symlink this files : Try ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

after doing this step restart mysql.
your issue will be solve.
basically the mysql.sock errors comes due to the database connections not matching properly. you need to check the my.cnf file properly. check the max connection , then the max database connection. generally there are lots of request from the users and the basic settings doesnt match. the sock error appears. 
 
ENJOY.
 
Vivek Patil.
System Adminstrator.



bala chandar <mbchandar at gmail.com> wrote:
its better you stop the service running on port 3306. then u try to
start the mysql in safe mode and check!!!

try safe-mysqld
i think..


On Fri, 03 Dec 2004 12:51:58 -0800, Eric Wagar wrote:
> 
> On Fri, 3 Dec 2004 11:43:20 -0800, "Brian D. McGrew"
> 
> 
> 
said:
> > 041203 11:02:18 mysqld started
> > 041203 11:02:18 [Warning] Asked for 196608 thread stack, but got 126976
> > 041203 11:02:18 [ERROR] Can't start server : Bind on unix socket:
> > Permission denied
> > 041203 11:02:18 [ERROR] Do you already have another mysqld server
> > running on socket: /var/lib/mysql/mysql.sock ?
> > 041203 11:02:18 [ERROR] Aborting
> >
> > 041203 11:02:18 [Note] /usr/sbin/mysqld: Shutdown complete
> >
> > 041203 11:02:18 mysqld ended
> >
> > This is on a RH9 system. Any ideas what I'm missing here?
> 
> By default, MySQL runs on port 3306. Do you happen to have anything
> else running on that port? Possibly another MySQL process? :)
> 
> I also believe that MySQL's default socket file is
> srwxrwxrwx 1 mysql mysql 0 Dec 1 17:17
> /var/lib/mysql/mysql.sock
> which is specified in your /etc/my.cnf file.
> 
> --
> Eric Wagar
> eric at deadhookers.org
> 
> 
> 
> --
> redhat-list mailing list
> unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
> https://www.redhat.com/mailman/listinfo/redhat-list
> 


-- 
bala> balachandar muruganantham
bala> lynx http://chandar.blogspot.com

-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

		
---------------------------------
Do you Yahoo!?
 Read only the mail you want - Yahoo! Mail SpamGuard.