/Users/narendra.raghuwanshi/Documents/personaldata/credentials/devEnvirnment/
ssh -i narendra.raghuwanshi-dev.pem narendra.raghuwanshi-dev@10.254.192.70
sudo -su awsdev
If above is succeed
mysql -u pascaldev -p -h pascaldev.cpuz5conexqr.us-east-1.rds.amazonaws.com -P 3306
Using our Local Machine
Check the DB is accessible or not to you
mysql -h <Endpoint> -P 3306 -u -p
mysql -h cellbio-hpscscorecard.cpuz5conexqr.us-east-1.rds.amazonaws.com -P 3306 -u pascalstage -p
What to do when i will not able to connect from my localhost mysql
For MAC OS
- Open MySQL from System Preferences > Initialize Database >
- Type your new password.
- Choose 'Use legacy password'
- Start the Server again.
- Now connect the MySQL Workbench
Download MySQL Community Server
For Mac direct link : https://dev.mysql.com/downloads/file/?id=476460
Access Database using Terminal
How to add MySQL to $PATH variable:
cd to your home folder
$ open -t .bash_profile
Try adding the following line to your .bash_profile file.
export PATH=${PATH}:/usr/local/mysql/bin/
cd to your home folder
$ open -t .bash_profile
Try adding the following line to your .bash_profile file.
export PATH=${PATH}:/usr/local/mysql/bin/
Setting the MySQL root user password on OS X
$ mysql -u root -p
mysql$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
$ mysql -u root -p
mysql$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Access DB using workbench in interactive mode:
Download WB: https://dev.mysql.com/downloads/file/?id=474219
Make sure your server is up and running: