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


Messages In This Thread
Error in Database connectivity with python3.7 - by srm - May-08-2019, 08:57 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Jira Connectivity Shyam 1 354 Apr-17-2024, 08:55 AM
Last Post: Abhishikt
  Understanding and debugging memory error crashes with python3.10.10 Arkaik 5 2,203 Apr-18-2023, 03:22 AM
Last Post: Larz60+
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,751 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  mySQL Database error not resolving. cybertooth 2 3,270 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Error creating database with python and form? shams 3 2,406 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,811 Aug-02-2020, 02:21 PM
Last Post: deanhystad
  import yaml error for python3 maiya 4 13,235 Jul-15-2020, 06:07 PM
Last Post: Gribouillis
  Mysql-Python Connectivity Error aryamanurs 2 3,509 Apr-29-2020, 02:21 PM
Last Post: aryamanurs
  Error in Python3.6:free() Corrupted unsorted chunks error sameer_k 2 3,930 Mar-18-2020, 09:37 AM
Last Post: sameer_k
  Error after installing Python3.8.2: "No module named 'apt_pkg'" Chromie 3 3,928 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