Wednesday, December 7, 2011

Change username or password of database

Database security concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links) against compromises of their confidentiality, integrity and availability.

One of the things you should do to secure your data is to change the username and password of your database. It is quite easy to do, just remember that if you change it, make sure to also change your settings in your application.
I am using wamp server and mysql as my database. Here are the steps to do this:
  1. Open config.inc.php. Mine is located at C:\wamp\apps\phpmyadmin3.2.0.1
  2. Change the settings for username and password. By default, it is set to 'root' and empty for password. In the figure below I changed my username to 'mynewuser' and my password to 'asdfgh'. Of course you could change it to something more secure.
  3. Fig 1: Sample of config.inc.php
  4. Lastly, Restart your server so changes will be on effect.

It's easy and makes your database more secure.

1 comment: