official download page<\/a>.<\/p>\n\n\n\nNow, download the phpMyAdmin binary file as follows:<\/p>\n\n\n\n
$ wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/5.1.1\/phpMyAdmin-5.1.1-all-languages.tar.gz<\/code><\/p>\n\n\n\n <\/figure>\n\n\n\nNext, extract the tarball file to the\/var\/www\/html\/phpmyadmin <\/code>path.<\/p>\n\n\n\n$ sudo tar -xvf phpMyAdmin-5.1.1-all-languages.tar.gz -C \/var\/www\/html\/phpmyadmin \u2014-strip-components 1<\/code><\/p>\n\n\n\nTo ensure everything went well, verify the contents of the directory.<\/p>\n\n\n\n
$ ls -l \/var\/www\/html\/phpmyadmin<\/code><\/p>\n\n\n\n <\/figure>\n\n\n\nNext, restart Apache and MariaDB server services.<\/p>\n\n\n\n
$ sudo systemctl restart httpd<\/code><\/p>\n\n\n\n$ sudo systemctl restart mariadb<\/code><\/p>\n\n\n\nAt this point, you are ready to access and enjoy the benefits phpMyAdmin provides. <\/p>\n\n\n\n
Step 4: Access phpMyAdmin<\/strong><\/h2>\n\n\n\nFinally, to access phpMyAdmin, launch your browser and browse the URL below. This is the public DNS or elastic IP of your EC2 instance.<\/p>\n\n\n\n
http:\/\/server-ip\/phpmyadmin\/<\/code><\/p>\n\n\n\nThe phpMyAdmin login page should come into view as shown.<\/p>\n\n\n\n <\/figure>\n\n\n\nProvide MariaDB\u2019s root user\u2019s credentials (i.e., the root username and password) and hit ENTER<\/code> or click on the \u201cGo<\/code>\u201d button.<\/p>\n\n\n\n <\/figure>\n\n\n\nThis ushers you to the phpMyAdmin dashboard (see figure below). <\/p>\n\n\n\n <\/figure>\n\n\n\nDefault databases that ship with the MariaDB or MySQL database server are listed on the left sidebar. You can click on the [+] sign to collapse and view the tables associated with individual databases.<\/p>\n\n\n\n
At the far right you will find information about the database server, web server, and phpMyAdmin.<\/p>\n\n\n\n
The top bar provides you with options you can use to manage your databases and tables, user accounts, and other settings.<\/p>\n\n\n\n
To run an SQL query, click on the \u201cSQL\u201d tab. On the editor provided, run your preferred SQL query. For example, we will create a new database called jumpcloud_db <\/code>as follows:<\/p>\n\n\n\nCREATE DATABASE jumpcloud_db;<\/code><\/p>\n\n\n\nThen click the \u201cGo<\/code>\u201d button to execute the query.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe query runs successfully, and the new database is listed among the default databases as shown here:<\/p>\n\n\n\n <\/figure>\n\n\n\nConclusion<\/strong><\/p>\n\n\n\nphpMyAdmin is a lightweight and user-friendly graphical tool that simplifies the management of databases in MySQL and MariaDB. It provides all the tools you need to seamlessly manage your databases and tables, and configure other database-related settings. <\/p>\n\n\n\n
For users who prefer a graphical environment for managing their databases, phpMyAdmin is a great choice.<\/p>\n\n\n\n
For IT admins who are looking for additional ways to simplify their cloud infrastructure management as a whole and secure access to databases and other servers, JumpCloud can help. <\/p>\n\n\n\n
Learn more about how our cloud directory platform can be leveraged to automate server management<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"Ready to simplify database management? Learn how to install phpMyAdmin on your Amazon EC2 instance in this tutorial.<\/p>\n","protected":false},"author":150,"featured_media":61996,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_oasis_is_in_workflow":0,"_oasis_original":0,"_oasis_task_priority":"","inline_featured_image":false,"footnotes":""},"categories":[23,2337],"tags":[],"collection":[2778,2777],"platform":[],"funnel_stage":[3017],"coauthors":[2535],"acf":[],"yoast_head":"\n
How to Install phpMyAdmin on Amazon Linux 2 - JumpCloud<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n \n \n \n\t \n\t \n\t \n