RE: windows installation In-reply-to: <[e-mail]>

[Armando]

The database is there, else you wouldn't even be able to connect to the
server period. To connect through command line as the root user with a
fresh install:

mysql -u root mysql

Once in at the mysql prompt:

update user set password=password('your_new_password') where
user='root';

You should get 2 rows updated. So now your root password is set. If you
do a show databases after logging in this way then you'll be able to see
the mysql database listed. You can relogin to mysql from this point
using: mysql -u root databasename -p

Where -p is specifying to ask for password. Also as a recommendation,
uninstall the service and reinstall it so you're not running 'debug'. Go
to c:\mysql\bin> then do a: mysqld-nt --remove

Then: mysqld-nt --install

This will reinstall the service so you're running the standard NT daemon
and not in debug. Cheers.

Armando

-----Original Message-----
From: Darren Westmore [mailto:Darren.Westmore@stripped] 
Sent: September 22, 2004 5:19 AM
To: win32@stripped
Subject: windows installation


Hi,

 

Just a quick question. I have just installed mysql v4.0.21-debug, (which
is the version marked as production on the mysql web site) on Windows
2000 server.

The installation was fine and the services have started ok.

 

The user manual suggests changing the user account passwords as soon as
possible and I believe these are located in a 'mysql' database, however
my installation only seems to have setup a 'test' database so far (as
listed when  executing the 'mysqlshow' command). Just in case the
database was hidden from view I tried executing the 'set password'
command under the 'mysql' monitor program and although it didn't report
any errors it said that 0 rows were affected so I assume the database
does not exists.

 

As this is only a testing database I'm not too worried about the
privileges but I am now concerned that the installation wasn't 100%
successful. Can you confirm if I will experience problems without the
'mysql' database and if so how can I create it myself with the right
columns and attributes etc?

 

Regards,

 

Darren