29Jun 2012 by Asim Zeeshan No Comments

cPanel/WHM 11.30 now supports MySQL TRIGGERS and VIEW privileges

News
I just noticed that cPanel/WHM 11.30 now supports MySQL TRIGGERS and VIEW privileges. From the official release notes In 11.30 we are adding support for the MySQL TRIGGER and VIEW privileges. Systems using MySQL 5.0 and higher can use the VIEW privilege. This privilege will grant the database user the CREATE VIEW and SHOW VIEW MySQL privileges. When using MySQL 5.0, the SUPER privilege is required for the TRIGGER privilege. Due to this caveat, we will not support the TRIGGER privilege on systems using MySQL 5.0. Systems using MySQL 5.1 and higher can enable and use the TRIGGER privilege. However, this privilege is not available if binary logging is enabled for the MySQL service. Neither TRIGGER nor VIEW is available to systems using MySQL 4.0 or 4.1.
Read More
19Jul 2010 by Asim Zeeshan 6 Comments

Installing Lighttpd, PHP and MySQL on Ubuntu

How to, Linux, OpenSource, PHP, Tips and Tricks, Tutorials, Ubuntu, Virtual Private Server
If you are not getting a package on Ubuntu, please check to see if your /etc/apt/sources.list file is updated. This is common with most VPS providers On VPS, especially with challenging small memory limit (e.g. 64MB or 128MB) lighttpd is the best option instead of Apache. In this article I will show you how to do that. On a fresh box (which has no apache installed) type this to get lighttpd webserver installed Now install PHP5 CGI package and PHP5 command line package Edit the following file and uncomment this line Now enable fastcgi module Restart Lighttpd You get the welcome page Lets install MySQL 5.1 server and client and optionally phpMyAdmin Now create a test page to see if phpinfo is all Ok Type in the following
Read More
15May 2010 by Asim Zeeshan 6 Comments

Good bye CentOS! Hello Ubuntu

CentOS, Linux, PHP, Reviews, Tips and Tricks, Ubuntu
Its been about almost more then two years since I have been playing with CentOS on many different platforms etc. Its very stable but on the other hand, PHP/MySQL updates are very hard to get and still PHP is 5.1.6. I tried EPEL repo and it updated PHP to 5.3.1 but still there were conflicts with stuff and many core packages. So, I thought why not move to Ubuntu since it has just announced 10.04LTS (Long Term Support) in April 2010. Folks at iWeb were really nice to do a reinstall without any charges and also process a memory upgrade request at an amazing 50% discount. Ubuntu 10.04 LTS Apache 2 version is 2.2.14 PHP version is 5.3.2 MySQL version is 5.1.41-3ubuntu12 SVN (Subversion) version is 1.6.6 As a comparison…
Read More
08Apr 2010 by Asim Zeeshan No Comments

How to solve ‘You do not have sufficient permissions to access this page.’ in WordPress

How to, Tutorials
I have been getting the following error because I changed the database table prefix You do not have sufficient permissions to access this page. The cause of the problem is that you have changed the database prefixes but still, some of the word press config is tied down to the previous prefix (wp_ or something) Just execute the following two queries
Read More
02Jul 2009 by Asim Zeeshan 2 Comments

How to Install Apache, PHP and MySQL on CentOS

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials
I have seen people installing Apache, PHP and MySQL from source code on a production server. You should NEVER, NEVER, NEVER install these packages from source on an RPM or DEB based Linux distributions. Did I say “NEVER” enough times to make your realize that it is not a good practice? Installing from source is bad idea; there are many reasons for this but the major one is that you will be spending a lot of time keeping the system updated. If you love installing from source then I would suggest using a different distribution e.g. Gentoo. You can build from source if the package is not available in yum but still, try to use “yum” (or “apt-get” on Ubuntu) because it will save a lot of your time when…
Read More
01May 2009 by Asim Zeeshan 6 Comments

Installing MySQL 5.1 on Ubuntu

How to, Linux, Tips and Tricks, Tutorials, Ubuntu
I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0 So this is what I did, its easy and this might help somebody. I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file. (These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version) Now run the following commands Note that you may need to do sudo prefix to these commands if you are using a non-root account. Now lets do…
Read More
09Jan 2009 by Asim Zeeshan 2 Comments

Intall Apache, MySQL and PHP on Ubuntu 8.10

How to, Linux, OpenSource, Resources, Reviews, Tips and Tricks, Tutorials, Ubuntu
WARNING: Please use this method to install Apache, PHP and MySQL because its more suitable for most of your needs and has options to auto-upgrade your installation. The following method is obsolete and not recommended. After trying to install Apache, MySQL and PHP on Ubuntu 8.10 via several methods listed over the web. I opted for xampp package for linux. It is as easy as ABC Download the xampp linux package from their official website (I have selected NCHC, Taiwan as the mirror to download this package, you may try another) Extract the files Chmod the files to have nobody ownership Configure xampp security Start xampp with this command Stop xampp Restart xampp Login to ftp using the username nobody and the password that you have set up in the…
Read More