Please support our MySQL advertiser: Programming Forums
Views: 1507 | Replies: 0
 |
•
•
Join Date: Jul 2005
Location: USA
Posts: 56
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
I work with a server admin. He created an account on MySQL and it works just fine. I created another account to access a different database, but it will not work. Can anyone tell me why? I've done "FLUSH PRIVILEGES" about a million times now. Here is the MySQL user table (password field munged a bit to protect the innocent):
And here is the MySQL db table:
Does anyone see anything in that? Can anyone suggest other reasons why I might be able to connect with one login string, but not the other? Also, an important note: both accounts work if I telnet in and login to MySQL from the command line. But with PHP, only the "mt_user" account works.
-Tony
Host User Password SELECT INSERT UPDATE DELETE
mt_user 760a91110aaa0d06 N N N N
webserver *C7AF0C4A05EEE463D5D728333C22972498888889 Y Y Y YHost DB User SELECT INSERT UPDATE DELETE % mt_tables mt_user Y Y Y Y % share_data webserver Y Y Y Y
-Tony
Publisher Database - tools & forums for writers
Outshine - geek blog & free phpBB mods
What Do Women Want? - dating advice for men, from women
Outshine - geek blog & free phpBB mods
What Do Women Want? - dating advice for men, from women
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
