#1
  1. No Profile Picture
    jo
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi,

    just installed apache and php on a win95 machine.
    and now i'm trying to configure mysql but i'm
    quit stuck in here.

    i'm using
    http://www.vtwebwizard.comtutorialsmysqlstart.html
    as reference.

    php3 script :
    <html>
    <head><title>test db</title>
    </head>
    <body>
    <?php
    require("util.php3");
    $sql = new MySQL_class;
    $sql->Create("php3test");

    echo("Database connection successful.n");
    ?>
    </body>
    </html>

    util.php3 would be to long to past but if nessecary
    it's at this link :
    http://www.vtwebwizard.com/tutorials/mysql/mysql_module.html
    it used as user jo and as password joa.

    apache and the mysqld deamon is running.

    php3.ini has been adapted as following :

    ;Windows Extensions
    extension=php3_mysql.dll
    ;extension=php3_nsmail.dll

    [MySQL]
    mysql.default_port = ;
    mysql.default_host =127.0.0.1;
    mysql.default_user =jo;
    mysql.default_password =joa;

    now running testdb.php3 keeps giving me
    Error: Unable to connect to MySQL server: : '' :

    Now,

    mysql -u root
    i've added a superuser like this:

    do_command: query: INSERT INTO user VALUES ('%', 'jo',
    password('joa'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y')
    quit
    mysqladmin reload -uroot

    then : mysql -ujo -pjoa
    ok logged in

    and typed in the rest of the tutorial.

    btw : logging in as root and doing
    a query like select * from user outputs
    what it should.

    If anyone has any idea where my config problem should locate I would love to hear it.

    Greetings Joachim
  2. #2
  3. No Profile Picture
    wesb
    Guest
    Devshed Newbie (0 - 499 posts)
    I would try accessing the database like this:

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
    <?php
    mysql_connect("127.0.0.1","user","pass") or die("Connection failed.");
    echo "Connection successful.";
    ?>
    [/quote]

    If that works then it is probably a problem with the database class in util.php3.

    ------------------
    wesb@devshed.com
    www.devshed.com
  4. #3
  5. No Profile Picture
    jo
    Guest
    Devshed Newbie (0 - 499 posts)
    unfortunatly it doesn't work.
    If anybody has any ideas left...

    Greetings Joachim
  6. #4
  7. No Profile Picture
    wesb
    Guest
    Devshed Newbie (0 - 499 posts)
    Does PHP return an error message when you try to connect to MySQL?

    ------------------
    wesb@devshed.com
    www.devshed.com

Similar Threads

  1. Can not connect to MySQL - urgent help required.
    By Husain in forum MySQL Help
    Replies: 17
    Last Post: April 5th, 2004, 09:39 PM
  2. Can't connect to MySQL server on '24.*.*.*'
    By zytariuk in forum MySQL Help
    Replies: 9
    Last Post: May 1st, 2002, 06:30 AM
  3. Can't use php to connect mysql
    By itsource in forum PHP Development
    Replies: 8
    Last Post: January 23rd, 2002, 01:16 AM
  4. No idea on how to connect to mySQL, please help
    By darthmahon in forum MySQL Help
    Replies: 1
    Last Post: January 7th, 2002, 05:31 AM
  5. MyODBC & Win98 / MySQL & RH 7.1: can't connect!!
    By jeffdking99 in forum MySQL Help
    Replies: 9
    Last Post: December 26th, 2001, 06:17 PM

IMN logo majestic logo threadwatch logo seochat tools logo