![]() sudo systemctl restart apache2 Step 6: Visit phpMyAdmin Web interface You can restrict access from specific IP by adding line like below: Require ip 127.0.0.1 192.168.18.0/24 # Disallow web access to directories that don't need it Php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/ĪuthUserFile /etc/phpmyadmin/tup Php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp $cfg = ' H2OxcGXxflSd8JwrwVlh6KW6s2rER63i' Ĭonfigure Temp directory: $cfg = '/var/lib/phpmyadmin/tmp' Step 5: Configure Apache web ServerĬreate phpMyAdmin Apache configuration file: sudo vim /etc/apache2/conf-enabled/nfĪnd paste below contents to the file: Alias /phpmyadmin /usr/share/phpmyadmin sudo cp /usr/share/phpmyadmin/ /usr/share/phpmyadmin/Įdit the file /usr/share/phpmyadmin/ and set secret passphrase: $ sudo vim /usr/share/phpmyadmin/ sudo mkdir /etc/phpmyadmin/Ĭreate phpMyAdmin configuration file. Sudo chown -R www-data:www-data /var/lib/phpmyadminĬreate directory for phpMyAdmin configuration files such as htpass file. sudo mv phpMyAdmin-*/ /usr/share/phpmyadminĬreate directory for phpMyAdmin temp files. Move the resulting folder to /usr/share/phpmyadmin folder. wget Įxtract downloaded Archive: tar xvf Thanks William Desportes for the hint on how to pull the latest release of phpMyAdmin.ĭownload latest version of phpMyAdmin with wget command. ![]() You can check the released of phpMyAdmin from the downloads page. Install Apache on Ubuntu / Debian by running the following commands: sudo apt-get -y install apache2 Step 4: Download phpMyAdmin on Ubuntu 22.04|20.04|18.04 You are free to choose whichever web server you prefer though. MariaDB > Step 3: Install Apache Web Serverįor this installation setup, we chose Apache as a web server to use with phpMyAdmin. Type '\c' to clear the current input statement. Server version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04Ĭopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. GRANT ALL ON mydemo.* TO IDENTIFIED BY ' MyStrongDBPassw0rd' If you don’t have one, you can create a test one.Ĭreate test database and user. You’ll need a non root user to access phpMyAdmin dashboard. Secure your database server: sudo mysql_secure_installation The next step is to install MariaDB database server if you don’t have one already. Sudo apt install -y php php-tcpdf php-cgi php-pear php-mbstring libapache2-mod-php php-common php-phpseclib php-mysql Step 2: Install MariaDB Database Server (Optional) If you choose to go with the version of PHP available in your OS repositories, install it by running commands below in your terminal. ![]() ![]() The version of PHP can be the one available on the repository or a more recent version. Since phpMyAdmin is written in PHP, you need to install it on the host system. The first software requirement for running phpMyAdmin is PHP. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |