How do you set up a mySQL database locally when you have WAMP installed?

Question

How do you have multiple databases setup locally and how do you know the details of each for testing different local installations of Joomla for example?

When you have a system fully developed locally how do you transfer the actual mySQL database to web space like OneandOne to make it useable on the web?

Answer 1

mySQL uses a command line interface to configure.



However with WAMP you also have phpmyadmin, which can configure your database(s).



If you point your browser to http://localhost or http://127.0.0.1. It should bring up an interface to configure such things.



Transfering, you would perhaps copy the files to the server. But the server is probably running its own mySQL and phpadmin. You would then have to create fresh databases on the server end with phpmyadmin. Then you could use the import options or issue sql commands in phpmyadmin to get your data into them.

Answer 2

Host or no host, you may run MySQL and Hypertext Preprocessor regionally. in basic terms installation Hypertext Preprocessor and MySQL on your interior sight / dev gadget. reckoning on which OS you're working, this dictates which MySQL and Hypertext Preprocessor distributions you may receive. some IIS or Apache configuration will must be finished in the two case.

Answer 3

You log in to mysql from a console and create the databases and tables. Enter data and then access and manipulate it from php pages. Some sites will allow you to copy the files to their database location. Others you need to run the create from scratch, so use scripts to create them.

Answer 4

Hi... Easy steps with images... See http://hints.steptoinstall.com/how-to-create-database-in-localhost-wamp.html