#1
  1. No Profile Picture
    eddie
    Guest
    Devshed Newbie (0 - 499 posts)
    Wondering whether anyone knows how to
    test and debug mysql offline. The mysql is
    running ok, but it requires an active
    Internet connection, which i think is a
    bit of a waste. My environment is apache+win95+php and i'm on a single computer with a dial-up connection.

    I appreciate your responses.
  2. #2
  3. No Profile Picture
    jorgerpo
    Guest
    Devshed Newbie (0 - 499 posts)
    Hello Eddie

    I use that combo too, and working properly. I think the answer is as simple as this: Use Navigator instead of IE and put it in online mode.

    I hope it works for you too.
  4. #3
  5. No Profile Picture
    eddie
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi all,

    Thanks for your reply Jorgerpo. I'm sorry perhaps i was not specific enough.

    I find that when i'm not connected to the Internet, and i try to log on to MySql as follows, in dos mode:

    mysqlbin>mysqld
    mysqlbin>mysql
    ERROR 2005:Unknown MySql Server Host (localhost) (0)

    This error does not appear, if i have an active Internet connection. With an active Internet connection, MySql logs on normally.

    Is there a way to inform MySql that the localhost is 127.0.0.1 ? Or some other method, so that it does not need an active online port.

    Thanks appreciate your responses.
  6. #4
  7. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    Do you have Apache started /before/ you start mysql?
  8. #5
  9. No Profile Picture
    eddie
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi all,


    Thanks rod k for your reply. I've tried to launch apache before starting mysql, but still get the same error message.

    Perhaps it's not the browser being netscape or the apache server, it could be a directive
    to mysqladmin. Any ideas?

    Thanks.
  10. #6
  11. No Profile Picture
    Eric Imboden
    Guest
    Devshed Newbie (0 - 499 posts)
    Eddie,

    I had the same problem...I finally figured out that you have to start the mysql client like so:

    > mysql -h 127.0.0.1 -u root

    Hope this works for you.

    Eric
  12. #7
  13. No Profile Picture
    markdrayton
    Guest
    Devshed Newbie (0 - 499 posts)
    You might want to try looking at the internet settings in contol panel for a section something like 'only dial up when there is no network connection'. I can't remember the exact wording, it's been a while...

    I had this trouble when I ran another machine as a small intranet web server to develop some stuff. Windows wasn't looking on the LAN for it. It seems it doesn't know 127.0.0.* can't exist on the real 'net...
  14. #8
  15. No Profile Picture
    eddie
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi all,


    IT WORKED :-)) !!! Eric Imboden and Markdrayton you're FANTASTIC!!!

    I was rather disapointed with the PHP+apache+win95 and in the interim from my first post, i've installed another partition with PHP+apache+Linux and it works well off-line. Though i've gotten it to work only in the text-based Lynx browser, with Netscape there's a problem updating my sis 6326 video driver (but that's Linux).

    Anyhow THANK YOU. The people here and this devshed forum are really cool!

    Revived,

    Eddie

Similar Threads

  1. Invalid characters with PHP and MySQL
    By gio50000 in forum MySQL Help
    Replies: 2
    Last Post: November 18th, 2004, 08:59 AM
  2. Replies: 3
    Last Post: December 25th, 2003, 05:16 AM
  3. Replies: 0
    Last Post: October 8th, 2003, 10:18 AM
  4. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  5. mySQL and PHP needs Apache?
    By Dekers in forum MySQL Help
    Replies: 5
    Last Post: July 5th, 2002, 12:06 PM

IMN logo majestic logo threadwatch logo seochat tools logo