mysql.connector shows the 'connect' module not available

You are using pyshell, not sure if that matters though.

Try using the normal python shell. I did following on Mac:

shell> python
>>> import mysql.connector as sql
>>> sql.connect(database="test")
<mysql.connector.connection.MySQLConnection object at 0x10f0c4750>
>>> sql.foo()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: 'module' object has no attribute 'foo'
>>>

Doing the above on Ubuntu 12.04 gave the same result.

Just to confirm that installing IDLE 2.7.3 on Ubuntu 12.04 I could load mysql.connector and do 'import .. as ..'

@Geert: Thanks for replying. I forgot to mention that I am using Python 3.2 and I get the same error even on terminal. Also eclipse gives the same error. Error from terminal:

Python 3.2.3 (default, Apr 12 2012, 19:08:59)
[GCC 4.6.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector as sql
>>> sql.connect(database="test")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: 'module' object has no attribute 'connect'
>>>

I confirm that it works with python 2.7 on terminal, IDLE2.7 and Eclipse.

The problem is that with python3.2 I am being able to import it successfully but while connecting it gives the error:

AttributeError: 'module' object has no attribute 'connect'

Awaiting reply

Atul

@Geert: Just to mention that I am using the most latest build from the 'Launchpad'.

Atul

@Geert: I have fixed the problem. The files under 'mqsql>connector' directory had only write permissons for 'user' so changing the permissions to read and execute solved the issue.

I am not sure why the permissions were screwed as I was just installing the normal way it worked before on ubuntu11.10.

Thanks

Atul