Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL Connection Error

Options
  • 12-01-2016 11:53pm
    #1
    off.the.walls
    Registered Users Posts: 1,298 ✭✭✭


    Hi Guys and Gals,

    I'm using blacknight hosting and have a db that i've allowed access from external hosts and added my ip for access users to be allowed access it and am still getting the following error.

    (pymysql.err.OperationalError) (1045, \"Access denied for user 'x')

    I tried this with PHP's Laravel and it was also denying me access to it. Anyone know how to fix this as its currently wrecking my head!
    Tagged:


Comments

  • Options
    #2
    Graham
    Moderators, Society & Culture Moderators Posts: 17,642 Mod ✭✭✭✭Graham


    Make sure you're connecting to the external hostname.

    Check your database credentials using phpmyadmin from your control panel.

    What are you trying to do?


  • Options
    #3
    off.the.walls
    Registered Users Posts: 1,298 ✭✭✭off.the.walls


    Graham wrote: »
    Make sure you're connecting to the external hostname.

    Check your database credentials using phpmyadmin from your control panel.

    What are you trying to do?

    Hi Graham,

    double and triple checked everything with it am trying to connect an sqlalchemy instance on flask to a mysql db.


  • Options
    #4
    Graham
    Moderators, Society & Culture Moderators Posts: 17,642 Mod ✭✭✭✭Graham


    Try installing a MySQL gui on your local machine and connect from that to test, at least you'll rule out code issues.

    http://www.heidisql.com/ For Windows
    http://www.sequelpro.com For Mac

    If you're using Laravel, use homestead. It will make your job 10 times easier.


Advertisement