Thanks for this, I may well need additional privileges, but I can't see how I can change these on the remote server without connecting first!
Julia gerald_clark wrote: > Check the section of the manual covering the privilege system, > especially the "GRANT" command. > > Julia Maddocks wrote: > > >I would like to connect to MySQL database on a remote server using > >either the command prompt or MySQLFront. > > > >I have the IP address, username, password but I can't connect. > > > >MySQLfront just hangs when I enter all the information > > > >If I type the following at the command prompt, in this example I'm using > >username for the user name, and 66.66.66.66 for the IP address > >(although I use real values) > > > >mysql -h 66.66.66.66 -u username -p > > > >it asks for my password then goes off and thinks for a while before > >coming back with: > > > >ERROR 2003 - can't connect to MySQL server on 'ip address' (port) > > > >any ideas? > > > >Julia > > > > > > -- -- Julia Maddocks O O O O O O O \|/ \|/ \|/ \|/ \|/ \|/ \|/ / \ / \ / \ / \ / \ / \ / \ National Development Officer The Playwork Unit at SPRITO phone: 01865 247499 mobile: 07803 044986 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
