2 messages in com.mysql.lists.win32RE: windows installation| From | Sent On | Attachments |
|---|---|---|
| Darren Westmore | 22 Sep 2004 03:18 | |
| Armando | 23 Sep 2004 17:52 |
| Subject: | RE: windows installation |
|---|---|
| From: | Armando (diji...@shaw.ca) |
| Date: | 09/23/2004 05:52:33 PM |
| List: | com.mysql.lists.win32 |
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:Darr...@t-mobile.co.uk] Sent: September 22, 2004 5:19 AM To: win...@lists.mysql.com 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