MySql Python连接

$ mysql -u root
ERROR 1045 (28000): Access denied for user \'root\'@\'localhost\' (using password: NO)
$ mysql -u root -p
Enter password: 
<typing password>
Welcome to the MySQL monitor.  Commands end with ; or \\g.
Your MySQL connection id is 47
Server version: 5.1.37-1ubuntu5.5 (Ubuntu)

Type \'help;\' or \'\\h\' for help. Type \'\\c\' to clear the current input statement.

mysql> 

$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user \'root\'@\'localhost\' (using password: YES)

GRANT ALL PRIVILEGES ON *.* TO root@\'%\' IDENTIFIED BY \"YOUR_ROOT_PASSWORD\";
FLUSH PRIVILEGES;

import MySQLdb

cxn = MySQLdb.connect(host = \'localhost\',user = \'root\',passwd = \'password\', db = \'yourdatabase\')

CREATE DATABASE yourdatabase;

[mysql]
username: \'uuuu\'
password: \'pppp\'
host: \'localhost\'
database: \'dddd\'

[mysql]
username: uuuu
password: pppp
host: localhost
database: dddd

SELECT user, host, password FROM mysql.user;

import MySQLdb

db = MySQLdb.connect(host=\"localhost\",    # your host, usually localhost
                     user=\"root\",         # your username
                     passwd=\"\",           # your password
                     db=\"dynamo\",
                     port = 3306)         # name of the data base

# you must create a Cursor object. It will let
#  you execute all the queries you need
cur = db.cursor()

# Use all the SQL you like
cur.execute(\"select * from SomeTable limit 10\")

# print all the first cell of all the rows
for row in cur.fetchall():
    print(row[0])

db.close()