0

this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)")
Press any key to continue . . .

from pony.orm import *
db = Database()
db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data')
4
Contributors
6
Replies
22
Views
1 Year
Discussion Span
Last Post by Stuart_4
0

Some things that can be wrong
1) That user doesn't exist
2) the username is wrong
3) the password is wrong
4) User exists but doesn't have access to that database

If you have direct access to the database you can check all of those out.

0

Hello,

If you have root access to the mysql server then you can run the following from the mysql prompt to get a list of users and permissions:

mysql> select user,host from mysql.user;

Will give you a list of users and hosts they are configured to have access from. If your user is in the list with the correct IP address then you can check the privledges with:

mysql> show grants for 'point3hu_leo'@'197.253.66.85';
0

Thanks, I've granted priviledges to the user and checked the password but I'm not sure why it still happens.

0

One other thing I will mention just in case, Is the script running from your local machine at the 197.253.66.85 address, or is it running on a server through a web browser? If it is running from w web browser then the IP addressw is the servers address or 127.0.0.1 or localhost. What will really tell you what is going on is the mysql log file. If you take a look through it you will be able to see the address that made the request as well as more information as to why it was refused (it could be the request came in under your IPV6 address not the IPV4.

0

the script is running on my pc as a python script trying to connect to server thats online. sorry for the last response

0

Some things that can be wrong 1) That user doesn't exist 2) the username is wrong 3) the password is wrong 4) User exists but doesn't have access to that database If you have direct access to the database you can check all of those out.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.