mysql help please - GoFuckYourself.com

Mr Pheer · 08-11-2005, 12:23 AM

i got it installed but it wont start... any ideas?

woj · 08-11-2005, 12:24 AM

What error messages do you get? (if any)

darksoul · 08-11-2005, 12:24 AM

no

8char

Mr Pheer · 08-11-2005, 12:26 AM

/usr/local/bin/mysqld_safe &
[2] 44131
[1] Exit 1 /usr/local/bin/safe_mysqld
sly# touch: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory
chown: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory
Starting mysqld daemon with databases from /var/db/mysql
/usr/local/bin/mysqld_safe: cannot create /var/db/mysql/sly.splitinfinity.net.err: No such file or directory

darksoul · 08-11-2005, 12:28 AM

chown -R mysql:mysql /var/db/mysql

Mr Pheer · 08-11-2005, 12:32 AM

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

Mr Pheer · 08-11-2005, 12:33 AM

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

pronwatcher · 08-11-2005, 12:41 AM

I usually do something like /usr/local/bin/safe_mysqld --user=mysql

Do a "ps -aux |grep mysq" to verify it is running -- then you should be able to do mysql -p to login (if you have a password set for your mysql user)

Mr Pheer · 08-11-2005, 12:45 AM

Quote:

Originally Posted by pronwatcher

I usually do something like /usr/local/bin/safe_mysqld --user=mysql

Do a "ps -aux |grep mysq" to verify it is running -- then you should be able to do mysql -p to login (if you have a password set for your mysql user)

sly# /usr/local/bin/mysqld_safe --user=mysql
touch: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory
chown: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory
Starting mysqld daemon with databases from /var/db/mysql
/usr/local/bin/mysqld_safe: cannot create /var/db/mysql/sly.splitinfinity.net.err: No such file or directory

same thing

Mr Pheer · 08-11-2005, 12:46 AM

sly# ps -aux |grep mysq
root 44208 0.0 0.0 348 232 p0 R+ 3:50PM 0:00.00 grep mysq

OzMan · 08-11-2005, 12:49 AM

I usually press the "create a database" button in CPanel

...This site talks about that error and some possible solutions

http://dev.mysql.com/doc/mysql/en/ca...to-server.html

Mr Pheer · 08-11-2005, 12:50 AM

Quote:

Originally Posted by OzMan

I usually press the "create a database" button in CPanel

...This site talks about that error and some possible solutions

http://dev.mysql.com/doc/mysql/en/ca...to-server.html

i have webmin but it cant start mysql either.. cant make a database if it wont start

Mr Pheer · 08-11-2005, 01:02 AM

screw it... i'm done with it

thanks for the help anyway

Hornydog4cooter · 08-11-2005, 01:04 AM

sorry man

TexasDreams · 08-11-2005, 01:05 AM

Quote:

Originally Posted by MrPheer

i got it installed but it wont start... any ideas?

If you just did the install it may be that it failed at some point and didn't create the core database correctly. Have you tried a re-install?

Serge Litehead · 08-11-2005, 01:15 AM

did you do this:

Quote:

Originally Posted by darksoul

chown -R mysql:mysql /var/db/mysql

http://dev.mysql.com/doc/mysql/en/in...ng-binary.html
http://dev.mysql.com/doc/mysql/en/in...ng-source.html

08-11-2005, 12:23 AM	#1
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	mysql help please i got it installed but it wont start... any ideas?

08-11-2005, 12:24 AM	#2
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	What error messages do you get? (if any) __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

08-11-2005, 12:24 AM	#3
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	no 8char __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

08-11-2005, 12:28 AM	#5
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	chown -R mysql:mysql /var/db/mysql __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

08-11-2005, 12:41 AM	#8
pronwatcher Registered User Join Date: Aug 2005 Posts: 8	starting with the wrong permissions? I usually do something like /usr/local/bin/safe_mysqld --user=mysql Do a "ps -aux \|grep mysq" to verify it is running -- then you should be able to do mysql -p to login (if you have a password set for your mysql user)

08-11-2005, 12:26 AM	#4
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	/usr/local/bin/mysqld_safe & [2] 44131 [1] Exit 1 /usr/local/bin/safe_mysqld sly# touch: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory chown: /var/db/mysql/sly.splitinfinity.net.err: No such file or directory Starting mysqld daemon with databases from /var/db/mysql /usr/local/bin/mysqld_safe: cannot create /var/db/mysql/sly.splitinfinity.net.err: No such file or directory

08-11-2005, 12:32 AM	#6
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	sly# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

08-11-2005, 12:33 AM	#7
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

08-11-2005, 12:46 AM	#10
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	sly# ps -aux \|grep mysq root 44208 0.0 0.0 348 232 p0 R+ 3:50PM 0:00.00 grep mysq

08-11-2005, 12:49 AM	#11
OzMan Confirmed User Join Date: Sep 2003 Location: Los Begas Posts: 9,162	I usually press the "create a database" button in CPanel ...This site talks about that error and some possible solutions http://dev.mysql.com/doc/mysql/en/ca...to-server.html

08-11-2005, 01:02 AM	#13
Mr Pheer So Fucking Banned Industry Role: Join Date: Dec 2002 Posts: 21,582	screw it... i'm done with it thanks for the help anyway

08-11-2005, 01:04 AM	#14
Hornydog4cooter Confirmed User Join Date: Jan 2005 Posts: 2,859	sorry man