Welcome Guest ( Log In | Register )




                Web Hosting Guide

 
Reply to this topicNew Topic
Mysql Connect
JeremyShaw
post May 10 2007, 12:02 AM
Post #1


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 10
Joined: 9-May 07
Member No.: 21,875


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?
Go to the top of the page
 
+Quote Post
SilverFox
post May 10 2007, 04:12 AM
Post #2


Premium Member
Group Icon

Group: Members
Posts: 206
Joined: 26-February 07
From: Texas
Member No.: 20,598


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...
CODE
<?php
mysql_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.

This post has been edited by SilverFox: May 10 2007, 04:13 AM
Go to the top of the page
 
+Quote Post
yordan
post May 10 2007, 08:40 AM
Post #3


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,938
Joined: 16-August 05
Member No.: 7,896
myCENTs:44.40


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
Go to the top of the page
 
+Quote Post
JeremyShaw
post May 10 2007, 11:50 AM
Post #4


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 10
Joined: 9-May 07
Member No.: 21,875


QUOTE(yordan @ May 10 2007, 12:40 AM) [snapback]103269[/snapback]
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.
Go to the top of the page
 
+Quote Post
SilverFox
post May 10 2007, 04:20 PM
Post #5


Premium Member
Group Icon

Group: Members
Posts: 206
Joined: 26-February 07
From: Texas
Member No.: 20,598


I suggest you get phpMyAdmin.

Get hosting at Asta...it comes with it tongue.gif
Go to the top of the page
 
+Quote Post
yordan
post May 10 2007, 07:59 PM
Post #6


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,938
Joined: 16-August 05
Member No.: 7,896
myCENTs:44.40


QUOTE(SilverFox @ May 10 2007, 06:20 PM) [snapback]103288[/snapback]
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.
Go to the top of the page
 
+Quote Post
TavoxPeru
post May 10 2007, 08:34 PM
Post #7


Super Member
Group Icon

Group: [HOSTED]
Posts: 876
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579
myCENTs:13.21


QUOTE(JeremyShaw @ May 9 2007, 07:02 PM) [snapback]103255[/snapback]
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,
Go to the top of the page
 
+Quote Post

Reply to this topicNew Topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No new   29 rbf1787 12,382 4th November 2009 - 01:25 PM
Last post by: iG-
No new   19 lonebyrd 3,521 1st November 2009 - 03:49 PM
Last post by: iG-Lukenda
No New Posts   9 jedipi 4,484 28th October 2009 - 08:09 PM
Last post by: HannahI
No new   23 WeaponX 3,953 26th October 2009 - 01:31 PM
Last post by: iG-computerwiz9001
No new   27 nightfox 5,947 14th October 2009 - 07:15 AM
Last post by: iG-Mark
No New Posts   3 darkken 2,312 11th September 2009 - 08:26 PM
Last post by: iGuest
No New Posts   6 ruben 1,523 27th August 2009 - 09:07 AM
Last post by: iG-J vincent
No New Posts   1 surfermac 241 23rd August 2009 - 09:48 PM
Last post by: yordan
No New Posts   4 miCRoSCoPiC^eaRthLinG 6,318 21st August 2009 - 01:59 PM
Last post by: iG-J vincent
No New Posts   9 bakr_2k5 1,818 29th July 2009 - 11:02 PM
Last post by: iG-Wicky
No New Posts   2 FirefoxRocks 237 24th July 2009 - 08:02 PM
Last post by: FirefoxRocks
No New Posts   4 FirefoxRocks 249 23rd July 2009 - 04:23 AM
Last post by: FirefoxRocks
No New Posts   4 niquel 487 20th June 2009 - 10:51 AM
Last post by: TavoxPeru
No New Posts   5 turbopowerdmaxsteel 3,838 11th June 2009 - 02:44 AM
Last post by: wroxtar
No New Posts   7 sirknight 6,376 9th June 2009 - 08:59 PM
Last post by: iG-javier sanchez


Web Hosting Powered by ComputingHost.com.