[BALU] MySQL administrator SUMMARY

Daniel Hallmark daniel.hallmark at gmail.com
Wed Apr 18 15:02:38 CDT 2007


On 4/18/07, Stuart Carter <stuart.carter at spamcop.net> wrote:
>
> OK, that helped. In the wiki db, there is no user "ouruser" in the users
> table.
>
> In the other db (the trouble ticket db) the reply
> Table 'troubleticket.user' doesn't exist
> came back
>
> ... this is giving me a really bad headache ;)

When I gave instructions to query "mysql.user" I really meant to
literally type in "mysql.user" - not to substitute your own database
name.  This ensures that regardless of which database in mysql your
user is currently logged into you'll be querying the "mysql" user
table (i.e. the ones with the accounts and permissions) and not a user
table that belongs to a particular application.

The "troubleticket.user table does not exist" seems to indicate you
were asking it to dump a user table inside the troubleticket database,
not inside the mysql database.

A bit more terminology... mysql is a database server application, but
it supports multiple "databases" that can be hosted by one server
instance.  These are created using the "create database" SQL syntax,
and you can display them from the mysql commandline client by issuing
the command:

show databases;

One of the databases that exists within the mysql db server is a
database named, literally, "mysql".  It is that database that contains
the administrative metadata such as user accounts and priviledges.
The "mysql" database table named "user" is the one that

To get a listing of tables within a particular database you can issue
a use command to change to that database and then show a list of the
tables in the db.
   show tables in <insert database name>;

Within a given table you can get a list of the columns by issuing a command
   show columns in <insert table name here>;

Jim's email indicates your problem is resolved so I'll sign off unless
you have further questions.

Daniel



More information about the Members mailing list