Problem after installing MYSQL on WIN32

29/6/2005
Hello, everybody, I'm a new MYSQL's user.
I have installed MYSQL version 4.0.24 and red traffic light appears at the
right bottom.
If I make a doubleclick first to have the prompt on mysql\bin\mysql or
bin\mysqld I get some error and beep.
Otherwise if I do as Manual 2.3.10 from windows's prompt and I insert C:\>
C:\mysql\bin\mysqld --console I obtain INNO db: ....
mysqld: ready for connections
Version: '4.0.14-log' socket: '' port: 3306
And Windows's prompt crash..
However, trafic light became green.
Now I can make doubleclick on bin\mysql (sometimes) and I obtain the prompt
mysql> or back from new windows's prompt.
I tried to register me as administrator mysqladmin -uroot and the help
appears.
But then everything I try to do doesn't work: for example mysqlshow gives
can't connect to localhost <10061>.
I didn't understand if is a problem of connecting to MYSQL or else.
If someone can help me I will be happy.
Thanks
Mauro



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Problem after installing MYSQL on WIN32

You need to remember there are two parts to mysql, the server and the
client(s). Mysqld is the server, mysql is the command line client. The
traffic light is courtesy of another program called winmysqladmin and is
optional.

If you start mysqld from a command prompt, it will not return to the
command prompt. Perhaps that is what you mean by "Windows's prompt
crash..". This is quite correct, the server is now running and that is
detected by winmysqladmin, so the green light comes on.

The best way to run mysqld is as a Windows service. The manual covers
this but you can run it from a command prompt or from Windows Startup if
you want.

Once the server is running you can start up a client to talk to it.

You can start the command line client from a command prompt by entering

C:\mysql\bin\mysql -u -h -p

The default user name is root, the default host is localhost and there
is no default for the database.

For example

C:\mysql\bin\mysql -uroot -p test

Logs you in as root, will prompt for root's password (which is empty by
default after installation) and will connect you to the test database. I
am assuming you have installed mysql to c:\mysql, if not adjust the
path. Just entering

C:\mysql\bin\mysql

Will log you into the server (if any) on your local machine as root
(providing root has no password) but will not connect you to any
database. This is what happens if you just double click mysql.exe from
Explorer.

You say you saw the one line help prompt, so you got that far.

There is no SQL command "mysqlshow" so that won't work and many other
commands won't work unless you are connected to a database.

You can connect to a database by entering

USE test;

and pressing enter. There is a database called "test" created during
installation. If you enter

SHOW databases;

You will see there is also a database called "mysql" where the server
keeps its administrative information.

Hope this gets you going but it is all in the manual in section 2.2.

John Bonnett



-----Original Message-----
From: Mauro Vezzoli [mailto:mauro.vezzoli@tiscali.it]=20
Sent: Thursday, 30 June 2005 6:20 AM
To: win32@lists.mysql.com
Subject: Problem after installing MYSQL on WIN32

29/6/2005
Hello, everybody, I'm a new MYSQL's user.
I have installed MYSQL version 4.0.24 and red traffic light appears at
the
right bottom.
If I make a doubleclick first to have the prompt on mysql\bin\mysql or
bin\mysqld I get some error and beep.
Otherwise if I do as Manual 2.3.10 from windows's prompt and I insert
C:\>
C:\mysql\bin\mysqld --console I obtain INNO db: ....
mysqld: ready for connections
Version: '4.0.14-log' socket: '' port: 3306
And Windows's prompt crash..
However, trafic light became green.
Now I can make doubleclick on bin\mysql (sometimes) and I obtain the
prompt
mysql> or back from new windows's prompt.
I tried to register me as administrator mysqladmin -uroot and the help
appears.
But then everything I try to do doesn't work: for example mysqlshow
gives
can't connect to localhost <10061>.
I didn't understand if is a problem of connecting to MYSQL or else.
If someone can help me I will be happy.
Thanks
Mauro




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org