Connection failure Installing the DB

Frouck · Post by **Frouck** » Thu Dec 02, 2004 5:08 pm

Hello,

I 've just tried several times to install cmsmadesimple on my Mac.
But at step 2, to create the database I get the message "connection failed".
Or:
Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: YES) in /Library/Apache2/htdocs/cmsmadesimple/adodb/drivers/adodb-mysql.inc.php on line 339
Connection failed
My DB_username is correct and my password also.
Database host port : 3306

Must be right I guess??
Anyone who knows what is going wrong?

Greetz Frouck

Ted · Post by **Ted** » Thu Dec 02, 2004 6:09 pm

Are you using the OS X mysql package, or installed from fink? I'll try to recreate it if possible.

Ted · Post by **Ted** » Thu Dec 02, 2004 6:11 pm

Also, is it 4.1 or 4.0?

Frouck · Post by **Frouck** » Thu Dec 02, 2004 6:22 pm

It's 4.0.15

And your first question....I really don't know.
Someone re-installed and configured php and I think sql and so on....how and where I don't know!

PHP, apache and sql are running fine!

What can be the problem?

Ted · Post by **Ted** » Thu Dec 02, 2004 6:38 pm

When you open up your HD from the desktop, is there an sw directory after Library and before System?

Frouck · Post by **Frouck** » Thu Dec 02, 2004 6:59 pm

What does it stand for 'sw'? because my maps are written in Dutch, not in English.
Anyway I don't see a sw-directory between the maps Library and System on my HD.....

Ted · Post by **Ted** » Thu Dec 02, 2004 7:03 pm

It's short for software. It's default directory that fink puts it's files in, so I'm assuming that you have the OS X install from the Mysql site. I'll install it tonight and see if I can figure out why it's not connecting.

Frouck · Post by **Frouck** » Thu Dec 02, 2004 7:16 pm

Hey wishy,

From my system-preferenses / sql windows it looks like the sql-package comes from serverlogistics.com...
I can't find a directory 'sw' or software and because everything is running fine now...I'd rather not change anything now....cannot risk anything now.
Do you have any idea what this problem might be?
I saw an earlier post with the same problem....

Ted · Post by **Ted** » Thu Dec 02, 2004 7:19 pm

My hunch is that it's setup not to be listening on a network connection (port 3306) and instead just doing a socket. I need to see how the default install on OS X is configured to be sure if that's it or not...

Frouck · Post by **Frouck** » Thu Dec 02, 2004 7:23 pm

How and where can I look for it myself???

Ted · Post by **Ted** » Thu Dec 02, 2004 7:25 pm

Search for the my.cnf file

In it, there should be a [client] section with port and socket options in it. Make sure port isn't commented out and is set to 3306.

Frouck · Post by **Frouck** » Thu Dec 02, 2004 7:50 pm

These are the files that I can find:

my-small.cnf
my-medium.cnf
my-large.cnf
my-huge.cnf
my-small.cnf
my-medium.cnf
my-huge.cnf
my-small.cnf
my-medium.cnf
my-large.cnf
my-huge.cnf
my-large.cnf

Some of these files are in: library/mysql/share/mysql
and some are in library/php4/ ....
Wich one should I choose?

Frouck · Post by **Frouck** » Thu Dec 02, 2004 8:21 pm

I've looked in all these files and in all of them the port is set to 3306
and they all have this:

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
Maybe the password should'nt be commented out either?

Ted · Post by **Ted** » Thu Dec 02, 2004 8:27 pm

Nope, it's correct.

This is gonna be a tough one to track down, I think.

Frouck · Post by **Frouck** » Thu Dec 02, 2004 8:50 pm

DAMN!! haha, thanks anyway..
and if you come up with anything.......