Installing mySQL on AWS

Problem

You've got a bare-bones server and need to get mySQL install on it. The following is what did (and didn't work for me)

The Easy Bit

apt-get update

sudo apt-get install mysql-client

sudo apt-get install mysql-server

sudo mysql_secure_installation utility

What Didn't work!
I read so many "helpful" tips online.....

All done!
Enter password:
ERROR 1698 (28000) •
Access
ubuntu@ip-172-31-18-128 : -$
Enter password:
ERROR 1045 (28000)
Access
ubuntu@ip-172-31-18-128 : -$
Command may disrupt
mysql
- -user—root -p
denied for user 'root'@'localhost'
mysql
- -user=ubuntu -p
denied for user 'ubuntu'@'localhost' (using password:
sudo ufw enable
YES)
existing ssh connections. Proceed with operation (yln)? y
Firewall is active and enabled on system startup
ubuntu@ip-172-31-18-128:—$ sudo ufw allow mysql
Rule added
Rule added (v6)
ubuntu@ip-172-31-18-128:—$ sudo systemctl start mysql
sudo systemctl enable mysql
Synchronizing state of mysql.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable mysql
ubuntu@ip-172-31-18
ubuntu@ip-172-31-18
ubuntu@ip-172-31-18
ubuntu@ip-172-31-18
Enter password:
ERROR 1698 (28000)
ubuntu@ip-172-31-18
Enter password:
ERROR 1045 (28000)
ubuntu@ip-172-31-18
ERROR 1045 (28000) •
ubuntu@ip-172-31-18
ERROR 1698 (28000) •
ubuntu@ip-172-31-18
ERROR 1045 (28000) •
ubuntu@ip-172-31-18
Enter password:
ERROR 1045 (28000) •
ubuntu@ip-172-31-18
Enter password:
ERROR 1045 (28000)
ubuntu@ip-172-31-18
Enter password:
ERROR 1698 (28000) •
ubuntu@ip-172-31-18
Enter password:
ERROR 1045 (28000):
ubuntu@ip-172-31-18
ERROR 1045 (28000)
ubuntu@ip-172-31-18
-128:-$ cd /etc
-128: /etc$ vi /etc/mysql/mysql . conf .d/mysqld . cnf
-128: /etc$ sudo systemctl restart mysql
-128: /etc$ /usr/bin/mysql -u root -p
Access denied for user 'root'@'localhost•
-128: /etc$ /usr/bin/mysql -u ubuntu -p
. Access denied for user 'ubuntu'@'localhost'
-128: /etc$ /usr/bin/mysql -u ubuntu
. Access denied for user 'ubuntu'@'localhost'
-128: /etc$ /usr/bin/mysql -u root
. Access denied for user 'root'@'localhost'
(using password:
(using password:
YES)
NO)
-128: /etc$ /usr/bin/mysql -u ubuntu@ec2-3-10-24-48.eu-west-2.compute.amazonaws . com
. Access denied for user
-128: /etc$ /usr/bin/mysql -u ubuntu@ec2-3-10-24-48.eu-west-2.compute.amazonaws . com -p
. Access denied for user
-128: /etc$ /usr/bin/mysql -u root@ec2-3-10-24-48.eu-west-2.compute.amazonaws . com -p
Access denied for user •root@ec2-3-10-24-48.eu-west-2.compute.amazonaws. '@'localhost'
(using password:
(using password:
(using password:
NO)
YES)
YES)
-128:/etc$ /usr/bin/mysql -u root -p
Access denied for user •root'@'localhost•
-128: /etc$ /usr/bin/mysql -u admin -p
Access denied for user •admin'@'localhost' (using password:
-128: /etc$ /usr/bin/mysql -u admin
. Access denied for user •admin'@'localhost' (using password:
-128: /etc$ grep 'temporary password' /var/log/mysqld. log
grep: /var/log/mysqld. log: No such file or directory
Is /var/log/mysql/mysqld. log
Is: cannot access '/var/log/mysql/mysqld. log' •
No such file or directory
ubuntu@ip-172-31-18-128:/etc$ Is /var/log/mysqld. log
Is: cannot access '/var/log/mysqld. log' •
No such file or directory
ubuntu@ip-172-31-18-128:/etc$ mysql -uroot p
YES)
NO)

What eventually worked

It was as simple as using sudo to access mySQL.

$ubuntu@ip-172-31-18-128 : /etc$ Welcome to the MySQL monitor. Your MySQL connection id is 2 sudo service mysql sudo service mysql sudo mysql Commands end with stop start or Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners . Type •help; ' or '\h' for help. Type '\c' to clear the current input statement. mysql> SHOW DATABASES Database information mysql performance sys schema schema$

Now Get started

mysql> show databases
Database
information
epicdb
mysql
performance
sys
5 rows in set
schema
schema
(0.00 sec)
mysql> use epicdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>

This bit is important!

create user 'newuser'@'localhost' identified by 'yourpassword';

GRANT ALL PRIVILEGES ON epicdb.* TO 'newuser'@'localhost';

Acknowledgement

https://dba.stackexchange.com/questions/123031/cannot-access-new-installation-of-mysql-on-an-amazon-ec2-instance

https://linuxize.com/post/how-to-create-mysql-user-accounts-and-grant-privileges/

Barry's IT Development Blog

Search This Blog

Installing mySQL on AWS

Comments

Post a Comment