Adding phpMyAdmin to your Bubba

A collection of tips on howto tweak your Bubba.
Post Reply
HeSitated
Posts: 30
Joined: 26 Jun 2009, 12:36
Location: Ede, The Netherlands

Adding phpMyAdmin to your Bubba

Post by HeSitated » 21 Jul 2009, 14:33

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
Last edited by HeSitated on 15 Feb 2010, 04:49, edited 1 time in total.

asparak
Posts: 173
Joined: 08 Jun 2009, 07:38

Re: Adding phpMyAdmin to your Bubba

Post by asparak » 05 Nov 2009, 08:59

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
Posts: 6
Joined: 18 Nov 2009, 15:34
Contact:

Re: Adding phpMyAdmin to your Bubba

Post by WimS » 23 Nov 2009, 16:16

@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
Posts: 13
Joined: 24 Jan 2009, 07:01

Re: Adding phpMyAdmin to your Bubba

Post by Mathew » 04 Mar 2011, 07:36

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
Posts: 1547
Joined: 17 Jul 2007, 09:01

Re: Adding phpMyAdmin to your Bubba

Post by Ubi » 05 Mar 2011, 05:26

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
Posts: 14
Joined: 23 Jun 2011, 10:08
Location: Denmark

Re: Adding phpMyAdmin to your Bubba

Post by sortsnak » 25 Jun 2011, 05:42

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
Posts: 1547
Joined: 17 Jul 2007, 09:01

Re: Adding phpMyAdmin to your Bubba

Post by Ubi » 25 Jun 2011, 16:35

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
Posts: 19
Joined: 21 Jun 2011, 04:18

Re: Adding phpMyAdmin to your Bubba

Post by romtoc » 15 Jul 2011, 06:48

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?
Many thanks,
Matei Cristian Dumitru
http://www.romtoc.net/

Post Reply