DIYMacServer » MySQL

5 posts

Database doesn't start

started at 11 Aug 2008
started by mastertk
last reply from mastertk
  • mastertk
    11 Aug 2008
    #

    I need to create a database for a webshop.
    I created one in phpmyadmin but it doesn't show up in the process list and I don't know how to start it.
    Maybe someone can give me some advise.
    Greetings Thomas

  • 13 Aug 2008
    #

    Thomas, why do you think it isn't started ? If you can access it by using phpmyadmin you should be able to connect to it from your webshop. You should only see a mysqld process running. Please make sure you connect to it with the correct user and password and that access has been granted.

  • mastertk
    13 Aug 2008
    #

    Oke but the webshop says it can't connect trough a certain socket but why can phpmyadmin access trough the socket and the webshop doesn't.
    And the password and user that I need to use are those the same as the password and user I need to open HTTP://Localhost/phpmyadmin/ ?

  • 13 Aug 2008
    #

    Normally your connection is configured in your php.ini but the configuration may be overwritten by your webshop applicaiton. Please compare the connection settings between phpmyadmin and your webshop application. It is possible to use socket and ports to connect. If you use my security advise the port option is closed of.

    You could use the same password, but I think it is best to have a separate user/password for each database for security purposes.

  • mastertk
    14 Aug 2008
    #

    Ok Thanks
    I think now I know how to solve the problem.
    I'll Post it when it works.

Reply

You must log in to post.