You can start managing your database server from a Web dashboard and stress less on mastering MySQL command line.Tutorial to learn the steps for installing phpMyAdmin on Ubuntu 22.04 LTS Jammy JellyFish using Apache Web server for managing MariaDB or MySQL via web browser and graphical user interface. You now have a phpMyAdmin installed on Debian 10 / Debian 11. PHP OOP: Object Oriented Programming for beginners + Project.PHP with Laravel for beginners – Become a Master in Laravel.The Complete PHP Full Stack Web Developer Bootcamp.PHP for Beginners – Become a PHP Master – CMS Project.It looks something like this: PHP Web Programming Video Courses: ![]() PhpMyAdmin dashboard is displayed upon a successful login. sudo systemctl restart apache2 Step 6: Visit phpMyAdmin Web interfaceĪccess phpMyAdmin Web interface on Use your database credentials – username & password to login. 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. VERSION="$(echo $DATA | cut -d ' ' -f 1)" 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 Web Server on Debian system by running the following commands sudo apt-get -y install wget apache2 Step 4: Install phpMyAdmin on Debian 10 / Debian 11 You are free to choose whichever web server you prefer though, e.g Nginx. If you don’t have existing Database server to manage, you can use our guide to install MariaDB database server on Debian.įor this installation setup, we chose Apache as a web server to use with phpMyAdmin. ![]() Sudo apt -y install wget php php-cgi php-mysqli php-pear php-mbstring libapache2-mod-php php-common php-phpseclib php-mysql Step 2: Install MariaDB Database Server Install it using our guide below.įor simplicity, the commands below can be executed to install PHP and extensions required. PHP is the main software requirement for running phpMyAdmin. Step 1: Install PHP on Debian 11 / Debian 10
0 Comments
Leave a Reply. |