MYSQL Post Installation - configuration change

MYSQL Post Installation - configuration change

What to tune in MySQL Server after installation

New setup mysql server

mysql learning process
1. download mysql database and program from http://dev.mysql.com/downloads/
mysql 5.0 -- mysql database
MySQL Administrator -- Administer MySQL Server
MySQL Query Browser -- Use this graphical client to work with your MySQL databases and run queries

install mysql 5.0
install mysql adminstrator
install query browser

mysql services start
from command prompt
\mysql\mysql server 5.0\bin type mysql
message "ERROR 1045 (28000):Access denied for use 'ODBC'@localhost'

how to solve?
1. from windows->control->panel>services->mysql->stop service
2. from \mysql\mysql server 5.0\bin\mysqld --skip-grant-table
3. open another command prompt \from \mysql\mysl server 5.0\bin type mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

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

mysql>
4. change password
mysql> update mysql.user set password=PASSWORD('yourpassword')
-> where User='root';
Query OK, 0 rows affected (0.06 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql>
5. type quit to quit from mysql
6. shut down mysql
a) keying mysqladmin -p shutdown
b) Enter password :
c) wait for while. go to command prompt where mysqld --skip-grant-table.
d) The screen will go to command prompt
7) goto windows->control->panel>services->mysql->start service
8) your can login into mysql server with
a) mysql Query Browser

b) mysql administrator
c) from command prompt\mysql\mysql server 5.0\bin\mysql -uroot -p and keying password after system request to.
you should see
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>