List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 17 2003 9:45pm
Subject:Re: odd user/permissions/table access problem
View as plain text  
At 12:10 -0800 3/17/03, Mike Whybark wrote:
>I just upgraded to
>
>mysqladmin  Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc
>
>from 3.23.52. Both packages are via Marc Liyanage's binary 
>distribution from http://www.entropy.ch/.
>
>following the upgrade, one (and only one) of the databases is 
>affected such that its' user access is disrupted.
>
>---
>Error (1044) : Access denied for user: 'primaryuser@localhost' to 
>database 'primaryuserdatabase'
>---
>
>root-level or widely privileged users can access the database 
>without difficulty.
>
>if a given user, with tight access to another database, is granted 
>access to the database, the granted access will not work, and the 
>user access request will generate this error:
>
>---
>Error (1044) : Access denied for user: 'alternateuser@localhost' to 
>database 'primaryuserdatabase'
>---
>
>I've established to my own satisfaction that this problem is 
>specific to primaryuserdatabase; however, I don't understand why 
>top-level users with global privs can access the database when the 
>restricted users cannot.

Is the primaryuser account specified with Host value in the user table?
And after the upgrade do you have an entry in the user table that has
Host = localhost and User = blank?

>
>please advise, and feel free to request more data. Thank you for your time!
>--
>Mike Whybark - mike@stripped
>http://mike.whybark.com/


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
odd user/permissions/table access problemMike Whybark17 Mar
  • Re: odd user/permissions/table access problemPaul DuBois17 Mar