mysql help please
 

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

What error messages do you get? (if any)

no

8char

/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

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

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

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!

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)

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 :(

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

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

...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 :Oh crap

screw it... i'm done with it

thanks for the help anyway

:1orglaugh sorry man

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?

did you do this:

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