-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlog_primary.txt
84 lines (68 loc) · 2.71 KB
/
log_primary.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
Using username "ec2-user".
Authenticating with public key "udacitykey"
__| __|_ )
_| ( / Amazon Linux 2 AMI
___|\___|___|
https://aws.amazon.com/amazon-linux-2/
[ec2-user@ip-10-1-11-248 ~]$ mysql -u admin -p -h primarydatabase.cxg1bukibqet.us-east-1.rds.amazonaws.com
-bash: mysql: command not found
[ec2-user@ip-10-1-11-248 ~]$ sudo yum install mysql
Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.68-1.amzn2 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mariadb x86_64 1:5.5.68-1.amzn2 amzn2-core 8.8 M
Transaction Summary
================================================================================
Install 1 Package
Total download size: 8.8 M
Installed size: 49 M
Is this ok [y/d/N]: y
Downloading packages:
mariadb-5.5.68-1.amzn2.x86_64.rpm | 8.8 MB 00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 1:mariadb-5.5.68-1.amzn2.x86_64 1/1
Verifying : 1:mariadb-5.5.68-1.amzn2.x86_64 1/1
Installed:
mariadb.x86_64 1:5.5.68-1.amzn2
Complete!
[ec2-user@ip-10-1-11-248 ~]$ mysql -u admin -p -h primarydatabase.cxg1bukibqet.us-east-1.rds.amazonaws.com
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 8.0.20 Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> use udacity
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 [udacity]> SHOW TABLES;
+-------------------+
| Tables_in_udacity |
+-------------------+
| test |
+-------------------+
1 row in set (0.01 sec)
MySQL [udacity]> CREATE TABLE udacity (course VARCHAR(10));
Query OK, 0 rows affected (0.08 sec)
MySQL [udacity]> INSERT INTO udacity VALUES ('cloudarchitect');
Query OK, 1 row affected, 1 warning (0.02 sec)
MySQL [udacity]> SELECT * FROM udacity
-> ;
+------------+
| course |
+------------+
| cloudarchi |
+------------+
1 row in set (0.00 sec)
MySQL [udacity]>