Adding phpMyAdmin to your Bubba

[HeSitated]

If there are users like me, who can't get phpMyAdmin configured, here is how i solved it.

First of all:

Code: Select all

apt-get install phpmyadmin


If you can't open it in your browser (http://bubba/phpmyadmin)

Log in as root and run the following command:

Code: Select all

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf


Now you have to check /etc/apache2/apache2.conf if it contains the following line:

Code: Select all

Alias /phpmyadmin /usr/share/phpmyadmin


With many thanks to Jaap-Jan

[asparak]

If you installed phpmyadmin in your Debian and you receive this kind of errors:

Not replacing deleted config file /etc/phpmyadmin/apache.conf
Not replacing deleted config file /etc/phpmyadmin/config.footer.inc.php
Not replacing deleted config file /etc/phpmyadmin/config.header.inc.php
Not replacing deleted config file /etc/phpmyadmin/config.inc.php
Not replacing deleted config file /etc/phpmyadmin/htaccess
Not replacing deleted config file /etc/phpmyadmin/apache.conf
Not replacing deleted config file /etc/phpmyadmin/config.footer.inc.php
Not replacing deleted config file /etc/phpmyadmin/config.header.inc.php
Not replacing deleted config file /etc/phpmyadmin/config.inc.php
Not replacing deleted config file /etc/phpmyadmin/htaccess

Do as follow:

apt-get remove phpmyadmin
dpkg -P phpmyadmin
apt-get install phpmyadmin

and you will see this text as output:

Creating config file /etc/phpmyadmin/apache.conf with new version

Creating config file /etc/phpmyadmin/config.footer.inc.php with new version

Creating config file /etc/phpmyadmin/config.header.inc.php with new version

Creating config file /etc/phpmyadmin/config.inc.php with new version

Creating config file /etc/phpmyadmin/htaccess with new version

[WimS]

@HeSitated: Thanks for the advice. I had to restart the apache server to make it work though (/etc/init.d/apache2 restart)

Greetings...
Wim

[Mathew]

Does this HowTo apply to B3 users aswell?

I mean, in the process of getting phpMyadmin/PHP-fusion to work I loose some features in B3 webadmin like the update. As far as I know you have to set root password to mysql to be able to setup/login phpmyadmin. It simply won't accept empty password for root as B3 does.

So question is, how do I get B3 to work with a new password without loosing features in webadmin?
I have tried to setup a new phpMyadmin user without any luck.

Those who got this setup, did you have to choose between features and phpMyadmin/PHP-fusion?

Thanks!

[Ubi]

if the B3 root process invokes shell you can use /root/.my.cnf and put the passwd there.

But phpadmin does not require a password for root. In fact, it does not even recognize the root user. You can have multiple "root"-like users on the system, none of which are called root. I have the feeling you did not read or config phpmyadmin properly. When you do, make sure root is not able to use phpmyadmin or you give the world free reign on your db server

[sortsnak]

Not to go offtopic on installing phpMyAdmin.
However I want to warn users against it, unless you REALLY know what you are doing.
After a some personal experinces with phpMyAdmin thru the years all I can say is that it's insecure. I've seen crackers wipe entire MySql DB's with phpMyAdmin just by using sql injections.
So if you really want to use it, do everything you can to deny access from 'the outside', and secure it so only you and whom ever you trust can access it.

[Ubi]

When set up with user authentication phpmyadmin is as weak as your password. All the vulnerabilities was with people that had fixed passwords. If you use htaccess authentication there 's no sql injection possible at all.

[romtoc]

but why install phpMyAdmin with the "apt-get" command, when you could just download the zip/tar-gz from www.phpmyadmin.net and put it in your /home/web/ directory?