too long

Question

I have a client that runs an app on an internal server on a WAMP stack. I don't have access to this server remotely and honestly they are not set up to give me that access. What they did do was download a directory that contains the entire app and DB. Is there a way to take that and install it locally? Whats's involved in getting that going?

Looks like MySQL 5.5.8 and PHP 5.3.5

Answer 1

How to reset the MYSQL root password

Stop the mysql service

wampmanager -> MySQL -> Service -> Stop Service

Edit the my.ini file

wampmanager -> MySQL -> my.ini

Find the [wampmysqld] section in the ini file Add this line directly after the section [wampmysqld]

skip-grant-tables

Restart the mysql service.

wampmanager -> MySQL -> Service -> Start/Resume Service

Open the MySQL console

wampmanager -> MySQL -> MySQL Console

Now we are going to reset the password for the root user, of course this could be used to reset any users password.

enter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql.

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE user='root';
FLUSH PRIVILEGES;

Note that the update should report that it has updated more than one row, that because there are actually 3 user accounts with the userid of 'root' each with a different domain i.e. 127.0.0.1, localhost and ::1

Now enter 'quit' at the mysql command promt to exist mysql.

Stop the mysql service

wampmanager -> MySQL -> Service -> Stop Service

Edit the my.ini file

wampmanager -> MySQL -> my.ini

Find the [wampmysqld] section in the ini file

Remove the 'skip-grant-tables' parameter we added earlier.

DO NOT Leave this parameter in the ini file its a HUGH security hole.

Restart the mysql service.

wampmanager -> MySQL -> Service -> Start/Resume Service

You should now be able to login with phpmyadmin using the userid 'root' and the new password you have just set for that user.