>>>>>>>>>> reconstituted from a munged response <<<<<<<<<<<<<<<<
(original post)
Steve Grosz <[EMAIL PROTECTED]> wrote on 02/08/2005 06:04:48 PM:
> I already have a version of MySql 4.1.17 running on a different server,
but
> am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
> software.
>
> I'm finding that 4.0.23 isn't as easy to set up as the later versions.
>
> I modified the my.ini file and put it in the \windows directory for
Windows
> Server 2003.
>
> When I try to use the MySql Administator, and put in the server name,
root
> account and password defined in the my.ini file, it doesn't connect,
using
> 'localhost'.
>
> What am I doing incorrectly?
>
> Steve
>
Did you remember to cross your fingers and gnash your teeth? What about
the blue button, did you press it? (Just kidding)
First off, you left out a lot of useful information about your situation:
How did you install the 4.0.23 (zip, msi,...)?
Have you verified that the server is running?
What other connection methods have you tried? Did they work?
Have you been following the documented installation procedure (
http://dev.mysql.com/doc/mysql/en/installing.html)? If you have, what step
are you on?
Have you looked at the Troubleshooting guide (
http://dev.mysql.com/doc/mysql/en/problems.html)?
Besides posting to this list, what other things have you tried?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
>>>>>>>>> Steve's Reply <<<<<<<<<<<<<<<<<<<<<<<<<<<<<
"Steve Grosz" <[EMAIL PROTECTED]> wrote on 02/09/2005 02:01:14 PM:
> I guess I didn't hold my mouth right.....hate it when that happens! :-)
I installed from a ZIP file, and the Admin tool
> does show that the server is running.
>
> I have tried to telnet into that server, and it fails, but that may
> be due to the firewall.
>
> Currently I am on step #2.3.10 of the install process.
> If I didn't answer all your questions, let me know! Thanks for the
help!!
> Steve
Just curious, if you are being faithful to the installation docs.... How
is the Admin tool running? You aren't to that step yet... ;-)
Anyway, it's odd that you cannot telnet to a server when you say it is up.
Note: You DO NOT get a normal telnet session, all you should be able to
see when you telnet to a MySQL server is the version number and some
garbage characters. That tells you that you have port-to-port connectivity
from your machine to the server. It would be prohibitively difficult to
use telnet (read: practically impossible) to work directly with a MySQL
server manually through telnet.
How did you start the server, is it installed as a service or are you
running it manually from a command prompt?
Is your problem connecting to the server through mysqladmin or getting the
server running? Can you connect through the command line client mysql.exe?
What error messages are you getting and from what program?
And one last thing... please CC: the list on all responses. It will not
only help the next dba through a similar issue but it will also make sure
you get more responses. In the event that I became unavailable or gave you
bad advice, anyone else on the list could kick in and help get you going,
too.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
