Welcome Guest ( Log In | Register )



 
Reply to this topicStart new 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,242
Joined: 16-August 05
Member No.: 7,896
myCENTs:56.55



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) *
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,242
Joined: 16-August 05
Member No.: 7,896
myCENTs:56.55



QUOTE(SilverFox @ May 10 2007, 06:20 PM) *
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: 805
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579
myCENTs:46.87



QUOTE(JeremyShaw @ May 9 2007, 07:02 PM) *
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 topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Navcat For MySQL(9)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Oracle Vs. Mysql Vs. Postgresql(9)
  13. Subqueries In Mysql(1)
  14. Apache Php With Mysql On Windows [solved](9)
  15. Not Understanding Mysql(4)
  1. Mysql - So Hard(14)
  2. Mysql Problem(1)
  3. Sun Bought Mysql(6)
  4. Mysql Backup With Another Address?(4)
  5. I Have An Error With My Mysql Connection(7)
  6. Mysql And User File_priv(0)
  7. Mysql Database Management(1)
  8. Mysql Database Entry By Excel Sheets(2)
  9. Mysql On Computer(9)
  10. Any Website Provide Free Host Mysql Host?(4)
  11. Mysql Multiple Tables(1)
  12. Mysql Overhead(3)
  13. Login System(6)


 



- Lo-Fi Version Time is now: 5th December 2008 - 01:16 AM