Find the answer to your Linux question:
Results 1 to 3 of 3
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Sep 2007
    Posts
    38

    Need help in configuring MySQL..


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

  2. #2
    Linux Newbie
    Join Date
    Feb 2008
    Location
    Bangalore, India
    Posts
    112
    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,
    Code:
    netstat -an | grep 3306
    If its running, Use the mysqladmin command to set the MySQL root password.
    Code:
    mysqladmin -u root password new-password
    And once you set password,
    Code:
    mysql -u root -p
    Please let us if it still doesnt work.
    bigunix.blogspot.com
    Registered Linux User: #476440

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

  4. $spacer_open
    $spacer_close

Posting Permissions

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