WampServer

Hello,

I'm trying to copy an up-and-running Drupal site to my localhost. I have installed WAMP, but am not sure if it's configured correctly. When I try to load the Drupal database by left-clicking the system tray and going to phpMyAdmin I get the following error when I try to import database. I don't see where I'm supposed to enter my user and PW for the database, where do I do that? I'm not sure if I have to configure WAMP after installing.

Thanks for any help.

Nathan



Error

SQL query:

--
-- Database: `nathanearth`
--
-- --------------------------------------------------------
--
-- Table structure for table `access`
--
CREATE TABLE `access` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`mask` varchar( 255 ) NOT NULL default '',
`type` varchar( 255 ) NOT NULL default '',
`status` tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( `aid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

MySQL said: Documentation
#1046 - No database selected

before importing you database tables you'll have to create a database first. Go to phpAdmin and type in the following into the Create a new database field 'nathanearth' (without quotes).

Now click the import tab and your database will setup. You can setup a password by clicking the Privileges tab when going to phpmyadmin.

thanks for the info...i created the database no problem. however, i went to privileges tab before importing database. i added a user with same username and password as the database on my server.

Now I get

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO) .

I didn't change the password for root.

Is there a way I can undo the changes I made in the privileges tab so I can get back into PHPMyadmin and try again?

thx

download resetmysql here
[downloads.jlbn.net]
to setup password, follow this
[blog.jlbn.net]
to setup db, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Thanks so much c2dan and yfastud...my home page loads!!

The links aren't working locally, but that's a Drupal issue (I think)....

Great to finally demystify WAMP a bit...