Mysql Connect

[JeremyShaw 0]

Okay, MySQL was installed, as per the guide on php.net, and all of the config done. This was done on a Windows computer with IIS 5 on XP. The comand line will not let me login! The program groups' own shortcut doesn't work! Will any one help?

[SilverFox1405241541 0]

Eerm maybe you can use php to edit it? That'll take hours longer than phpMYadmin...but if you have to make a php script start with...

<?phpmysql_connect("localhost", "<user>", "<pass>") or die(mysql_error());mysql_select_db("db") or die(mysql_error())

I am not trying to sound mean...however your post makes me want to cry...I can feel your desperation.
Edited May 10, 2007 by SilverFox (see edit history)

[yordan 10]

OK, clearly you have a configuration problem, probably the mysql database did not start, or the user does not exist yet.If you want to simply train yourselv, may I suggest an easier way ?I would suggest you to install easyphp. It comes with everything bundled inside (php, mysql, the web server), the install is straightforward (nothing to do) and when you ask it, everything starts automatically and is ready to be used. When you will have learned how to use easyphp, you will be able to switch to some more complicated (because not bundled nor packaged) environments.RegardsYordan

[JeremyShaw 0]

OK, clearly you have a configuration problem, probably the mysql database did not start, or the user does not exist yet.If you want to simply train yourselv, may I suggest an easier way ?
I would suggest you to install easyphp. It comes with everything bundled inside (php, mysql, the web server), the install is straightforward (nothing to do) and when you ask it, everything starts automatically and is ready to be used.
When you will have learned how to use easyphp, you will be able to switch to some more complicated (because not bundled nor packaged) environments.
Regards
Yordan

Thank you, I was looking around and also found a similar package, wamp5 server.

[SilverFox1405241541 0]

I suggest you get phpMyAdmin.

 

Get hosting at Asta...it comes with it

[yordan 10]

I suggest you get phpMyAdmin.

Not so simple. I had this problem some monthes ago : phpmyadmin needs you to be connected. So, if you cannot connect to the database, phpmyadmin will not allow you to examine the database.

[TavoxPeru 0]

Okay, MySQL was installed, as per the guide on php.net, and all of the config done. This was done on a Windows computer with IIS 5 on XP. The comand line will not let me login! The program groups' own shortcut doesn't work! Will any one help?

May be you can't login because the server isn't started yet. You must start the mysql server before you can do anything on it, so, to start it you can use a command line, a batch file, the services console or even the run command:

With the Run command: Click on the Start menu, then select Run... and type net start mysql and press enter in the opened dialog.

With a batch file: Create a new batch file with any text editor, name it filename.bat, and inside it type the following:

@echo off

cls

net start mysql

exit

Using the services management console: Simply press the start button located on the toolbar or right click the mysql service and select start.

Using a command shell: simply type net start mysql on the opened window.

After your server is started you can login to it by using a shell window, type the next command on it and press enter:

 

>mysql -uuser -ppwd

 

replace user with your user name -maybe root- and pwd with its password.

 

Best regards,