Re: MySQL 4.x questions...
From: Andrew Boothman (andrew_at_mux.org.uk)
Date: 01/30/04
- Previous message: Zhang Weiwu: "need suggestions on making a wireless network using bluetooth."
- In reply to: Eric F Crist: "MySQL 4.x questions..."
- Next in thread: Peter Risdon: "Re: MySQL 4.x questions..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 30 Jan 2004 06:09:22 +0000 To: ecrist@adtechintegrated.com
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.
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
- Previous message: Zhang Weiwu: "need suggestions on making a wireless network using bluetooth."
- In reply to: Eric F Crist: "MySQL 4.x questions..."
- Next in thread: Peter Risdon: "Re: MySQL 4.x questions..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
