You will have to add a user to the database, and then log in as that user from your PC. When you add the user, you put an IP address with it. Read the "GRANT" statement syntax documentation on mySQL's website. If you have the database hosted on a server with CPanel, you can add your IP address to the "Access Hosts" section, AT THE BOTTOM OF THE MYSQL ADMINISTRATION SCREEN. Then, just log in with the user name and password that you normally connect to the database with. On Sun, Mar 1, 2009 at 5:06 PM, arvindsri123 <arvindsri123@xxxxxxxxx> wrote: > Hello, > > Thanks for reply... > > I didn't get u properly.. > > I am telling u what i have... > > I have a DB which is hosted on server, what i want to update > DB/Table/Data from local PC, I have My CP userid, Pass and also have > db id/pass... > > now please tell me exactly where to go and where exactly i need make > changes.. > > I will be really thank full to you.. > > As I am not a expert..but i want to do this..please help. > > Thanks, > Arvind > > --- In php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>, Brian > H <brianh781@...> wrote: > > > > If it's a CPanel host, you can add an access host at the bottom of > the mySQL > > administration page. Add your ip there and then connect with your > client > > using your domain name as the host. > > > > If you have a dynamic IP, you'll have to change it each time your IP > > changes, or, if it's always within the same class C group, you can add > > something like: > > > > 77.123.123.% > > > > With % being the wildcard. Of course, the more of a the IP you make > as a > > wildcard, the more of a security issue you will be opening up. > > > > > > > > On Sun, Mar 1, 2009 at 4:38 PM, arvindsri123 <arvindsri123@...> wrote: > > > > > Hi All, > > > > > > Can i update a online hosted DB from local PC ? any idea any > > > suggestion, please share with me.. > > > > > > Thanks, > > > Arvind > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed]
