phpmyadmin user create

shrestha · 07-04-2013, 03:49 PM

while i try to create user in phpmyadmin it says already exit root user? how to see and how to edit that user.. Do i need to create root user to open my website in localhost.

frankbell · 07-04-2013, 09:04 PM

You should have a root user. Indeed, you certainly do, but it sounds as if you are unsure as to how to access it.

Then root can create a separate user(s) without global rights but with the rights to manage specific database(s) for day-to-day database maintenance.

More specific information would help for a more precise answer. For example, are you using XAMPP or a conventional LAMMP stack? What is the precise error message you are getting? What distro/version? and so on.

In case it helps, here's a link to the phpAdmin wiki.

eklavya · 07-05-2013, 02:04 AM

Quote:

Originally Posted by shrestha

while i try to create user in phpmyadmin it says already exit root user?

you mean already exist?
so why are your trying to put same username, put anything else.

Are you able to log into php myadmin? if you are.
you can see the tab "users". Inside it, there is option "Add user". You can add users from here.

If you are not able to log into phpmyadmin. You can add user using command line.

Code:

mysql -h localhost -u root -p

Enter the password, what you put while installation. Now add user from here.

If you are not able to reach on command prompt, reach there using safe mode and add new user.