How can I manually install and configure a database management GUI tool for Web Hosting instances?

Last Updated: Sep 29, 2017

After you have purchased a Web Hosting instance, the system creates a default database for you to use. You can find the database server connection address, user name, and password information in the Account Information section of the Instance Details page in the Web Hosting console.

dbinfo

The Web Hosting console integrates a graphical Database Management System (DMS) that allows you to define and create tables for your web applications. Currently, Alibaba Cloud only offers a Chinese language interface (English support is in development). However, you can easily install your own database management tool to provide a convenient Web Hosting experience. Two popular tools we recommend are:

  • MySQL-Front

    MySQL-Front is a client for Windows that allows you to manage a local or remote database through a client interface. If you are using a Microsoft Windows system, you can download this free GUI tool from its official website. After installation, you can connect the Web Hosting database by using the connection address, username, and password from Account Information in the Instance Details page.

    mysqlfront

  • phpMyAdmin

    If you don’t want to install a client on your local computer, you can install phpMyAdmin on your Web Hosting instance, and manage database through your web browser.

    phpMyAdmin is free open-source software that can be downloaded here.

    After you download the phpMyAdmin package, you can upload and decompress the .zip package through the File Management in the Web Hosting console.

    extract

    Once uploaded and decompressed the file, locate the file config.default.php in /htdocs/phpMyAdmin/libraries. Download this file, and modify the following information in the file:

    • Modify the MySQL server address to match the database connection address.

      dbhost

    • Modify the MySQL username and password.

      modifypass

      Upload the modified file to /htdocs/phpMyAdmin/libaries. This action overwrites the original file.

    You also can access phpMyAdmin through the web portal and connect to the RDS database using the MySQL username and password previously added to config.default.php.

    phpmyadmin1phpmyadmin2.png

Thank you! We've received your feedback.