Install mysql-server
#apt-get install mysql-serverset the root password on the ncurses menu
#apt-get install phpmyadminselect apache2
skip the config-db crap
To set the password for the phpmyadmin setup
#cd /etc/phpmyadmin #htpasswd -b ./htpasswd.setup admin passwordPlease use a descent password instead of password.
If apache2 is setup with virtual hosts and you do not want phpmyadmin to be accessible from every virtual host eg example.com/phpmyadmin move phpmyadmin.conf off /etc/apache2/conf.d
If not, you are done and you can login at http://example.com/phpmyadmin or http://192.0.2.34/phpmyadmin. and access the phpmyadmin setup at http://example.com/phpmyadmin/setup or http://192.0.2.34/phpmyadmin/setup
To setup phpmyadmin using the web interface
- login at https://example.com/phpmyadmin/setup with 'admin' and 'password'
- make the phpmyadmin/config.inc.php group writable ... just run
#/usr/sbin/pma-configure
- Set whatever you want to set through the web interface
- Secure the phpmyadmin/config.inc.php again ... just run
#/usr/sbin/pma-secure
So, to enable phpmyadmin for just one virtual host.
#cd /etc/apache2/conf.d/ #rm phpmyadmin.conf #/etc/init.d/apache2 restartNow enable phpmyadmin for the virtual host by adding
Include /etc/phpmyadmin/apache.confto the virtual host configuration file eg
#echo "Include /etc/phpmyadmin/apache.conf" >> /etc/apache2/sites-available/some-virtual-host.example.com.conf #/etc/init.d/apache2 reload
phpmyadmin debian ubuntu