Find the answer to your Linux question:
Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    Need help in configuring MySQL..

    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)

    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...

  2. #2
    Linux Newbie
    Join Date
    Feb 2008
    Bangalore, India
    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.
    Registered Linux User: #476440

  3. #3
    Linux Newbie
    Join Date
    Apr 2008
    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
    David Anand
    -->Success is the list of failures ...!!!

  4. $spacer_open

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts