•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,686 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 3,209 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:
Views: 590 | Replies: 4 | Solved
 |
| |
•
•
Join Date: Aug 2007
Posts: 147
Reputation: 
Rep Power: 0
Solved Threads: 0
Junior Poster
Hi.
I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong?
I dont know why it is not working on two tables???
I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong?
GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';
I dont know why it is not working on two tables???
•
•
Join Date: Aug 2007
Posts: 147
Reputation:
Rep Power: 0
Solved Threads: 0
Junior Poster
Hi.
any idea ???
any idea ???
•
•
Join Date: Dec 2007
Posts: 107
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
what is the error message?
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
hi tanha,
standard SQL only allows one object per GRANT command. Possibly MySql also does not allow enumerative objects. If so, you should try
krs,
tesu
standard SQL only allows one object per GRANT command. Possibly MySql also does not allow enumerative objects. If so, you should try
sql Syntax (Toggle Plain Text)
krs,
tesu
Last edited by peter_budo : May 24th, 2008 at 6:49 pm. Reason: Keep It Organized - please use [code] tags
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Hybrid Mode
Similar Threads
- php script for dropdown to fetch DB list and then Tables (PHP)
- Unable to delete SQL records (MS SQL)
- phpmyadmin issue (PHP)
- mysql_server_phpmyadmin_access denied (Linux Servers and Apache)
- MySQL. Setup? (MySQL)
- How Do You Connect MySQL to localhost? (MySQL)
- DB-Authentication php/mysql on Mac OSX v3 (PHP)
Other Threads in the MySQL Forum
- Previous Thread: adodb autoexecute
- Next Thread: automating querys
