mysql

WordPress: Approve all group requests for buddypress from phpmyadmin/backend

 in Applications / CMS / HowTos / Programming / SQL  tagged buddypress / mysql / sql / wordpress by

Execute the following SQL snippet on the database

UPDATE wp_bp_groups_members
SET `is_confirmed` = 1
WHERE 1

Ubuntu Linux: How to install Apache2 – MySQL – PHP (LAMP) phpMyAdmin and fix a few installation errors

 in Applications / Bash / CMS / GNU/Linux / HowTos  tagged apache / apache2 / applications / bash / GNU/Linux / howtos / lamp / mysql / php / phpmyadmin by

We won’t give out pretty much any comments/descriptions for this post because we want to keep it small 🙂

First, install a bunch of stuff:

sudo apt-get install apache2
sudo apt-get install mysql-server
sudo apt-get install php5 libapache2-mod-php5 php5-mysql

Later, restart your apache so that it loads all modules (php, etc)

sudo /etc/init.d/apache2 restart

and if you get the following error:
“Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName” resolve it by adding the line:

ServerName localhost

to the file /etc/apache2/httpd.conf and then try restarting again. (You need root access to edit, if you are not familiar with command line text editors line nano, try sudo gedit /etc/apache2/httpd.conf, gedit is usually available with all gnome installations).

After that, to install phpMyAdmin and make it available at http://localhost/phpmyadmin:

sudo apt-get install phpmyadmin
sudo ln -s /usr/share/phpmyadmin /var/www

(The default MySQL login username ‘root’ and the password is the one you entered during installation in the last step).

Happy developing, hope we helped 🙂