PhpMyAdmin
PhpMyAdmin is open-source tool written in php to handle the multiple MySQL servers administration through web browser. PhpMyAdmin supports a wide range of operations on MySQL such as creating, modifying or deleting databases, tables, rows, indexes, permissions, uses, etc and executing SQL statements. PhpMyAdmin also provides intuitive web interface to export and import data from CSV and MYSQL. App42 PaaS lets you create PhpMyAdmin server on the cloud with just a few clicks and in no time.
In order to create your private setup of PhpMyAdmin, following steps are to be done:
- Login with your account on App42 PaaS
Use your credentials to login into App42 PaaS.
- Creating your first PhpMyAdmin setup.
Navigate to Application Hosting > Create Setup. Select PhpMyAdmin and enter the mandatory information to create your PhpMyAdmin setup as shown in below image.
- PhpMyAdmin Setup List
Navigate to Application Hosting > Setups. Select Setup Type as “PhpMyAdmin” to see the setup list.
Once you have successfully created your PhpMyAdmin setup, you need to configure it. For this, click the ‘Launch’ link under ‘App Config URL’ on the setup list to see the PhpMyAdmin Setup Dashboard. Since your setup is secured, you need to enter your HTTP Credentials in order to login. Click the icon located under ‘HTTP Credentials’ to get your credentials.
Now use these credentials to login.
Now you have to setup MySQL server in order to get PhpMyAdmin running. Follow these steps in order to setup your MySQL server.
Step 1: Click on ‘New Server’ to configure new server details.
Step 2: Under ‘Basic Settings’ enter your MySQL ‘Hostname’ and ‘Port’.
Step 3: Under ‘Authentication’ enter your MySQL ‘Username’ and ‘password’.
Step 4: Under ‘Configuration Storage’ enter your MySQL ‘Database Name’. Also re-enter your MySQL ‘Username’ and ‘password’. Now click the ‘Apply’ button below.
Now you have successfully setup your MySQL server. You can also save this server for future purpose by clicking on the ‘save’ icon below.
Click ‘save’ to confirm.
Now click the ‘Launch’ link under ‘App URL’ to login to your PhpMyAdmin Dashboard. Enter your MySql Username and Password to enter the dashboard.
Now you have successfully setup PhpMyAdmin.
