PHPMyadmin is an invaluable tool for managing MySql databases. Installing PhpMyadmin on your VPS is very easy: (i) Go to the PHPMyadmin site to see which is the latest version. Currently, it is 3.5.1-all-languages.tar.gz. So, lets download the file: wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.1/phpMyAdmin-3.5.1-all-languages.tar.gz Now unpack it: tar xvfz phpMyAdmin-3.5.1-all-languages.tar.gz It will unpack to a folder called phpmyadmin
Category: Uncategorized
Create a phpinfo file
A php info file is one that gives you a wealth of information on your installation. To create the file, open notepad and enter the following code in it. Save the file as phpinfo.php and upload it to the root of your site so that it is accessible through the browser. Access the phpinfo.php file
Nginx WordPress Permalinks
If one use apache, then there is nothing to worry about about WordPress Permalinks because Apache’s mod_rewrite enables WordPress to add the rewrite rules to the .htaccess file. If you are using nginx, then a slight modification is required to be made to the config file. It is very easy to do. (i) Find the
WordPress Theme: Show Only Excerpt On Home Page
WordPress Theme: How to show only the excerpt on the home page instead of the entire post: By default the twentyten theme shows the entire post on the front page. This can be controlled by using the “more” tag in the post so that only the text upto the “more” tag is shown and a
Why the new bitly design sucks
Bitly is my favourite url shortener. A few things I like particularly about it are: (i) it has had a very simple & uncluttered design; (ii) you can customize the shortened url. So instead of some gibberish like bit.ly/xyres, you can use bit.ly/cool_post(iii) you can monitor the number of clicks each link is getting and
How To Modify the Default TwentyTen WordPress Theme
The TwentyTen Theme that comes as a default theme with wordpress is a very popular theme because it is simple and elegant. If you would like to modify the theme, here are the steps you have to follow: (If you have the proper tools, life becomes easier. The recommended tools are Macromedia dreamweaver (trial version
How To Create Your Own WordPress Theme
To create your own wordpress theme, you will need the following: (i) A theme which serves as an inspiration. Choose your favourite site, which gets 1 million page views a day. The advantage of selecting a well known site is that their coding is usually upto date. Also, because several people work on these sites,
Cannot establish FTP connection to an SFTP server. Please select proper protocol
When you try to access your VPS through filezilla by putting the host as “ftp.mysite.com” instead of sftp://ipaddress you will get the error: Cannot establish FTP connection to an SFTP server. Please select proper protocol This means that you have not installed ftp on your VPS. While ftp is frowned upon and the best way
Set Up A WordPress VPS With Centos & Apache
Lets learn how to set up a VPS with Apache & PHP & install WordPress in it. (i) Choose Centos 6 32 bit as your operating system (OS) from your VPS’ control panel; (ii) Update Centos with the command yum update (iii) Install apache with the command yum install httpd (if you run into a
Create MySQL database with SSH command
MySQL databases can be created either through phpmyadmin or through the SSH command line Lets see how to create a MySQL database with SSH command (i) First log in to mysql with your user name (change if not root). You will be prompted for a password. mysql -u root -p (ii) create the database with