A combination of Python and MySql - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: A combination of Python and MySql (/thread-9221.html) |
A combination of Python and MySql - xgrzeniu - Mar-27-2018 Hello,, I am not sure if I have started this topic in the right place, if not, please move it. I have a problem with the connection between Python and the MySQL database. When debugging the code import mysql.connector con = mysql.connector.connect(user='admin',password='admin123',host='127.0.0.1',port='3306',database='admin') Traceback (most recent call last): File "C:\Users\Asus\Desktop\1.py", line 6, in <module> db = pymysql.connect("127.0.0.1","admin","admin123","admin" ) File "D:\Python33\lib\site-packages\pymysql\__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "D:\Python33\lib\site-packages\pymysql\connections.py", line 699, in __init__ self.connect() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 936, in connect self._request_authentication() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 1156, in _request_authentication auth_packet = self._read_packet() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 1018, in _read_packet packet.check_error() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 384, in check_error err.raise_mysql_exception(self._data) File "D:\Python33\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'admin'@'localhost' (using password: YES)")I also tried importing pymysql and the effect was also the same import pymysql db = pymysql.connect("127.0.0.1","admin","admin123","admin" ) cursor = db.cursor() Traceback (most recent call last): File "C:\Users\Asus\Desktop\1.py", line 5, in <module> db = pymysql.connect("127.0.0.1","admin","admin123","admin" ) File "D:\Python33\lib\site-packages\pymysql\__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "D:\Python33\lib\site-packages\pymysql\connections.py", line 699, in __init__ self.connect() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 936, in connect self._request_authentication() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 1156, in _request_authentication auth_packet = self._read_packet() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 1018, in _read_packet packet.check_error() File "D:\Python33\lib\site-packages\pymysql\connections.py", line 384, in check_error err.raise_mysql_exception(self._data) File "D:\Python33\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'admin'@'localhost' (using password: YES)")The password and login match. Are you able to tell me something in the topic, I'm fighting the second day and I do not know what the problem may be? I will also swear that I am a layperson when it comes to python. I'm just learning it. If this is the essence of information, then the server I have placed on a virtual machine on which Debian9 is installed, while python 3 works on windows7. RE: A combination of Python and MySql - woooee - Mar-28-2018 The error message says that your user doesn't have permission to access the database. You will either have to sign in with a user who does have permission, or get your user added the database's group, with read permission, and write permission if you want to change the database. RE: A combination of Python and MySql - xgrzeniu - Mar-28-2018 in php my admin has permission granted to admin, ALL PRIVILEGES permission, User account 'admin' @ 'localhost' Can you throw sreens here? |