niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » MySQL
Permissions Weirdness
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Barry
*nix forums Guru Wannabe


Joined: 10 Jul 2005
Posts: 149

PostPosted: Fri Jul 21, 2006 9:57 am    Post subject: Re: Permissions Weirdness Reply with quote

Chris White schrieb:
Quote:
Normally I try to be as descriptive as possible with subject lines but.. not
quite sure what else to call it.

So basically, I was given ALL access by our sysadmin to a particular database.
Now, somehow I was able to create a database and use it! It's my
understanding that there is nothing grantable with all that would allow this
(correct me if I'm wrong).

Then to make it even better, whenever I access/run whatever on the database,
permissions get totally whack and nothing can login anymore. I'd love to
google this but am not quite sure where to even start. Thanks ahead of time
for any ideas.

mysql 5.0.22-standard
There is a difference on User GRANTS and Table GRANTS.


Mixed this up probably?

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Chris White
*nix forums beginner


Joined: 21 Apr 2006
Posts: 43

PostPosted: Tue Jul 18, 2006 7:17 pm    Post subject: Permissions Weirdness Reply with quote

Normally I try to be as descriptive as possible with subject lines but.. not
quite sure what else to call it.

So basically, I was given ALL access by our sysadmin to a particular database.
Now, somehow I was able to create a database and use it! It's my
understanding that there is nothing grantable with all that would allow this
(correct me if I'm wrong).

Then to make it even better, whenever I access/run whatever on the database,
permissions get totally whack and nothing can login anymore. I'd love to
google this but am not quite sure where to even start. Thanks ahead of time
for any ideas.

mysql 5.0.22-standard
--
Chris White
PHP Programmer/DBouncingAtTheClub
Interfuel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Fri Nov 21, 2008 11:42 pm | All times are GMT
navigation Forum index » Databases » MySQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Spontaneously changing file ownerships and permissions jwwarrenva@gmail.com Solaris 7 Fri Jul 21, 2006 12:24 am
No new posts changing inode permissions <cus@oceanwave.com> Solaris 11 Thu Jul 20, 2006 11:07 pm
No new posts Checking File permissions Anoop python 1 Thu Jul 20, 2006 1:19 pm
No new posts Checking File permissions Anoop python 1 Thu Jul 20, 2006 1:19 pm
No new posts Checking File permissions Anoop python 2 Thu Jul 20, 2006 1:19 pm

Mortgages | Debt Consolidation | Online Advertising | Car Finance | Mortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.2882s ][ Queries: 20 (0.1668s) ][ GZIP on - Debug on ]