How to install MySQL in Amazon Linux Instance – AWS


install MySQL in Amazon Linux Instance
sudo yum update
sudo yum install mysql
sudo mkdir /var/lib/mysql
sudo yum install mysql-server

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers

How to set root password for MySQL in Amazon Linux Instance – AWS


Set root password for MySQL
mysqladmin -u root password 'test@123'
Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers

MySQL Server 5.5 Installation on Windows 8 64 bit Machine


MySQL Server 5.5 Installation on Windows 8 64 bit Machine

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

http://dev.mysql.com/downloads/mysql/5.5.html#downloads

1.Download Mysql

2.Download Mysql

3.MySQL Server Setup Wizard

 

4.MySQL Server EULA

5.MySQL Server Setup Type

6.Ready to Install MySQL Server

7.Installing MySQL Server

8.Installing MySQL Server

9.Installing MySQL Server Enterprise

10.Installing MySQL Server Enterprise Monitor Service

11. Completed MySQL Setup

12.MySQL Server Instance COnfiguration Wizard - Detail COnfiguration

12.MySQL Server Instance COnfiguration Wizard

14.MySQL Server Instance Configuration Wizard-Server Type

15.MySQL Server Instance COnfiguration Wizard - Database Usage

16.MySQL Server Instance COnfiguration Wizard - InnoDB TableSpace Settings

17.MySQL Server Instance COnfiguration Wizard - CHaracter Set

18.MySQL Server Instance COnfiguration Wizard - Concurrent Connection

19.MySQL Server Instance COnfiguration Wizard - Networking Options

20.MySQL Server Instance COnfiguration Wizard - Windows Options

21.MySQL Server Instance COnfiguration Wizard - Security Options

22. MySQL Installed Successfully

MySQL – ERROR 1133 (42000): Can’t find any matching row in the user table


Problem: ERROR 1133 (42000): Can’t find any matching row in the user table while granting privileges in MySQL

Solution: Use FLUSH PRIVILEGES;  Command at mysql prompt and execute the grant statement again

Done!!!