How to setup wordpress on the CentOs server

First you have to download the wordpress, create the database and configure as required.

Mostly we require a theme to install on wordpress, database and some data :-)

Downalod the latest wordpress code with

wget http://wordpress.org/latest.zip

Its easy to set connect data base and operate on it using the sqlyog. So if you want to do lot of activity on database then I suggest to go for sqlyog.

Now Unzip the latest.zip wordpress file using the command > unzip latest.zip

Move the wordpress folder to www directory

mv wordpress/ /var/www/

Now add the site to your httpd config file

 

Change the server folder permissions to the below

Find all directories in this directory and set their permissions to 755:

sudo find . -type d -exec chmod 755 {} \;

Do it again, but for files and 644:

sudo find . -type f -exec chmod 644 {} \;

Give the uploads folder back to apache (or www-data):

sudo chown -R apache:apache ./wp-content/uploads

In my case, I also needed to give existing folders starting with backup- back to apache as well, as that’s where our backup plugin placed its database backups:

sudo chown -R apache:apache ./wp-content/backup-*

Finally, if it’s a Multisite install, give the blogs.dir directory back as well:

sudo chown -R apache:apache ./wp-content/blogs.dir
That should do it. No guarantees that you’ll never be hacked again, but it should certainly be less likely.

 

 

 

Linux , Comments Off

How to setup Centos to run wordpress on dedicated server or virtual private server

Initally Cent Os should be ready to use. Login to the server as admin.

Follow the steps below to install Apache, Mysql and PHP

  1. sudo yum install httpd
  2.  sudo service httpd start
  3. To know your server ip address use this command -  ifconfig eth0 | grep inet | awk ‘{ print $2 }’
  4. Install Mysqld - sudo yum install mysql-server
  5. sudo service mysqld start
  6. sudo /usr/bin/mysql_secure_installation
  7. sudo yum install php php-mysql

For more information you can visit

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-centos-6

Linux , , , Comments Off

what’s the error code for Unique Index Voilation:

-803

DB2 Comments Off

what’s the best locksize that you could use when you create a tablespace?

The answer is Locksize = ANY.Unless you are Sure what’s the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically determine what type of locks it should use.

DB2 Comments Off

What is the size of a data page?

4K to 8K

DB2 Comments Off

The only place of VSAM KSDS in DB2 is?

BSDS is a VSAM KSDS.

DB2 Comments Off

MAX. NO OF ROWS PER PAGE

127

DB2 Comments Off

What is EXPLAIN in DB2

EXPLAIN is used to detail the access paths chosen by DB2 optimizer for SQL statement. This command is used to monitor the performance of SQL statement used in a program.
Answer: BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.

DB2 Comments Off

What is a lock?

A lock is the mechanism that controls access to data pages and table spaces.

DB2 Comments Off

What is a Cartesian product?

A Cartesian product results from a faulty query It is a row in the results for every combination in the join tables.

DB2 Comments Off