I am new to mysql, especially on Windows but I am an experienced Oracle DBA so it is really the windows aspect that I am weak on.
I have installed mysql and PHP on my laptop and I have a mysql database that I can access on my hosted webserver.
However I am struggling to be able to connect phpmyadmin to my local database (which is up and running) and test out my create tables acripts etc without logging onto the remote server.
I currently just run a cmd call to open a dos window which is not the easiest way to work.

Trying to get phpmyadmin to work locally I have edited the config.inc.php file in C:\phpMyAdmin-2.6.4-pl4 to read as follows

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/C:\phpMyAdmin-2.6.4-pl4/index.php'; However I get a 404 error whn trying to connect to my database through phpMyAdmin with http://localhost/phpMyAdmin

Sorry to ask such simple questions but I have tried all sorts of things to get it to work and it is frustrating as I know my table layout and want to get on with the design and build of my application (simple though it is)