There are lots of advantages of using open source product. It’s an ever true dialog and I felt it personally few days ago. I am very new user of PHP, MySql and others open source staff though till now i knew very little compare to others but i wanted to share some experience here. Recently, one senior of my organization gave me a problem on mysql actually on PMA [‘PHP My Admin']. And I came with his solution less then a minute. I know it was very very childish problem but it was possible to came out a solution with in a minute because of it is an open source product.
Most of the time we are using a package of PHP,MySql, PHPMyAdmin for windows OS. Like WAMP, XAMPP, APPSERV etc. whom I am talking about means that senior who gave me this problem, is very good developer in oracle and all its stuff. But he is just started his journey with open source product like mysql, php etc. so to using those entire thing first he installed WAMP in his OS. Most of the time we don’t set a password for database “root” user. Now he wanted to set a password for “root” user. Actually he wanted to secure his database. For doing this he went to “localhost/phpmyadmin” after that going to “Privileges” Tab and there he just set a password for “root”. So far all things went smoothly.
Just after changing root’s password, When he tried to login again he just lost all access on phpmyadmin !!! as a result, he got the following screen.
What he could do now? He put him self in a trouble by setting a password on root user. At that moment he did lots of task like …uninstall WAMP, again install it,… trying with some other package ……and so on… all the time he got same error. Actually I never tried to change “root’s” password… what I did create a new user ….set a password and give an access that user on particular DB. So when he asked me “is it possible to change root’s password”.. I said “obviously why not” and after that he told “but I can’t use mysql” “what can I do”.
I am also not used to this type of scenario. I installed WAMP … did same what he wanted… and kept same error. I read the error message and there I found “You should check the host, username and password in config.inc.php” and got the solution immediately. To solve his trouble I went to “\wamp\phpmyadmin” location and checked out “config.inc.php” open it in editor. And line number 73 ….i wrote root’s password.
$cfg['Servers'][$i]['password'] = ‘my_password’; // MySQL password (only needed
I think this is only possible because mysql is an open source software.
