4.1.9 setup

I set up a user and database without tables (a NEW user)

then as a test, I start up mysql, select the new users' database
and issue:
show tables;

the system responds with all the tables from the "mysql" database.
if I try to "use" these tables, I get error messages and don't
actually have access to the table structure.

Can someone help me out on this?

Thanks Jim

Jim Pazarena wrote:
> I set up a user and database without tables (a NEW user)
>
> then as a test, I start up mysql, select the new users' database
> and issue:
> show tables;
>
> the system responds with all the tables from the "mysql" database.
> if I try to "use" these tables, I get error messages and don't
> actually have access to the table structure.
>
> Can someone help me out on this?
>
> Thanks Jim
You don't USE tables, you USE databases. You can DESCRIBE tables,
though. If you have a database named users (check with 'SHOW
DATABASES;') you can type 'USE users;' and then 'SHOW TABLES;' and
'DESCRIBE tablename;'

I Hope this helps!

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Fake Name wrote:
> Jim Pazarena wrote:
>
>> I set up a user and database without tables (a NEW user)
>>
>> then as a test, I start up mysql, select the new users' database
>> and issue:
>> show tables;
>>
>> the system responds with all the tables from the "mysql" database.
>> if I try to "use" these tables, I get error messages and don't
>> actually have access to the table structure.
>>
>> Can someone help me out on this?
>>
>> Thanks Jim
>
> You don't USE tables, you USE databases. You can DESCRIBE tables,
> though. If you have a database named users (check with 'SHOW
> DATABASES;') you can type 'USE users;' and then 'SHOW TABLES;' and
> 'DESCRIBE tablename;'
>
> I Hope this helps!
>

I got the terminology wrong. but the concept is as you describe.

basically if I have a new user, with an identically named DATABASE
and I sign on as that user and I issue:
use username; (which is the same name AS the username)
then I issue a:
show tables;
<< remember that IO just created this user & database)
the mysql system responds with the identically named tables which are
in the "mysql" database!
if I issue a "describe <table name>;" .. the mysql system responds
with all the entries which are indeed within the actual mysql table.

I got the words wrong, but the concept is that mysql seems to be
mirroring the tables of the mysql database for users which presently
have NO tables defined within their database.

Any ideas?

> basically if I have a new user, with an identically named DATABASE
> and I sign on as that user and I issue:
> use username; (which is the same name AS the username)
> then I issue a:
> show tables;
> << remember that IO just created this user & database)
> the mysql system responds with the identically named tables which are in
> the "mysql" database!
> if I issue a "describe <table name>;" .. the mysql system responds
> with all the entries which are indeed within the actual mysql table.
>
> I got the words wrong, but the concept is that mysql seems to be
> mirroring the tables of the mysql database for users which presently
> have NO tables defined within their database.
>
> Any ideas?
>
I'm not much help, but I'll tell you what I did, perhaps you can tell me
how yours is different. I just created a new user called "fakename" in
my mysql installation with the command "GRANT ALL PRIVILEGES ON *.* TO
'fakename'@'localhost' IDENTIFIED BY 'fakename';". I logged in as root
and did the following:
> CREATE DATABASE fakename;
> USE fakename;
> SHOW TABLES;
-It gave me "Empty set (0.00 sec)" as expected.
I then logged in as fakename and did the following:
> USE fakename;
> SHOW TABLES;
-It game me "Empty set (0.00 sec)" as expected.

I can't seem to reproduce your behavior. Sorry. You may want to restart
the machine and try again just to rule out the remote chance that
there's some weirdness there. After you've reproduced it, double
checking your steps, you could try the forums and mysql.com. Best of luck!

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----