February 1st, 2005, 01:05 AM
wx_uab - it looks like it's dead Most of the links point to one of those scum domain parking sites (seeq.com), and it apparently works on Windows 95 and 98 .
February 1st, 2005, 11:37 AM
Sorry about that , Here is the actual link
l used it really long time back for a small school project . I really helped me then.I didn't know it was dead . sorry
February 1st, 2005, 07:38 PM
Another newbie here. Ive got a python program running on my windows xp pro machine that is the same line for line as one i am running on a unix machine. If I run my program on the unix machine (which has mysql on it) it works just fine. My problem is on my windows machine.
self.connObj = Connection(user="***", passwd="*****",
is it possible to connect to this dbServer from my windows box?
the code on the linux box has 'localhost' for the host param.
Any help would be much appreciated.
February 1st, 2005, 07:48 PM
wx_uab: It does look like a cool project - hopefully they'll keep working on it.
jdvachal: The code works when it runs on the same linux machine as MySQL right? you'll need to check to see if the MySQL server will allow remote connects. The quickest way to do this is to ask the admin. The next thing you'll need to do is to make sure that your username has permission to connect from a remote host. You'll need to check MySQL's grant tables here.
February 1st, 2005, 08:10 PM
The code does work when i run it on the linux box yes.
There really isnt an admin for the database because its just a machine at the school that I run.
Here are some stats.
The column names:
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
| % | **** | *** | Y | Y | Y | Y | Y | Y | Y | Y|Y |Y|Y|Y| Y | Y|
this is the entry in the user table for the username im connecting with. So the user im connecting with is a superuser.
Im looking into whether mysql accepts incoming connections but the machine doesnt have nmap so i will try and find away around that. If its not accepting connections do you know how to enable that?
February 1st, 2005, 08:36 PM
Ok, the user can connect from anywhere ('%').
To check if MySQL accepts foreign connections run:
mysqladmin -u <user> -p variables
and look for skip_networking. You'll want this set to 'OFF'.
February 1st, 2005, 08:59 PM
skip networking is set to off. Do I need some kind of odbc driver?
February 1st, 2005, 09:11 PM
Shouldn't need one.
Ok, you should be able to connect like that, but you may need to set the port in the connection string to MySQL's port - 3306.
It may pay to replace obsidian..etc with an ip address too.
self.connObj = Connection(user="***", passwd="*****", db="**", host="obsidian.myschool.edu", port='3306')
February 1st, 2005, 09:18 PM
Still no dice,
I hate to keep bugging you but heres the dump:
Traceback (most recent call last):
File "C:\Python23\demomaint.py", line 65, in -toplevel-
app = App(root)
File "C:\Python23\demomaint.py", line 10, in __init__
File "C:\Python23\demomaint.py", line 61, in init_db
db="****", host="****", port = 3306)
File "C:\Python23\lib\site-packages\MySQLdb\connections.py", line 116, in __init__
File "C:\Python23\lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (2003, "Can't connect to MySQL server on '****' (10061)")
heres the line of code:
self.connObj = Connection(user="****",passwd="****",
db="****", host="****", port = 3306)
February 1st, 2005, 09:47 PM
There are a few threads on error 10061 in the MySQL forum - it usually happens when windows can't run MySQL, so I'm not sure why you're getting it here. I would just doublecheck to make sure MySQL is running on the remote server.
February 1st, 2005, 09:49 PM
ok mysql is running on the remote computer, i just downloaded sqlyog and it cant connect to the remote server either so i need to figure out why i cant connect to the remote box. Its probably something that needs to be set up on the other machine.
Thanks for all your help.