mysql help please

[Mr Pheer]

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

[woj]

What error messages do you get? (if any)

[darksoul]

no

8char

[Mr Pheer]

/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]

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

[Mr Pheer]

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

[Mr Pheer]

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]

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)

[Mr Pheer]

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]

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

[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

[Mr Pheer]

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]

screw it... i'm done with it

thanks for the help anyway

[Hornydog4cooter]

sorry man

[TexasDreams]

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]

did you do this:

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