Error in Database connectivity with python3.7

[srm]

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

[buran]

try

conn=pymysql.connect('localhost','root','mcse@123','mysqldb')

[srm]

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.

[buran]

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 :-)

[parthi1705]

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.

[buran]

they have both installed, but trying to connect to mysql, not mssql

[srm]

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...

[buran]

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...

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()

[srm]

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