March 11, 2012

How to login in MySQL with a Non Root user

Question by sandbox

I have setup 2 user Uone and Utwo in Mysql. But when I open localhost/phpmyadmin it logins with root user. What URL is used to login with Uone or Utwo user. I am running Mysql from XAMPP.

Answer by Starx

IF you had installed phpmyadmin separately, you would be asked for username and password in the startup.

Since you have a pre-installed version of phpmyadmin. You can do the following to do so.

  1. Find the phpmyadmin installation or project file
  2. Open the file called config.inc.php
  3. Inside you will find details to change the username and password ...

    $cfg['Servers'][$i]['user']          = 'Uone';
    $cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
    $cfg['Servers'][$i]['auth_type']     = 'config';
    

Author: Nabin Nepal (Starx)

Hello, I am Nabin Nepal and you can call me Starx. This is my blog where write about my life and my involvements. I am a Software Developer, A Cyclist and a Realist. I hope you will find my blog interesting. Follow me on Google+

...

Please fill the form - I will response as fast as I can!