How to connect the MYSQL database to Python program?

[Igor Korot]

 Hi,

On Fri, Dec 11, 2015 at 2:00 PM, ICT Ezy <ictezy at gmail.com> wrote:
> On Friday, December 11, 2015 at 10:52:49 AM UTC-8, Larry.... at gmail.com wrote:
>> On Fri, Dec 11, 2015 at 1:36 PM, ICT Ezy <ictezy at gmail.com> wrote:
>> > On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote:
>> >> On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ictezy at gmail.com> wrote:
>> >> > Pl explain me how to connect the MYSQL database to Python program?
>> >>
>> >> You start by looking for a module that lets you do that. You can use
>> >> your favourite web search engine, or go directly to PyPI.
>> >>
>> >> Then you learn how to use that module, including learning SQL if you
>> >> don't already know it.
>> >>
>> >> ChrisA
>> >
>> > Now, I installed MYSQLDB and following code was done correctly.
>> >
>> > #!/usr/bin/python
>> >
>> > import MySQLdb
>> >
>> > # Open database connection
>> > db = MySQLdb.connect("localhost","TESTDB")
>>
>> The connect should look like this:
>>
>> db= MySQLdb.connect(host, user, passwd, db)
>>
>> Or to be clearer:
>>
>> db= MySQLdb.connect(host="localhost", user="user", passwd="password",
>> db="TESTDB")
>
> if there was error generated, i remove password and user
>
>>>> db= MySQLdb.connect(host="localhost", user="testuser", passwd="test123",db="TESTDB")
>
> Traceback (most recent call last):
>   File "<pyshell#147>", line 1, in <module>
>     db= MySQLdb.connect(host="localhost", user="testuser", passwd="test123",db="TESTDB")
>   File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
>     return Connection(*args, **kwargs)
>   File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 193, in __init__
>     super(Connection, self).__init__(*args, **kwargs2)
> OperationalError: (1045, "Acc\xe8s refus\xe9 pour l'utilisateur: 'testuser'@'@localhost' (mot de passe: OUI)")
>>>>

Is the account testuser exist? Does it have a password "test123"?
But more imp[ortantly - this does not have anything to do with Python.

Start by trying to connect from mySQL and try to execute some
insert/update/delete statement.

Then when you succeed, start writing python code.

Thank you.

> pl check it
> --
> https://mail.python.org/mailman/listinfo/python-list