LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-04-2013, 04:49 PM   #1
shrestha
LQ Newbie
 
Registered: Jul 2013
Location: canada
Posts: 1

Rep: Reputation: Disabled
phpmyadmin user create


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.
 
Old 07-04-2013, 10:04 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, and whatever VMs I happen to be playing with
Posts: 12,776
Blog Entries: 17

Rep: Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313Reputation: 3313
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.
 
Old 07-05-2013, 03:04 AM   #3
eklavya
Member
 
Registered: Mar 2013
Posts: 622

Rep: Reputation: 136Reputation: 136
Quote:
Originally Posted by shrestha View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create database,username and password in phpmyadmin SarahGurung Linux - Newbie 2 10-24-2011 12:19 PM
how to create database,username and password in phpmyadmin SarahGurung Linux - General 1 10-24-2011 06:25 AM
phpMyAdmin - Allow Users to create Databases blizunt7 Linux - Server 2 10-10-2007 07:00 AM
phpmyadmin for each user Digital_Err0r Linux - Newbie 1 04-13-2004 06:31 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:51 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration