Posted by "bruce" on 10/21/87 11:26

hi...

i have a situation with a server that i have. i have mysql installed with
php..

the mysql is V4.1.12. i'm trying to see/view a database from the command
line and i can't see it when i login to mysql as root. i also can't see it
when i try to login to mysql as the given user.

from the php app, i see that the app makes a valid connection using:
host = 192.168.1.foo
dbname = cat
user = dog
passwd = dog

i've tracked the code, it's making the connection, and interfacing with the
database/tables...

however, when i try to access the db as either root/dog, i can't see the
database 'cat'
mysql -udog -pdog -h192.168.1.foo
mysql -uroot -p

neither one of these approaches sems to work, ie, i can't see the 'cat'
database in the mysql list of tables...

any idea what's going on...

when i get into mysql as root, i can see/manipulate all the other databases.

thanks for any pointers/thoughts/etc...

searching google hasn't led to any solid solutions..

thanks

-bruce
bedouglas@earthlink.net

• Next in forum: Re: [PHP] Best way to mass mail
• Prev in forum: RE: [PHP] confirmation email script/code
• Thread view: hidden database issue????

[Reply to this message]