Connection attempt failed: SQLSTATE[HY000] [1044] Access denied for user

Scriptcase 8 Discussion
#1

Hello

after updating to version 8.0.0.27, I have following error message ONLY IN PROD ENV.
I think it’s because of sc_connection_edit() I use in my app for connecting to differents db?

Connection attempt failed: SQLSTATE[HY000] [1044] Access denied for user

But where do I change permissions ???
Thanks for yours help

Nac

#2

[QUOTE=nacyil;31112]Hello

after updating to version 8.0.0.27, I have following error message ONLY IN PROD ENV.
I think it’s because of sc_connection_edit() I use in my app for connecting to differents db?

Connection attempt failed: SQLSTATE[HY000] [1044] Access denied for user

But where do I change permissions ???
Thanks for yours help

Nac[/QUOTE]

I have to guess here, but it sounds to me that the connections you have to declare in production is not done right? Documentation of MySQL states that the error was introduced in MySQL 5.7.7. I don’t have the requirements at hand, but it could be that you are running a too recent version as the production version of MySQL currently is 5.6.22

#3

Hello Albert

versions are :

server linux centos 64 bits
mysql 5.5.41-37.0
php 5.4.30
apache 2.2.27

#4

Then I would check your connections in the _lib control panel. Other option could be that you have some additional access rights on your database in production and you need to grant these.

#5

Error fires after or before sc_connection_edit? If you don’t execute sc_connection_edit app works as expected?

If connection data is ok, maybe the user don’t have access over this database, you can look here

#6

Thanks Albert, Giu

I will check that