Installing mySQL

[madHatter1]

Hello

I have managed to download mySQL, but I'm not sure I have installed it! I feel I have made some progress, although it is snail-like.

I have opened up MS-DOS and typed in a few commands and the results are as follows:

C:\>C:\mysql\bin\mysqladmin version status proc
C:\MYSQL\BIN\MYSQLA~1.EXE Ver 8.23 Distrib 3.23.55, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.55-max-debug
Protocol version 10
Connection localhost via TCP/IP
C:\>C:\mysql\bin\mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+

C:\>

C:\>C:\mysql\bin\mysqlshow -u root mysql
Database: mysql
+--------------+
| Tables |
+--------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+--------------+

C:\>

C:\>C:\mysql\bin\mysqladmin version status proc
C:\MYSQL\BIN\MYSQLA~1.EXE Ver 8.23 Distrib 3.23.55, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.55-max-debug
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 4 min 41 sec

Threads: 1 Questions: 13 Slow queries: 0 Opens: 6 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.046 Memory in use: 8307K Max memory used: 8339
K
Uptime: 281 Threads: 1 Questions: 13 Slow queries: 0 Opens: 6 Flush tables:
1 Open tables: 0 Queries per second avg: 0.046 Memory in use: 8307K Max memo
ry used: 8339K
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 6 | ODBC | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+

C:\>

C:\>C:\mysql\bin\mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.55-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

When I try to follow the MS-DOS command 'help;' or '\h' the cursor won't go any further (and I can hear a little clicking noise).

I would be grateful if somebody could just confirm that I am on the right track, and if somebody could indicate how I can now go a little further.

Many thanks

Hatter

 

[JustKIDn]

hatter,

It sounds like you're on the right track and MySQL is installed correctly.

I'm pretty new at this too. But let me see if I have anything to say.

I haven't yet found anything to tell me what the correct way to start MySQL. So what I do is this; (and it works fine) I start mine by running 'winmysqladmin.exe'.
This appears to be a windows (GUI) MySQL monitor. It doesn't seem that you can do much in it but it starts the MySQL service and then minimizes itself to the tray.

Then I use MySQL-CC (download from mysql.com) or MySQL-Front (no longer in production, but still good) to manage the DB. Like create DB's, tables, fields, etc. Write querys, and run them. I'm used todoing things the gui way, and this allows me to 'see' what I'm doing while I get the hang of it.

I'm curious, if you just downloaded this. Why did you get the 3.23 version? 4.0.12 is available and is Gamma which they say is because it's about to be released as stable. I find that it is stable so far for me.

Does this help?
tgus

____________________________
Families can be together forever...

 

[piti]

madHatter1 looks like your mysql server is installed and up

only thing that makes me curious is that you are unable to enter commands in the mysql console, i have never heard about such behaviour, so can't help you, but i hope the info about your successful install and start of mysql is what you wanted to know ;-)
try to get some third-party managers for mysql as tgus suggested to see if there is only the console not working or the whole build is bugy

 

[JustKIDn]

One time I tried the mysql-max.exe and it gave me a similar message and never returned the prompt so I couldn't type either.

My guess is the server (service) started fine. But I didn't want to leave a DOS window open. So I closed it and went back to what works for me. Again, I don't know if this is the correct method but it works for me.

piti, should I be doing anything different?

tgus

____________________________
Families can be together forever...

 

[madHatter1]

Hello All

Many thanks for your helpful messages, and thanks for letting me know I have installed mySQL OK.

Yes, tgus, I have 'winmysqladmin.exe' and could try using it the way you do. I am not sure if that is the way to do things. Some of the documentation I have read seems to be very DOS-focused.

I think I will play around with both ideas for the time being, and perhaps read a little more. If I discover something new, I post a message here.

Thanks again

Hatter