[Level 3] Install Python MySQLdb.

When you want to write a Python program to connect to MySQL database,
there is a useful API for Python to connect database, called "MySQLdb".
There are the steps for you to install the package:

1. Download setuptools:
# wget -q http://peak.telecommunity.com/dist/ez_setup.py
# python ez_setup.py

2. Download MySQLdb from SourceForge:

3. Build MySQLdb and install it: (I download MySQLdb version for 1.2.3c1)
# gunzip -c ./MySQL-python-1.2.3c1.tar.gz | tar xvf -
# cd ./MySQL-python-1.2.3c1
# python setup.py build
# python setup.py install

4. Prepare Python script.
testMySQLdb.py:
#!/usr/bin/python
import MySQLdb
cxn = MySQLdb.connect(host='localhost', db='test', user='root', passwd='admin123' )



## execute command only
cxn.query("grant all on test.* to 'stanley'@'localhost' identified by 'stanley123'")
cxn.query("drop user 'stanley'@'localhost'")


## query from databas


## no query attribute for cursor
#cur.query("select user,host,password from mysql.user") 

cur = cxn.cursor()
cur.execute("select user,host,password from mysql.user")
for data in cur.fetchall():
  #print(data[0],data[1],data[2])
  print(data[0],data[1])
cxn.close()

5. Run it.
# ./testMySQLdb.py
('root', 'localhost', '')
('root', 'localhost.localdomain', '')
('root', '127.0.0.1', '')
#

Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more