Email This List Email This List Print This List Print This List

Installing phpMy­Ad­min on Ajenti V

Intro­duc­tion

phpMy­Ad­min is a free, web-facing con­trol pan­el that can access and edit MySQL data­bases hos­ted on your serv­er. It integ­rates with all exist­ing and future data­bases on your Ajenti serv­er auto­mat­ic­ally.

phpMyAdmin main screen

This tutori­al will show you integ­rate phpMy­Ad­min into the Ajenti con­trol pan­el.

Pre­requis­ites

Step 1 — Cre­at­ing the Web­site in Ajenti V

Before installing phpMy­Ad­min, you need to cre­ate the web­site for it in Ajenti.

In your browser, browse to your Ajenti con­trol pan­el at https://panel.example.com:8000 (repla­cingexample​.com with your domain name), and log in. In the side­bar to the right, under the Web sec­tion, clickWeb­sites.

Under the New Web­site sec­tion there is a Name text field, type phpMyAdmin and click the Cre­ate but­ton. Under the Web­sites sec­tion on that same page, click Man­age next to the new phpMyAdmin line. On the page that appears, uncheck the box next to Main­ten­ance mode. In the Web­site Files sec­tion below that, change Path from /srv/new-website to /srv/phpMyAdmin. Press the Set but­ton next to that text field. Click Apply Changes at the bot­tom of the screen.

At the top of that page, click the Domains tab. Click Add and replace example.com withphpmyadmin.your_domain_name. Click Apply Changes at the bot­tom of the screen.

Now click the Con­tent tab. Change the drop­down box to PHP FastCGI and click Cre­ate. This basic­ally tells Ajenti to enable PHP for this web­site.

Click Apply Changes at the bot­tom of the screen. Con­fig­ur­a­tion should now be com­plete. You should now be able to install phpMy­Ad­min.

Step 2 — Installing phpMy­Ad­min

To install phpMy­Ad­min, first browse to www​.phpmy​ad​min​.net/​d​o​w​n​l​o​ads and down­load the latest ver­sion of phpMy­Ad­min in a .zip file format, shown high­lighted in blue in the screen­shot below.

Download the latest .zip version of phpMyAdmin

Back in the Ajenti con­trol pan­el, browse to File Man­ager in the side­bar. Use the File Man­ager to browse to/srv. At the bot­tom of the page there is an Upload sec­tion. Click the Choose File but­ton, and select the phpMy­Ad­min zip file you down­loaded. After it fin­ishes upload­ing, click the newly added file, named some­thing like phpMyAdmin-x.x.xx-all-languages.zip. In the mod­al box that appears, click the Unpackbut­ton (high­lighted in blue in the screen­shot below).

Click the Unpack button

When it fin­ishes, click the X but­ton next to Ter­min­al 0 at the top of the screen. You should be taken back to the File Man­ager, and there should be a folder named some­thing sim­il­ar to phpMyAdmin-x.x.xx-all-languages. Click the menu but­ton to the right of that folder.

Click the folder's menu

In the Name text box, rename the folder to phpMyAdmin, and click Save.

Step 3 — Set­ting up a Data­base

We’re going to cov­er set­ting up a data­base in Ajenti, so you can login to phpMy­Ad­min. If you already have a data­base and login, feel free to skip ahead to step 4.

In the Ajenti con­trol pan­el, in the side­bar there is a sec­tion called Soft­ware. Dir­ectly below that is a menu option named MySQL. Click that to access the MySQL con­trol pan­el in Ajenti.

MySQL database controls

Under the Data­bases sec­tion, click the Cre­ate but­ton. There you will be able to enter a name for your data­base. This can be any­thing you’d like. It won’t be seen by any­body but you.

The rest of the sec­tions may auto­mat­ic­ally pop­u­late with default data­bases and users. This is fine, and you don’t need to touch them. Under the Users sec­tion, click the Cre­ate but­ton. The User­name and Pass­wordfields can be whatever you want, this is what you will login to phpMy­Ad­min with, so be sure to remem­ber it or write it down. In the Host­name field, enter localhost.

That should be it, now we can start using phpMy­Ad­min.

Step 4 — Log­ging in

To access the phpMy­Ad­min web inter­face, browse to phpmyadmin.your_domain_name in your web browser. For the User­name and Pass­word fields, enter the cre­den­tials of your MySQL user, and press Go.

Con­clu­sion

Con­grat­u­la­tions! You now have phpMy­Ad­min installed on your serv­er.

Related Post

admin has written 133 articles