Admin creates accounts OK, but I can't do it!?!

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 425,917 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,711 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 1452 | Replies: 0

•

Join Date: Jul 2005

Location: USA

Posts: 56

Reputation: aboyd is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

aboyd

Offline

Junior Poster in Training

Admin creates accounts OK, but I can't do it!?!

Jul 26th, 2005

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):

Help with Code Tags

(Toggle Plain Text)

Host   User     Password                                  SELECT INSERT UPDATE DELETE
     mt_user   760a91110aaa0d06                           N      N      N      N
     webserver *C7AF0C4A05EEE463D5D728333C22972498888889  Y      Y      Y      Y

And here is the MySQL db table:

Help with Code Tags

(Toggle Plain Text)

Host   DB          User                             SELECT INSERT UPDATE DELETE
%     mt_tables   mt_user                           Y      Y      Y      Y
%     share_data  webserver                         Y      Y      Y      Y

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

Publisher Database - tools & forums for writers
Outshine - geek blog & free phpBB mods
What Do Women Want? - dating advice for men, from women