mysql 3.22

[Anon]

After installing mysql 3.22 on a win32 machine ( 95 w/ dcom95.exe ), I am experiencing a problem with the set-up.

After I type cd /mysql/bin then at the prompt c:/mysql/bin>, I type mysqld --standalone, it responds with 'Bad command or filename'.

Any ideas?

Also, do I need a web server running at the same time because it said Unable to connect to server on localhost. Try telnet localhost 3306. Still nothing.

Thanks,
-Katie.

[Anon]

While you'll obviously need a webserver for this, it has nothing to do with your problem right now. First of all, the default SQL port cannot be telnetted. that's what port 23 is for. To correctly administer MySQL remotely, you should use OpenSSH or something similar.

[Anon]

I think ADB misunderstood you.

On Windows, try mysqld-shareware. DO a CTRL-ALT-DELETE and check it's there in the process list. (Followed by CANCEL, obviously :-) )

To answer your second question, after dong the above, type "mysql -h localhost -u root"

(actually "mysql" by itself will probably do if you haven't done any security settings.

That should connect you. You can then issue SQL commands directly to the MySQL server Try "help", and "use databasename" to connect to a particular database. By default a database called TEST will be there, I think.

You do NOT need a webserver to connect to a MySQL server, they are completely separate.

If trying to use mysql on your computer to connect to a remote server use:
"mysql -h hostname -u username -p"

It will then prompt for a password (the -p means prompt for password, always do it this way, don't put the password in the command.