The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Managing MySQL locally

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)

there are some windows applications from mySQL that allow you to admin databases. Much better than phpMyAdmin. There is also 3rd party app called mySQL-Front which works well. This used to be free, but I believe it has gone to a paid version now.

/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* [url]http://www.your_web.net/path_to_your_phpMyAdmin_directory/[/url]
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it. There will be
* an error message if phpMyAdmin cannot auto-detect the correct value.
*
* If the auto-detection code does work properly, you can set to TRUE the
* $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
*/

which means that your line should read: $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/

the problem with this is you'll never be able to access phpmyadmin from any computer other than your laptop. i suggest you leave this parameter blank until you test editing a row like the configuration file suggests. if that works with no errors, then set [b]$cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;[b]

your configuration files isn't problem. your web server doesn't know to look in the root of your c: drive to find phpmyadmin. you need to move that folder to wherever your files are being served from and rename the folder to just phpmyadmin

you do not have the mysql extension enabled for PHP. are you following a guide to installing apache/php/mysql? because you are either skipping steps or the guide you are following is for PHP 4 and you're probably using PHP 5. the setups for PHP 5 and mysql 5 are different from PHP 4 and mysql 4.