Installing phpMyAdmin on Ubuntu with LAMP

If LAMP is already installed on your VPS, we recommend you also to install the phpMyAdmin server for more convenient database management.

1.Run:

sudo apt install phpmyadmin

2.Respond to requests:

Web server to reconfigure automatically:

select apache2, press Enter.

Configure database for phpMyAdmin with dbconfig-common:

Press Enter to select Yes.

MySQL application password for phpMyAdmin:

Create a password to register phpMyAdmin on the database server. Press Enter to confirm. Then re-enter the password.

3. Disenable PHP modules mcrypt and mbstring:

sudo phpenmod mcrypt

sudo phpenmod mbstring

4.Restart your web server:

sudo systemctl restart apache2

You can login to phpMyAdmin at http://IPaddress_server/phpmyadmin

Use your MySQL root username and password to log in.

IMPORTANT!

When installing LAMP in unattended mode, the MySQL root user password is not set.

To create a root password, go to MySQL management:

mysql

Run:

SET PASSWORD FOR 'root' @ 'localhost'= PASSWORD ('my_password');

To exit MySQL:

\ q.

You can also change MySQL root user password.

If you have any questions, please create a ticket to technical support.