Bet this happened because you just reinstalled WAMP, right? This happens if you did not back up the data folder under MySQL folder.

I am not sure if there is another alternative other than if your Windows backup is running. If it is, then you are lucky.

Simply go to the data folder and look for the iblog0 and ibdata files. Right click, select restore and choose which restore point you wish to revert back.

That’s it!

If Windows was not able to back up those files, you are out of luck.

This is a problem that hounds PHP developers quite often. Even using WAMP it still gives this error which confused me because I did not encounter any problems when I added a new user account in MAMP.

I did exactly the same steps when adding a new database user account in WAMP and it always gives the Access denied for user ‘root’@’localhost’ (using password: YES).

To get around this problem, it is always best to use a different user account other than root. To add a new user account with the same privileges are a root user account, do the following steps:

– click the database and go to PRIVILEGES tab
– click EDIT PRIVILEGES on the entry named user:root and host:localhost
– scroll down. there should be a login information section. in the user name field, type a new username
– set a password
– then click the GO button below it. it should create the new user account with the same privileges as the root user account.

A note to consider: Make sure you change the password of the root user account because by default the password is blank.

relationview

When mapping tables with foreign keys in PHPMyAdmin, you need the “Relation View” link to do so. However, in WAMP, it does not show by default.

No fret. To enable “Relation View”:

  1. Go to the file config.inc.php located in /wamp/apps/PHPMYADMINFOLDER/
  2. Add this line $cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’;
  3. Restart Apache.

You should now see the “Relation View” link after that.

Related Posts Plugin for WordPress, Blogger...