Latest LQ Deal: Latest LQ Deals
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 04-06-2006, 03:37 AM   #1
Registered: Sep 2004
Location: Hyderabad
Posts: 440
Blog Entries: 1

Rep: Reputation: 30
Smile mysql user account management confusion

I have installed a Software which automatically installs all the mysql databases and it tries to access the mysql database.
When I am trying to access the mysql database, its telling me that root cannot access account. How will I know what accounts have been configured by the software i installed?
If I need to know the mysql accounts existing, what way I should proceed?
Even mysqladmin cannot create anymore users.
How to know what users are configured to use mysql.

All Suggestions are welcome
Old 04-06-2006, 05:24 AM   #2
Senior Member
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
In MySql, logged in as the administrator (same account as for mysqladmin), you can do:
show databases
to get a list of all the installed databases.
use some_database
(where some_database is replaced by the actual database's name)
makes you use a certain database.

Privileges and other MySql system stuff is often stored in the INFORMATION_SCHEMA database.
If you "use" that, you can alter privileges (provided you logged in under the database administrator account)
and thus give you access to the databases (if you didn't already have it).
Check out the MySql website & docs for info on the INFORMATION_SCHEMA database and it's tables.


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
is it legitimate and allowed and can be done to make another user account set uid and gid to null 0 to make another root account with different name and possibly not damage the debian system creating and using that new account BenJoBoy Linux - Newbie 12 01-29-2006 10:02 AM
difference in user account management tools for debian, red hat and caldera. carverj Linux - Newbie 1 04-05-2005 07:07 AM
linux vs windows user account management sblair_32 Linux - Software 2 04-01-2005 09:57 AM
User Account Management kawaii Linux - Newbie 3 03-19-2003 02:17 AM
Account Management Software bubsgt95 Linux - Software 1 01-10-2003 01:45 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:24 AM.

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