MySql problems

mishmash · 27-06-2008, 01:52:18 PM

Quote:

Originally Posted by yesterday

are you starting mysql as the right user?

yesterday

I have tried to start it via the WHM control pannel

And as root trying to start mysqld_safe

mishmash · 27-06-2008, 02:34:27 PM

I tried running mysqlup (updating mysql without success)

Quote:

su mysql
bash-3.00$ /usr/sbin/mysqld
080627 15:35:22 [ERROR] Can't start server : Bind on unix socket: Permission denied
080627 15:35:22 [ERROR] Do you already have another mysqld server running on socket: /usr/local/lib/mysql.sock ?

No other mysqld :

Quote:

killall -9 mysqld
mysqld: no process killed

I don't know about the "permission denied".

mishmash · 27-06-2008, 02:39:13 PM

Quote:

Originally Posted by mishmash

I don't know about the "permission denied".

Permissions on the mysql.sock file look fine

Quote:

srwxrwxrwx 1 mysql mysql 0 Jun 26 21:02 mysql.sock=

Jeewhizz · 27-06-2008, 02:40:17 PM

as silly as it sounds, in the past, a reboot has fixed this... Have you tried that?

However, there are a few issues with cpanel / mysql etc. Try this page: Fun Things in Life Blog Archive WHM/CPanel MySQL 5 Problem

mishmash · 27-06-2008, 03:07:47 PM

I have tried a number of restarts

I have ensured there are no basedir entries in mysql.cnf

I have also performed a forced upgrade of MySQL and restarted.

yesterday · 27-06-2008, 03:28:53 PM

I don't think you should be able to start mysql as root very easily - I think you should perhaps be the mysql user or another.

forget that I cant find any evidence online to support my theory!

yesterday

yesterday · 27-06-2008, 03:57:07 PM

this link:
Cannot start mysqld and mysql - Usenet Forums
suggests (last post) that you delete the mysql.sock file and let mysql_safe rebuild it.

Might be worth a try (probably rename or move rather than delete - just in case!)

yesterday

Jeewhizz · 27-06-2008, 04:58:06 PM

Alternatively, try looking on the cpanel forums, as you won't have been theonly person with that problem

mishmash · 27-06-2008, 05:28:32 PM

Craig's team at UK Dedicated Servers, Managed Dedicated Servers, UK Managed Web hosting, cPanel Hosting & Business hosting with Passionate Support solved the problem by commenting out the line:

Quote:

socket = /usr/local/lib/mysql.sock

In mysql.cnf

27-06-2008, 02:40:17 PM	#14 (permalink)
Jeewhizz Join Date: May 2006 Posts: 1,188 No Classified Ratings Domain Trader Rating: (100% / 17)	as silly as it sounds, in the past, a reboot has fixed this... Have you tried that? However, there are a few issues with cpanel / mysql etc. Try this page: Fun Things in Life Blog Archive WHM/CPanel MySQL 5 Problem __________________ UK Web Design & Development Airport Car Parking \| Business Help & Advice \| Critical Illness Insurance \| Smoothie Recipes \| Baby Name Books

27-06-2008, 03:28:53 PM	#16 (permalink)
yesterday Join Date: Jul 2006 Posts: 603 No Classified Ratings Domain Trader Rating: (100% / 16)	I don't think you should be able to start mysql as root very easily - I think you should perhaps be the mysql user or another. forget that I cant find any evidence online to support my theory! yesterday __________________ preserve africas wilderness and help the locals survive with bees.. buy some yellow trousers Last edited by yesterday; 27-06-2008 at 03:56:03 PM.

27-06-2008, 03:57:07 PM	#17 (permalink)
yesterday Join Date: Jul 2006 Posts: 603 No Classified Ratings Domain Trader Rating: (100% / 16)	this link: Cannot start mysqld and mysql - Usenet Forums suggests (last post) that you delete the mysql.sock file and let mysql_safe rebuild it. Might be worth a try (probably rename or move rather than delete - just in case!) yesterday __________________ preserve africas wilderness and help the locals survive with bees.. buy some yellow trousers

27-06-2008, 04:58:06 PM	#18 (permalink)
Jeewhizz Join Date: May 2006 Posts: 1,188 No Classified Ratings Domain Trader Rating: (100% / 17)	Alternatively, try looking on the cpanel forums, as you won't have been theonly person with that problem __________________ UK Web Design & Development Airport Car Parking \| Business Help & Advice \| Critical Illness Insurance \| Smoothie Recipes \| Baby Name Books

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

27-06-2008, 03:07:47 PM	#15 (permalink)
mishmash Join Date: Jan 2005 Posts: 160 No Classified Ratings Domain Trader Rating: (0% / 0)	I have tried a number of restarts I have ensured there are no basedir entries in mysql.cnf I have also performed a forced upgrade of MySQL and restarted.

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
Servage MySQL problems etc....	mat	Domain Name Registrars	8	07-10-2008 01:55:41 PM
1 mysql - 2 sites...	ratboy	Website Design	4	15-02-2008 01:17:46 PM
MySQL help	fish	Services Wanted	9	10-09-2007 10:59:49 AM
123-reg problems	goldman	General Board	2	07-05-2006 07:18:25 PM