[wplug] MySQL and phpBBS

[Bill Moran]

"Wise, Jeremey" <jeremey.wise at agilysys.com> wrote:

<snip>

> [root at venus]# mysql -u mywebsite -p mywebsite <
> /var/www/html/mywebsite/Members/BullitenBoard/phpBB2/install/schemas/mys
> ql_schema.sql
> Enter password:
> ERROR 1045: Access denied for user: 'mywebsite at localhost' (Using
> password: YES)
> [root at venus mysql]# mysql -u msdba -p mywebsite <
> /var/www/html/landofthevisigoths/Members/BullitenBoard/phpBB2/install/sc
> hemas/mysql_schema.sql
> Enter password:
> [root at venus mysql]#
> 
> ***** 
> I must be missing something simple here. I checked user permissions in
> mysql and user is listed with full rights and password has is same as
> mydba which means their the same. Under database permissions user
> 'mywebsite' is listed with full rights for the database. 
> 
> My opinion is that this is a stupid setup error on the mysql side. 
> 
> Any thoughts?

I think I finally know what's happening.  You're user permissions aren't
set up they way you think they are.

MySQL does some juggling when checking permissions to see which account
gets used when logins are attempted.  For example, you could have a
certain user with permissions and password used when logging in from
the localhost, while having another user (with the exact same name)
with completely different permissions and password that is used when
logging in from any other machine.  This is particularly likely if you
use wildcards for the hostname when creating users - wildcards aren't
always interpreted they way you would expect.  MySQL attempts to optimize
your user table.

I would suspect that your priviledge tables aren't set up to work they
way you expect.  A likely cause of this is that you have another user
that has a different password or different priviliges that's being used
instead of the account you would expect.  Possibly there's an "anyone"
at localhost account that's taking precendence?  (just a guess)

Have a read here and see if it helps:
http://dev.mysql.com/doc/refman/4.1/en/privileges.html

If you can't figure it out, feel free to post your user table (scrub the
passwords first) and I'll see if I can figure out the problem.

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com