![]() If you use that part, make sure to change the fastcgi_pass directory with the path of your php-fpm. php directives are quite long – to make it as plug-and-play when you paste this configuration in your server, feel free to use your existing. Find a partner Become a partner UGURUS Elite training for agencies & freelancers. Partners Work with a partner to get up and running in the cloud, or become a partner. Once done, you can create the NGINX configuration file for it. The Wave Content to level up your business. You need to set the following in your Domain DNS records. To add access to PHPMyAdmin using a Subdomain in your Nginx config. To avoid this, use a subdomain to access it. We don’t recommend accessing your PHPMyAdmin with a plain IP Address, we have a bad experience on Google Chrome that will mark your IP Address as unsafe and dangerous when using PHPMyAdmin. Let’s proceed with accessing it on the web. That’s it for setting up the basics of PHPMyAdmin. GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION CREATE USER IDENTIFIED BY 'Your_Password' If you got an error saying “ERROR 1064 (42000): You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near ‘identified by XXXXXXXX at line 1”. ![]() grant all privileges on *.* to identified by "Your_Password" You need to create one in mysql -u root -p. Unfortunately, root access is not allowed here. Lastly, create a MySQL user to access the PHPMyAdmin. Then fill up the $cfg with the host connection, if your MySQL is installed in the server, just use localhost. Then let’s edit the, make sure to edit the $cfg with your own value. Let’s move all of the files in the parent directory. If you haven’t installed unzip yet, just install it sudo apt-get install unzip. Then let’s download the latest PHPMyAdmin files. Let’s go to the folder that we just created. sudo chown -R www-data:www-data /var/phpmyadmin mkdir /var/phpmyadminĪssign www-data as the owner of the directory. To install PHPMyAdmin to your NGINX, open up the SSH console command and connect it to your server.įirst, we need to create a folder for our PHPMyAdmin. In this guide, we will show you how to download it from the official source and how to add access to it for the web. ![]() As of writing, the latest version is PHPMyAdmin 5.0.4. The best alternative solution is to install it from the original itself at which also has the latest built version. But the problem is it only comes with packages for Lighttpd or Apache, it does not support Nginx. Ubuntu has a PHPMyAdmin included in their repository and you can install it directly from the console command. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |