Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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
    Originally posted by nacyil View Post
    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
    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
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Hello Albert

      versions are :

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

      Comment


      • #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.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Originally posted by nacyil View Post
          I think it's because of sc_connection_edit() I use in my app for connecting to differents db?
          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
          /Giuseppe

          Professional Scriptcase Services
          Some Customers opinions

          Comment


          • #6
            Thanks Albert, Giu

            I will check that

            Comment

            Working...
            X