Python Forum
Error in Database connectivity with python3.7
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error in Database connectivity with python3.7
#1
I am using mysql with python 3.7.2 to get connected my database.
on my windows 2008r2 ,I have installed first sql server 2012 and later also mysql.
I want to know what would be my mysql instance name as localhost would be sql server 2012 and when I am trying to connect it ,it gives me access denied error.code is as follows:-
import pymysql
conn=pymysql.connect('localhost','root@localhost','mcse@123','mysqldb')
if not conn!=None:
    print("Connection Succeeded")
    cmd=conn.cursor()
    cmd.execute('create table emp(empid int,empname char(10))')
    conn.close()
    cmd=conn.cursor()
    cmd.execute("insert into emp values(111,'asha')")
    conn.commit()
    conn.close()
    cmd.cursor()
    cmd.execute('select * from emp')
    result=cmd.fetchall()
    for i in result:
        print(i)
        conn.close()
Thanx in adavnce
Reply
#2
try
conn=pymysql.connect('localhost','root','mcse@123','mysqldb')
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
(May-08-2019, 08:59 AM)buran Wrote: try
conn=pymysql.connect('localhost','root','mcse@123','mysqldb')

ok sir,when I tried the above mention code..there is no error or result..output is blank.
Reply
#4
check this line
if not conn!=None:
You want

if conn:
or
if conn is not None:

And as a matter of fact - you even don't need it (i.e. to check the conn object) - you will either get connected successfully or you will get exception :-)
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#5
If you are connecting to SQL Server then you have to use pyodbc

import pyodbc
server = 'server_name'
db = 'database_name'
UID = 'user_id'
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=' + server + ';DATABASE=' + db + '; UID = ' + UID + '; PWD = ' + UID + 'Trusted_Connection=yes')
or simply

import pyodbc 
conn = pyodbc.connect('Trusted_Connection=yes', driver = '{ODBC Driver 13 for SQL Server}',server = 'ServerName', database = 'DBname')
Localhost is generic hostname-----> go to run---> cmd ---> hostname ... it will display
Since you are using mysql, it should be taking its own localhost name
If you using sql server, it should be taking its own localhost name as it fetches string info from drivers.
Reply
#6
they have both installed, but trying to connect to mysql, not mssql
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#7
(May-08-2019, 10:05 AM)buran Wrote: check this line
if not conn!=None:
You want

if conn:
or
if conn is not None:

And as a matter of fact - you even don't need it (i.e. to check the conn object) - you will either get connected successfully or you will get exception :-)

It does not even go upto this line it stops at very first line of connection...is it becos there is also sql server 2012 installed on same machine which also takes first instance as localhost???not getting it...
Reply
#8
(May-09-2019, 07:32 AM)srm Wrote: It does not even go upto this line it stops at very first line of connection...is it becos there is also sql server 2012 installed on same machine which also takes first instance as localhost???not getting it...

(May-08-2019, 09:59 AM)srm Wrote: ok sir,when I tried the above mention code..there is no error or result..output is blank.

so, which of your two statements is correct?
both your databases are on localhost, just listen on different port

import pymysql
conn=pymysql.connect('localhost','root','mcse@123','mysqldb')
print("Connection Succeeded")
cmd=conn.cursor()
cmd.execute('create table emp(empid int,empname char(10))')
cmd.execute("insert into emp values(111,'asha')")
cmd.commit()
cmd.execute('select * from emp')
result=cmd.fetchall()
for row in result:
    print(row)
conn.close()
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#9
(May-08-2019, 10:05 AM)buran Wrote: check this line
if not conn!=None:
You want

if conn:
or
if conn is not None:

And as a matter of fact - you even don't need it (i.e. to check the conn object) - you will either get connected successfully or you will get exception :-)

ya I got it ,it was some internal network error with mysql and just reinstalled as it was test machine and I corrected this line of code in python and is working fine.Thanks
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Jira Connectivity Shyam 0 170 Mar-19-2024, 05:43 PM
Last Post: Shyam
  Understanding and debugging memory error crashes with python3.10.10 Arkaik 5 1,977 Apr-18-2023, 03:22 AM
Last Post: Larz60+
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,651 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  mySQL Database error not resolving. cybertooth 2 3,118 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Error creating database with python and form? shams 3 2,328 Aug-02-2021, 02:00 PM
Last Post: deanhystad
Bug maximum recursion depth exceeded while calling a Python object error in python3 Prezess 4 3,689 Aug-02-2020, 02:21 PM
Last Post: deanhystad
  import yaml error for python3 maiya 4 13,020 Jul-15-2020, 06:07 PM
Last Post: Gribouillis
  Mysql-Python Connectivity Error aryamanurs 2 3,361 Apr-29-2020, 02:21 PM
Last Post: aryamanurs
  Error in Python3.6:free() Corrupted unsorted chunks error sameer_k 2 3,798 Mar-18-2020, 09:37 AM
Last Post: sameer_k
  Error after installing Python3.8.2: "No module named 'apt_pkg'" Chromie 3 3,823 Mar-09-2020, 08:20 PM
Last Post: micseydel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020