Testing the Installation of MySQL
C:\apache\mysql\bin>mysqld
Or
C:\apache\mysql\bin>mysqld --install
Service successfully installed
C:\apache\mysql\bin>NET START MySQL
The MySQL service was started successfully.
C:\apache\mysql\bin>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 3.23.47-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
C:\apache\mysql\bin>NET STOP MySQL
The MySql service is stopping.
The MySql service was stopped successfully.
Configuring the Installation
C:\apache\mysql\bin>NET START MySQL
The MySql service is starting.
The MySql service was started successfully.
C:\apache\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| sroyit |
| test |
+----------+
3 rows in set (0.00 sec)
mysql> USE mysql;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
Changing Password
C:\apache\mysql\bin>mysqladmin -u root reload
C:\apache\mysql\bin>mysqladmin -u root password root
C:\apache\mysql\bin>mysql -h localhost -u root -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.47-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.