Welcome to WebDesignForums.net!
You're currently viewing WDF as a guest. By registering for a free account, you'll be able to participate with other members in our friendly community. Being a member allows you to ask questions and get answers for those troublesome web development tasks!

In addition, as a member you'll be able to post your websites up for review. Using our unique website review system you can gain some amazing feedback from some of the best web developers around. This is a completely free service to all registered members.

Ready to register yet? Registration is 100% free. Click Here To Join Now!

How do I set up a MySQL dB remotely for Mac OS 9?

Discussion in 'Database Systems Help' started by mikedfunk, May 1, 2003.

  1. Offline

    mikedfunk New Member

    Message Count:
    31
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Orlando, FL
    I run the dying mac OS 9.2.2 because I have limited hard disk space on my 333 tray loading imac (6 Gb with a whopping 350 mb free). Besides that, my iMac doesn't even have firewire, only USB 1, so I haven't gone through the trouble of buying a new hard drive yet and troubling with the transfer of files from the old drive.

    So right now I think my only option to learn MySQL/PHP is to set up a sample database on a free hosting service that supports it and work on it with dreamweaver remotely. However, the extent of my MySQL/PHP knowledge ends abruptly at the definition of each. I have scanned through some tutorials on how to set up these programs on a windows machine, but since I don't have the luxury of doing that, I am not sure how to learn database integration. I am a web design student and am quickly becoming aware that the knowledge of database design and implementation will be crucial in my marketability as a web designer.

    So since I don't have the Unix underpinnings of Mac OSX or the ability to install PHP and MySQL like on a PC, how do I set up a MySQL database remotely, and communicate with it using Dreamweaver MX?


    mikedfunk, May 1, 2003
    #1

  2. WDF Go Premium, Drop Ads

  3. Offline

    filburt1 bored

    Message Count:
    11,783
    Likes Received:
    3
    Trophy Points:
    0
    Location:
    Maryland, US
    You'll need a host that can run MySQL and allow remote connections; http://www.hostmatters.com/ . I don't believe you can run MySQL itself on OS 9, only on OS X.

    You should probably just save your money for an eMac or something similar.


    filburt1, May 1, 2003
    #2
  4. Offline

    mikedfunk New Member

    Message Count:
    31
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Orlando, FL
    I know I can't run it on OS 9, but I know it can be run on the host server, provided that there is PHP and MySQL support. From what I understand, I can set it up on the remote server and communicate with the database remotely with Dreamweaver MX, as opposed to setting up a test server locally. I just don't know how to do this.

    I plan on eventually getting an eMac, but it's going to be quite a while. I would like to learn this stuff in the mean time.


    mikedfunk, May 1, 2003
    #3
  5. Offline

    JR New Member

    Message Count:
    4,355
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    UK
    please will you fix your sig to 4 lines...

    thanks :)


    JR, May 3, 2003
    #4
  6. Offline

    Wired WDF Moderator and Alien Overlord

    Message Count:
    7,598
    Likes Received:
    133
    Trophy Points:
    63
    Go into Dreamweaver, hit F1, then search for mysql. You'll see a result for Creating a database connection. Personally, I just use Dreamweaver to FTP everything up, and use MySQL Control Center to access the mySQL database. I manually create everything from there. Didn't know Dreamweaver could access it directly until I searched this though, so maybe i'll try it and see how I like it.


    Wired, May 3, 2003
    #5
  7. Offline

    mikedfunk New Member

    Message Count:
    31
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Orlando, FL
    Damn! MySQL Control Center is only available for Linux and Windows, not Mac OS 9. Is there a similar tool I can use with OS 9? I just want to learn how to create and modify a database by practical application. I can learn PHP on php.net, but as far as setting up a database with OS 9 and connecting to it to modify it is hard for me to find info on.


    mikedfunk, May 5, 2003
    #6
  8. Offline

    Wired WDF Moderator and Alien Overlord

    Message Count:
    7,598
    Likes Received:
    133
    Trophy Points:
    63
    Have you tried the Dreamweaver one? Either way, you can submit mysql queries using a PHP page. With some minor work, you can set up a page that has a form that wil input any commands directly to the DB, and reports back with any server side messages. There are some mySQL programs for Mac out there, just gotta look around.

    Just tried the Dreamweaver one, it's actually pretty good. Even lets you see the data in the tables, which for some reason the Control Center won't let you do. I don't believe it will let you create anything however. So you'll still have to find out another way to access the mySQL database to initially make the tables if you don't want to bother with making your own PHP entry page. Perhaps telnet or SSH?


    Wired, May 5, 2003
    #7
  9. Offline

    mikedfunk New Member

    Message Count:
    31
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Orlando, FL
    thank you for the reply. i will look into ssh and telnet so i can create a database to work with. and once i do, i will try the dreamweaver interface.


    mikedfunk, May 5, 2003
    #8
  10. Offline

    Wired WDF Moderator and Alien Overlord

    Message Count:
    7,598
    Likes Received:
    133
    Trophy Points:
    63
    No problemo, glad to help.


    Wired, May 5, 2003
    #9
(You have insufficient privileges to reply here.)

Share This Page