Need help in configuring MySQL..

[br_prashant]

Hey!
Using Suse 11.0 and got the apache server mysql and php installed during the OS instalation tself.
I used YAst to get the apache server up using the HTTP server option in its networking tab.
When i used the runlevel services option of the system tab in yast and try to enable mysql... it throws an error saying
/etc/init.d/mysql start returned 1 (unspecified error):

Also when i try giving the comand mysql on a console it throws an errorl like
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

So...
I would like to set it up and use it from php.
So oce i get the mysql up configured what else will i need?
My http server is running as i could use localhost:/ to open a simple html page from the folder...

[ynilesh]

Please post command whichever you already tried. It seems you are trying to access to mysql with username and password which has no privileges.

make sure that your mysql is running,

netstat -an | grep 3306

If its running, Use the mysqladmin command to set the MySQL root password.

mysqladmin -u root password new-password

And once you set password,

mysql -u root -p

Please let us if it still doesnt work.

[davidanand]

hey ,

Your Mysql is good the socket file is missing its not a big deal
craete a link from /var/lib/mysql/mysql.sock to /tmp
restart mysql.... issue fixed