![]() MySQL Workbench is a visual tool for database administration. +-+-+ | id | name | +-+-+ | 1 | Joe | | 2 | Jane | | 3 | Jack | | 4 | Jessica | +-+-+ 4 rows in set (0.00 sec) STEP D: Installing MySQL Workbench for Easier Management You must see a small table like the following in your MySQL application. INSERT INTO test_table1 VALUES(1, 'Joe'), (2, 'Jane'), (3, 'Jack'), (4, 'Jessica') Īnd finally, let’s display all data in the table to make sure that nothing went wrong. Let’s insert some dummy data into our database too. CREATE DATABASE mysql_test USE mysql_test CREATE TABLE test_table1 (id INT, name VARCHAR(45)) If you are not familiar with SQL, I highly recommend taking these three courses, but you can continue for now.įirst, let's make a dummy database ( mysql_test) and a dummy table ( test_table1) inside our database. STEP C: Making a Dummy DatabaseĪlthough it is not necessary for this section, I assume that you are familiar with SQL commands. mysql> exit $ sudo mysql -u root -pĮnter your root password, and hopefully, you get back to your MySQL command line. Now, let’s exit and log in with the root credentials. mysql> ALTER USER IDENTIFIED WITH mysql_native_password BY 'your_password_here' mysql> FLUSH PRIVILEGES Replace your_password_here with a strong password. You must set a password for your root now. It must return some information about the MySQL server, such as Active: active (running). ![]() You can check it with the following command. sudo apt update sudo apt install mysql-serverĪs soon as your installation is complete, the MySQL server should run automatically. My preferred way is to use APT package repository management tool. If you successfully built and connected to your EC2 instance, it is time to install the MySQL Server on your instance. STEP B: Installing MySQL on your AWS EC2 instance. cd test_mysql_aws chmod 400 my_test_key.pem ssh -i “my_test_key.pem” you can find full instructions when you click on Connect in your EC2 dashboard. For me, I saved my key file ( my_test_key.pem) inside a folder called test_mysql_aws. Open a terminal and go to the folder that contains your AWS key file (.pem file). Some Windows users should enable/install SSH Client on their computer before start using it. If you have a system with Linux, Mac, or Windows 10 (or higher), you must have “SSH Client” installed and ready to go. Here, I am following the same instruction.īasically, you need a tool called SSH Client to connect to your EC2 machine securely. Choose “SSH client” from the opened page, and you should see full instructions on how to connect to your instance.
0 Comments
Leave a Reply. |