•
•
•
•
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.
Please support our MySQL advertiser: Programming Forums
Views: 1452 | Replies: 0
![]() |
| |
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
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- ..But I Am The Admin! (Windows NT / 2000 / XP / 2003)
- Reputation points (Geeks' Lounge)
- Does anyone know any Clarion Forums? (Legacy and Other Languages)
- WMP 10 can't rip CD from Limited User accounts (Windows Software)
- question about connecting odbc to sql through php script (PHP)
- How involved should an admin be? (Growing an Online Community)
- On Man, One Machine and 5 User Accounts (Windows NT / 2000 / XP / 2003)
- ie6 (winxp-peo) problem (Web Browsers)
Other Threads in the MySQL Forum
- Previous Thread: new to mySQL
- Next Thread: Error with Update


Hybrid Mode