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
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/ ?
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.
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.
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.
14 Aug 2008
Ok Thanks
I think now I know how to solve the problem.
I'll Post it when it works.