Databases :: MySql :: user with all privileges EXCEPT to 'mysql' db |
|||
By: Squibi  |
Date: 17/04/2003 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
Is it possible to create a user account with all privileges on all databases EXCEPT 'mysql' database, and no need to further update this acount's privileges even if a new database is created later on? the following does NOT work GRANT ALL PRIVILEGES ON *.* TO myNewAdminUser@localhost IDENTIFIED BY 'myAdminPassword'; |
|||
| By: VGR | Date: 17/04/2003 19:04:00 | |
Type : Comment |
| no it's either : GRANT ALL PRIVILEGES ON database.* TO... and he'll be unable to access new databases or GRANT ... *.* and he'll access mysql I suggest the first solution |
|||
| By: Squibi | Date: 17/04/2003 19:10:00 | |
Type : Comment |
| ok but what if u give a user the CREATE privilege...how do u specify between being able to create new databases and being able to create new tables inside that specific database? |
|||
| By: VGR | Date: 17/04/2003 21:46:00 | |
Type : Answer |
| I think CREATE privileges apply inside the specified databases, so it's either a closed list or * Only *.* will enable to create a new database |
|||
| By: Squibi | Date: 17/04/2003 22:01:00 | |
Type : Comment |
| hum....there are so many features mySQL doesnt have which would be so easy to add... |
|||
| By: VGR | Date: 17/04/2003 22:31:00 | |
Type : Comment |
| yes, but I really don't think they are necessary at all, not even useful 8-) database "users" are usually just used by front-endscripts, so you need one user, and very restricted privileges... |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
