Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi guys Im having the following problem.
I have MySQL server installed on computer A, no problem I can do everything there I want.
Now from Computer B I want to access this server and use its database, but I have no luck in doing this.
After doing some research, I discovered you had to this to get it running remotely.
[syntax="sql"]grant select,insert,update, delete on db_name.* to user_name@computerB IDENTIFIED BY "user_password";Code: Select all
grant select,insert,update, delete on db_name.* to user_name@ipnumberofB IDENTIFIED BY "user_password";
+ "FLUSH PRIVILEGES;"Then I thought it might be a problem with my ini configuration file. Nothing there either.
All I'm doing so far is to see if I can connect to the database.
On computer A : I do this
Code: Select all
# connect
db = MySQLdb.connect(host="localhost", user="root", passwd="****",
db="test")Computer I have tried the following:
Code: Select all
# connect
db = MySQLdb.connect(host="ipaddressofcomputerA", user="root", passwd="****",
db="test")
# connect
db = MySQLdb.connect(host="nameofcomputerA", user="root", passwd="****",
db="test")No luck, does anyone have any ideas !
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]