CMS Made Simple Forums

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

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

Also, is it 4.1 or 4.0?

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?

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

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.....

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.

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....

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...

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

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.

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?

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?

Nope, it's correct.

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

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