The simplest way of selecting random rows from the MySQL database is to use “ORDER BY RAND()” clause in the query. Solution 1 [SQL] SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1; The problem with this method is that it is very slow. The reason for it being so slow is that Read More

Setting the password: 1. From Unix: shell> mysql -u username -h hostname -p password mysql> SET PASSWORD FOR username@localhost=PASSWORD('new_password'); 2. Directly manipulate the privilege tables: shell> mysql -u username -h host -u username -p mysql> UPDATE user SET Read More

Administrator - Somebody who has access to all the administration features Editor - Somebody who can publish posts, manage posts as well as manage other people’s posts, etc. Author - Somebody who can publish and manage their own posts Contributor - Somebody who can write and manage their Read More

This process can be complicated to some people but its very easy as if you use ports to install both programs and follow my simple instructions. First you will need to pick a mysql version that is right for you in /usr/ports/databases/. I would suggest you find the recommended version online that Read More

Source: http://michael.biven.org/2008/01/31/migrating-wordpress-to-a-different-domain-or-server/ All credit and copyright goes to the above site: Two common questions I see both at work and from friends is how best to migrate a WordPress site from one server to another or how to go about changing Read More

Setting the password: 1. From Unix: shell> mysql -u username -h hostname -p password mysql> SET PASSWORD FOR username@localhost=PASSWORD(’new_password’); 2. Directly manipulate the privilege tables: shell> mysql -u username -h host -u username -p mysql> UPDATE user SET Read More