MySQL 4.x questions...

[Andrew Boothman]

Eric F Crist wrote:

> Hey all,
> 
> I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB 
> bulletin board system.  For the life of me, I can't get a database setup for 
> either of them to use.  Both users groups tell me that there's a mysql 
> problem with configuration.  Here are the errors:
> 
> phpBB:
> 
> Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource 
> in /www/seccomp/htdocs/phpBB2/db/mysql4.php on line 330
>  
>  Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource 
> in /www/seccomp/htdocs/phpBB2/db/mysql4.php on line 331
>  phpBB : Critical Error 
> 
>  Could not connect to the database 
> 
> PostNuke:
> 
> No database made.Error connecting to db
> Program: /www/seccomp/htdocs/pn/install/db.php - Line N.: 45
> Database: seccomp-nuke
>  Error (1044) : Access denied for user: '@localhost' to database 
> 'seccomp-nuke'
> 
> Can someone tell me what I need to setup to get this working right?  I've been 
> feeling pretty worthless with this stuff lately.  I've never needed this much 
> help.  Maybe I'm just trying to do too much at once?

It's some kind of permissions problem. For some reason user accounts and 
permissions are surprisingly difficult to get right in MySQL.

The fact that you get "Access denied for user" means that a connection 
is being opened, but that it couldn't be authenticated.

You need to check the DB-related settings in your applications. Check 
you have supplied the correct usernames and passwords.

Really - there's no substitute for seriously reading and digesting 
<http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Privilege_system>. 
There's a lot of information on there but it's really quite a 
complicated issue.

The thing to look for is whether you've granted the correct rights to 
the correct user at host. Note that MySQL defines user at localhost and 
user at my.hostname to be different things. If I remember correctly, 
connecting using the unix socket (not the networking TCP socket) will 
show as @my.hostname while connecting to the TCP socket on 127.0.0.1 
will show as @localhost.

I find it difficult everytime I set up a new application using MySQL 
myself. But it is possible to get your head around it!

Best of luck.