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
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
Quote from: bmossavari on August 12, 2006, 04:27:15 PM
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
Quote
- check the privilage of the sor under mysql server
It's correct, and I've still have this error :/
Ask your webhost for support then. If you're self-hosted, you at least know who to address ;)
Quote from: GauGau on August 13, 2006, 08:21:51 AM
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 :/
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 ...
Quote from: bmossavari on August 13, 2006, 06:19:31 PM
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
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.