To change password of mysql using php file for xampp and others whose phpmyAdmin is not working i.e showing Access Denined

To change password of mysql using php file.

Note:

        

 1. Install Apachi tomcat web server or download xampp which is easiest to configure.

2. Download the files below and paste it in the folder. For xampp it  "C:\xampp\htdocs".

     https://drive.google.com/folderview?id=0BzIWTCya7lAWZWdlaU1ZQVdKaGs&usp=sharing

3. In XAMPP control pannel make sure Apachi and mysql are started.

Solving this error:

Install xampp and then open its control panel

2. Start service Apache and MySQL

3.Go to Web browser and type localhost.

Now you can see that xampp page is loaded.

If you want to run php or html or jsp or any web page you need to copy those pages into htdocs folder i.e

Or you can create a folder under htdocs and then paste your file in it.

Now at your web browser type “localhost/your_file_name.extension” and hit enter.

This is how you can run a page on a server.

Or if you have a folder inside htdocs follow this

Sqlconnet is a folder inside htdocs and i have connect.php inside sqlconnect folder.

HOW TO CHANGE MYSQL DATABASE PASSWORD

Once you are done with all configuration and pasted connect.php and pswdchng.php inside your htdocs folder i.e

Now follow this....

Open web browser and type this....

Or simple “localhost/connect.php”

Now follow the images below

Password by default is root or nothing i.e blank.

Click on connect and wait.

New page shows successfully connected to database.

So now you can change your password.

NOTE: Keep your new password blank if you want to access phpmyAdmin and click changepassword button.

Now goto phpmyAdmin link and check...

You are done J

Any query feel free to contact me at sirusdas@gmail.com