PHP 5.1.4 + MySQL 4.1 + coppermine 1.4.8 installation problem

[SoR]

Hello, I've problem with install coppermine gallery on my FreeBSD BOX, after set right permission to dirs (as the installation script say) I've error with connect to MySQL:

Could not create a mySQL connection, please check the SQL values entered
MySQL error was : Access denied for user 'sor'@'localhost' (using password: NO)

but I set password in the right form at install script. In mysql logs I've the same problem (install script don't use password). I have in php.ini register_long_arrays = On and I try with Safe_mode = Off and On . Can somebody help?

Greetings

[Sami]

the error said that sor as a mysql user didn't have permission to coonet to he mysql server,
- check the username under include/config.inc.php & your mysql server
- set a password for that user and put it under include/config.inc.php
- check the privilage of the sor under mysql server

[SoR]

the error said that sor as a mysql user didn't have permission to coonet to he mysql server,
- check the username under include/config.inc.php & your mysql server
- set a password for that user and put it under include/config.inc.php

It's correct

- check the privilage of the sor under mysql server

It's correct, and I've still have this error :/

[Joachim Müller]

Ask your webhost for support then. If you're self-hosted, you at least know who to address

[SoR]

Ask your webhost for support then. If you're self-hosted, you at least know who to address

I'll try to solve this problem, but I don't have any idea where is the problem :/

[Sami]

The problem is your mysql user
as I said before check it under your hosting control panel ,
check the username , password and privileges
post a link to your gallery may help us ...

[SoR]

The problem is your mysql user
as I said before check it under your hosting control panel ,
check the username , password and privileges

Using mysql -u sor -p (and type my password) I can connect to my mysql server and I can use my gallery database (or when I use phpmyadmin I can do the same things) but using gallery I can't connect. Tommorow I can give you a link.
Thanks for help,
Greetings

[donnoman]

The problem is most likely the new defaults for MySQL is to use the new password encryption schemes. PHP (AFAIK) doesn't have the newer mysql client built in unless you are using mysqli (which coppermine doesn't use).

There is a way to disable the new password encryption on mysql (you have to recreate your user).

Theres also a method to set the old password encryption per user with an sql statement executed from the CLI.

Check documentation regarding password encryption problems and clients on the mysql site.