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
Advertisements

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 – 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!!!