SitePoint Sponsor

User Tag List

Results 1 to 8 of 8

Thread: Access to MySQL

  1. #1
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am following the MySQL tutorial here at SitePoint, but I am having trouble getting a database ready. Lucky for me, my provider supports MySQL, so I mailed them and asked for an account. I got my account information, and tried to log in with MySQL using www.telefragged.com as server (my hosting provider) and my username. I typed in the correct password, but then I get an error message saying my ISP is not allowed to connect to it. (ERROR 2003: Host 'apollo-hrlm0711.multiweb.net' is not allowed to connect to this MySQL server)

    So I mailed the system admins. Their reply:
    "only the telefragged server can connect"

    So I asked them what possible use the database could be if you can only access it from the host server.

    Their reply:
    "www.php.net
    that is how I do all my db connections
    or <A HREF="http://www.phpwizard.net"" TARGET=_blank>www.phpwizard.net"</A>

    (yes, they're very communicative, aren't they?)

    What should I do?! I am completely lost!

  2. #2
    SitePoint Zealot
    Join Date
    Nov 1999
    Location
    Manhattan!
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Put the script(s) that access the database in a directory on your ISPs server (where you would normally have your HTML and PHP pages). Then connect to the server using 'localhost' as the servername.

    Christian

    ------------------
    Axie automatically performs free, customizable searches for new
    websites and delivers the links to members by personalized email.
    http://www.axie.com/

  3. #3
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK got that. But since I haven't read about the SQL and PHP part yet, I want to create a database first. And that's where it goes wrong.

  4. #4
    SitePoint Zealot
    Join Date
    Nov 1999
    Location
    Manhattan!
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are not using php yet, then telnet into your ISPs computer and access mySQL that way.

    Christian

    ------------------
    Axie automatically performs free, customizable searches for new
    websites and delivers the links to members by personalized email.
    http://www.axie.com/

  5. #5
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    They don't allow to use telnet

  6. #6
    SitePoint Zealot
    Join Date
    Nov 1999
    Location
    Manhattan!
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Go to http://www.phpwizard.net and download phpMyAdmin. Insert your password into the config files and upload the files to a directory on your ISPs computer. Now you will have access to your mySQL database.

    Christian

    ------------------
    Axie automatically performs free, customizable searches for new
    websites and delivers the links to members by personalized email.
    http://www.axie.com/

  7. #7
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    xyz
    Posts
    158
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks! It's a bit different than the tutorial but it will have to do

  8. #8
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    No telnet access and no remote client access? Wow -- that ISP definitely needs a talking-to. PHPMyAdmin will certainly do the trick for now, but some experience with the SQL command line will come in handy when it comes time to start accessing that database in your own PHP scripts. You might want to set up MySQL by itself on your own computer just to play around with it a little and go through the examples in Part II of my series.



    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!


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
  •