Date: Fri, 30 Jan 2004 06:09:22 +0000 From: Andrew Boothman <andrew@mux.org.uk> To: ecrist@adtechintegrated.com Cc: freebsd-questions@freebsd.org Subject: Re: MySQL 4.x questions... Message-ID: <4019F512.2060806@mux.org.uk> In-Reply-To: <200401292328.20454.ecrist@adtechintegrated.com> References: <200401292328.20454.ecrist@adtechintegrated.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@host. Note that MySQL defines user@localhost and user@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4019F512.2060806>