View previous topic :: View next topic |
Author |
Message |
tdkyo Guest
|
Posted: Sat Dec 14, 2002 6:49 am Post subject: mysql question(I searched to forum and still no answer) |
|
|
I already installed php and is working fine. I installed mySQL and its working fine except it says it cant connect to localhost
Errorlog:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
I did telnet localhost 3306 and says it can't connect. Any help is welcome. :wink: |
|
Back to top |
|
|
!Keys -
Joined: 23 Nov 2002 Posts: 156 Location: Holland, Enschede
|
Posted: Sat Dec 14, 2002 12:10 pm Post subject: |
|
|
this is not abyss´ bug/mistake, it´s in mysql, click your stosign in the tasbar (twhich should be on green) and see what ur pass and username is there,, :-) _________________ !Keys || MwM^computerware |
|
Back to top |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sat Dec 14, 2002 3:10 pm Post subject: Re: mysql question(I searched to forum and still no answer) |
|
|
tdkyo wrote: | I already installed php and is working fine. I installed mySQL and its working fine except it says it cant connect to localhost
Errorlog:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
I did telnet localhost 3306 and says it can't connect. Any help is welcome. :wink: |
Are you sure that you are running the MySQL server (mysqld.exe)? Installing MySQL doesn't do that for you automatically. _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
|
DLashley -
Joined: 18 Dec 2002 Posts: 207 Location: New York, NY
|
Posted: Sat Dec 21, 2002 3:16 am Post subject: Making MySQL Startup with Windows |
|
|
1. Navigate to the folder where you installed MySQL (ex. C:\mysql)
2. Double-click on the "bin" folder
3. Double-click on the file named "winmysqladmin.exe"
4. When the console pops up, click on the tab that says "my.ini Setup"
5. Click on the button that says "Create Shortcut on Start Menu"
6. Close down the MySQL server
7. Reboot Windows
MySQL should start with Windows now, and then minimize to the System Tray - with the "traffic light" icon on GREEN (if it's on RED, you screwed up somewhere). :)
P.S. If you haven't set a password for MySQL, and you don't know how:
1. Shut down the MySQL server (if it's running)
2. Navigate to C:\Windows and DELETE the "my.ini" file
3. Reboot Windows
4. When MySQL starts, you should get a box which asks you to enter your USERNAME and PASSWORD.
5. When you enter this info, a new "my.ini" file will be created which will contain all your MySQL server settings
You can MANUALLY launch MySQL anytime by navigating to START>PROGRAMS>START UP> then click on WINMYSQLADMIN.
You can also MANUALLY turn the MySQL server ON or OFF from the "traffic light" icon in the System Tray. _________________ DLashley |
|
Back to top |
|
|
DLashley -
Joined: 18 Dec 2002 Posts: 207 Location: New York, NY
|
Posted: Sat Dec 21, 2002 3:31 am Post subject: |
|
|
OH OH! 8O
I just checked my MySQLadmin Console, and on the ENVIRONMENT tab, in the MyODBC box it says:
Not Found
Driver 3.51 Not Found
Anybody got any feedback, tips, help, prayers for me? I'd sure appreciate some help with this. Thanks! _________________ DLashley |
|
Back to top |
|
|
EvaStar -
Joined: 17 Dec 2002 Posts: 62 Location: Ontario
|
Posted: Sun Dec 22, 2002 9:23 pm Post subject: |
|
|
I have the same problem and I can't figure it out....
I have read about 5 or 6 books on MySQL but I couldn't find anything
about this error... :? |
|
Back to top |
|
|
DLashley -
Joined: 18 Dec 2002 Posts: 207 Location: New York, NY
|
Posted: Sun Dec 22, 2002 11:32 pm Post subject: |
|
|
EvaStar wrote: | I have the same problem and I can't figure it out....
I have read about 5 or 6 books on MySQL but I couldn't find anything
about this error... :? |
I re-read the Instruction manual for MySQL, and I found the answer. Here it is:
Code: | Update: I did some more reading, and found out that ActiveState Perl comes with PPM (Perl Package Manager). I ran "ppm.bat" and it started PPM for me in a DOS window. I then used the command:
install dbi
install dbi y/n? y
It then connected to the Internet, downloaded and installed DBI.pm for me, and guess what??? NO more error messages in my cgi.log! |
I copied that over from a post I made in another topic. I don't know how to link to specific posts yet. (sorry aprelium) _________________ DLashley |
|
Back to top |
|
|
|