Connecting aws ec2 mysql from workbench
Hello all,
After a lot of struggle I finally made connection to aws ec2 mysql from workbench, posting here to help you guys.
Table of Contents
Connecting aws ec2 mysql from workbench:
If you are getting any other exceptions then do validate the below steps once again,
Step 1: Creating root user with all the privileges:
CREATE USER ‘root’@’18.188.178.178’ IDENTIFIED BY ‘root1’;
GRANT ALL PRIVILEGES ON javadomain.* TO ‘root’@’18.188.178.178’;
javadomain => database schema (which I created directly in linux mysql login).
If you like to allow all databases then try ON . instead of javadomain.*
Please do restart your mysql
sudo service mysqld restart
can be used in aws ec2 instance for restart your mysql in aws.
Step 2: Add bind-address in my.cnf file
sudo vi my.cnf
and add
# this allows all ip addresses, if you want to restrict only to particular ip then enter that address.
bind-address=0.0.0.0
just before mysql_safe option and restart it.
Step 3: Ensure you added mysql port 3306 in your aws security groups
More tutorials available online, so skipping this step for detailed explanation.
Other useful commands related to this:
- sudo service mysqld start
- sudo service mysqld stop
- sudo service mysqld status
- Mysql installation path: /var/lib/mysql
Mysql installation in aws ec2 linux:
- sudo yum update -y
- sudo yum install -y httpd24 php70 mysql56-server php70-mysqlnd
Facing any issues, have a look at this post.