<p>In this post, we will see how to install phpMyAdmin on servers running Nginx. Follow the steps below:</p>
<h2>Step 1 - Installing phpMyAdmin</h2>
<p>Enter the following command to install PHPMyAdmin</p>
<pre class="language-bash"><code>sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl</code></pre>
<h2><img src="https://cwh-full-next-space.fra1.digitaloceanspaces.com/blogpost/install-phpmyadmin-ubuntu-nginx/1.webp" width="927" height="353" /></h2>
<p>&lt;|AD|&gt;</p>
<h2>Step 2 - Configuring MySQL to use a password</h2>
<p>Now we will configure password login to MySQL for logging into PHPMyAdmin</p>
<p>Open MySQL console</p>
<pre class="language-bash"><code>sudo mysql</code></pre>
<p><img src="https://cwh-full-next-space.fra1.digitaloceanspaces.com/blogpost/install-phpmyadmin-ubuntu-nginx/2.webp" width="944" height="375" /></p>
<p>and execute the following query to create a new user to be used for PHPMyAdmin.&nbsp;</p>
<pre class="language-bash"><code>CREATE USER 'harry'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'MyStrongPassword1234$';
</code></pre>
<p>This creates a new MySQL user named harry with the password - 'MyStrongPassword1234$'</p>
<p>Let's provide this user all the privileges so that we can use it to access the PHPMyAdmin console. Execute the query below</p>
<pre class="language-bash"><code>GRANT ALL PRIVILEGES ON *.* TO 'harry'@'localhost' WITH GRANT OPTION;
</code></pre>
<p>Let's exit the MySQL console now</p>
<pre class="language-bash"><code>exit
</code></pre>
<p>&lt;|AD|&gt;</p>
<h2>Step 3 - Create a symlink</h2>
<p>You&rsquo;ll now need to create a symbolic link from the PHPMyAdmin files to Nginx&rsquo;s document root directory. This will tell Nginx where PhpMyAdmin files are and how to serve them!</p>
<pre class="language-bash"><code>sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
</code></pre>
<h2>Step 4 - Check the installation</h2>
<p>Restart Nginx using the command below:</p>
<pre class="language-bash"><code>sudo service nginx restart</code></pre>
<p>Now go to the http://&lt;your-server-ip&gt;/phpmyadmin from your browser and login using the username and password you used in step 2.</p>
<p><img src="https://cwh-full-next-space.fra1.digitaloceanspaces.com/blogpost/install-phpmyadmin-ubuntu-nginx/3.webp" width="838" height="436" /></p>
<p>You should be able to see the PHPMyAdmin interface.</p>
<p><img src="https://cwh-full-next-space.fra1.digitaloceanspaces.com/blogpost/install-phpmyadmin-ubuntu-nginx/4.webp" width="864" height="387" /></p>
<p>You should now have phpmyadmin configured on your server. You can use this interface to easily create, manage and update your databases. Happy coding!</p>
<p>&nbsp;</p>

How to install PhpMyAdmin on Ubuntu running Nginx (LEMP stack)

Add a new comment