SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast ebuydrum's Avatar
    Join Date
    Jan 2001
    Location
    Berkshire UK
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi
    I've been working through the sitepoint My SQL/PHP tutorial. I signed up at F2S for a free database but I can't access it. This is what I type when I load up My SQL.exe on my desktop computer.

    mysql> mysql -h <db.whatprinter.f2s.com> -u <ebuydrum> -p;

    This is the error

    "error 1064: you have an error in your SQL syntax near 'mysql -h <db.whatprinter.f2s.com> -u <ebuydrum> -p;' at line 1"

    Sorry if there is a really obvious mistake but this is my 1st time.

    Please help

    Nick

  2. #2
    Not Bad, eh? Justin Sampson's Avatar
    Join Date
    Aug 2000
    Location
    N.S., Canada
    Posts
    487
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well as far as I know you can only use mysql.exe for working on databases on localhost.

    If you are on Windows 98 click Start(at the bottom left), click run then type "telnet" without the quotes.

    Click connect->remote system and type in the the host name as db.whatprinter.f2s.com the port should be telnet and termtype vt100.

    It should connect and then you type in your user name(probably the one you use to log into your control panel) and your password then type:

    mysql -h db.whatprinter.f2s.com -u ebuydrum -p

    then your password. You will probably have to type:
    use whateveryourdbnameis;

    then your on your way

    Good luck!
    Last edited by Justin Sampson; Feb 22, 2001 at 15:24.

  3. #3
    SitePoint Enthusiast ebuydrum's Avatar
    Join Date
    Jan 2001
    Location
    Berkshire UK
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried but it came up with an error message could not connect to db.whatprinter.f2s.com. Any ideas?

  4. #4
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I spoke to Nick in private email about this issue. It seems he was logging into mysql.exe on his local machine and then trying to type the above command to connect to the f2s server.

    I think we've got it sorted out.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •