![]() ![]() REMEMBER: For this demo, we install MySQL Workbench on our local computer and not on the EC2 instance.Īfter installing MySQL Workbench on your local system, you should see a first page like the following figure.Let’s create a Schema in your MySQL Workbench on Mac OS. This link also can help you to complete the installation. The installation is easy, straightforward, and just a few clicks away. You can download and install the application from here. Let’s use this powerful tool to access and manage our MySQL database on the AWS EC2 instance that we just built. We can install this application on our local computer and manage any local or remote databases. It helps you to do complex database management tasks in a short time without sacrificing any flexibility. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |