So I am trying to learn some PHP and MySQL to know to, well know it and I have set it up before and gotten it to work but now I think something has gone wrong.

I created my my.ini and all that fun stuff with the wizards (PHP configured IIS for me and the WinMySQLAdmin tool created the my.ini for me) but it seems that the WinMySQLAdmin tool isn't reporting correctly.

To get a few things straight: I have already done a mysql install in command prompt and have also run mysqld-nt.exe (do I have to do it everytime I reboot? I am developing this on a laptop then probably gonna but it on a real website once I am comfortable with it).

Problem: If I enter mysql.exe and start playing around in there I can see the mysql database and the work database that I created, everything looks and acts fine and dandy. BUT in the WinMySQL tool the Database section shows nothing, just simply my computer but it doesn't show either database (under the database tab). Also the PHP page that I created doesn't throw an error when connecting to a database, even when I put in something that is wrong.

Any ideas?

    Hmm.. can we see some code you are using there could be a number of reasons its not working. The servers not up, Invalid Query etc.

    Also you should install MySQL as a Service that way you wont be requried to keep starting it to do this

    In the command prompt go to

    cd c:\mysql\bin
    mysqld-nt --install

    should say something like

    MySQL Service Installed

    from there to start it

    net start mysql

    If you get errors in installing it as a service you have done something wrong in the install.

      Sorry forgot to mention that it is installed as a service. You actually already might have looked at my code in another post that I posted before pining over the code for errors for about an hour.

      http://www.phpbuilder.com/board/showthread.php?s=&threadid=10281783

      Has a link to the code with a deliberate messup for the database name ("jokes" I called the database "work" and the table is "jokes," wanted to see if it tossed the error and it didn't).

      Thanks for the help

        Write a Reply...