Install MySQL 5.5.15 on Windows Server 2003

1.Install .Net Framework 4.0  - Required to install Mysql


http://www.microsoft.com/download/en/details.aspx?id=17851

2. Install MySQL Installer from

http://dev.mysql.com/downloads/installer/

3. If you get the Port 3306 already in use.

Stop the MySQL55 Services and then continue with the configuration of install








4. Create a Local Admin Other than the root

mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;

5. Then Create a User that can be used from any computer with a wildcard

 mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

6. To Show All Users

mysql>  select User from mysql.user;

7. To Delete Users

mysql> DROP USER 'jeffrey'@'localhost';

8. To Clear index auto increment count to start from 0 again:

Run a query: ALTER TABLE tablename AUTO_INCREMENT = 1