Plot
Few days back I faced an interesting problem. For convenient reasons I delivered a web application in offline using xampp. After using some days the client complained that the sales report is not accurate. When we investigated, we found out someone deleted a bunch of rows getting into phpmyadmin. Fortunately we were able to recover the deleted data because of our secondary backup method. Now we have to fix it so that this scenario never happens again. So, we put a login access into our database securing with password! So, now any unauthorized access can be prohibited. I am explaining the details of procedure step by step.
Honestly the procedure is a bit too easy if you are a web developer. Just make sure to follow step by step…
Note: make sure your XAMPP, Apache, MySQL is running
Step 1: go to your web browser and type “localhost/phpmyadmin” in the address bar.
Step 2: On top of the phpmyadmin bar look for “User accounts” and click on it
Step 3: Find the exact match and click on “edit privileges”
Step 4: Now click on “Change password” and assign password and then press “Go”
Step 5: After that go to xampp/phpmyadmin/ directory and edit the “config.inc.php” file and replace the following variables with mentioned values
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
Now save the file and go to your browser and type in “localhost/phpmyadmin”, you will see a login screen like below.
So, this was the procedure. Hope it helped. Let me know if you have any similar experience in the comments below! Cheers!
0 Comments