MYSQL-for-Wordress « Real Estate Blog Lab

Posts Tagged ‘MYSQL-for-Wordress’

Real Estate Blog Lab Archives

Single Property Sites – Setting up Wordpress

By Dave Smith Monday February 26, 2007

Setting up the wp-configure.php file

Before you can install Wordpress you have to have a valid MYSQL database setup and you have to create the wp-configure.php file.

Here is the current place to go to get The latest version of Wordpress.

Wordpress comes with a wp-sample-configure.php file. You can open this using notepad if you don’t have a file editor for html or php files.

In the previous post Single Property Sites – Hostingwe had you write down the MYSQL database number for our example we are using 159 as the database number.

Here is what it looks like and the highlighted words are the ones you need to fill in.

// ** MySQL settings ** // define('DB_NAME', 'mystreet'); // The name of the database define('DB_USER', 'mystreet'); // Your MySQL username define('DB_PASSWORD', 'listings'); // ...and password define('DB_HOST', 'mysql159.secureserver.net'); // 99% chance you won't need to change this value// You can have multiple installations in one database if you give each a unique prefix $table_prefix = 'wp_'; // Only numbers, letters, and underscores please!// Change this to localize WordPress. A corresponding MO file for the // chosen language must be installed to wp-includes/languages. // For example, install de.mo to wp-includes/languages and set WPLANG to 'de' // to enable German language support. define ('WPLANG', '');/* That's all, stop editing! Happy blogging. */define('ABSPATH', dirname(__FILE__).'/'); require_once(ABSPATH.'wp-settings.php'); ?>

Once you have filled in the information for the database you just created save this file as wp-configure.php

When we set up the hosting we created a folder called “mystreet” this is where we want to upload the Wordpress files including the wp-configure.php file you just edited.

Don’t upload the wordpress folder, just the files inside the folder to the “mystreet” folder you created for the property.

Installing Wordpress

Now comes the easy part of the installation process.

Go to your browser and type in the following

“http://www.domainname.com/foldername/wp-admin/install.php”

If it is a subdomain it will be “http://subdomain/domainname.com/foldername/wp-admin/install.php”

If the configure.php file is right it will install. If not go back and check your database, username, description and password to the database. When it installs you are given the login which is always “admin” and a password to enter.

Write down the password and go ahead and login.

Change the password
Fill in your email address
Change the blog description
Save

The next thing I do is immediately delete the “about” page and “hello world” post and comment. You want to get rid of these right away before they get picked up on the web.

Here is where we are headed

Single site snap shot

It won’t be long and you can have a site up that is your time shifted 24/7 open house.

Setting up Wordpress now begins. Here are some of the things we will be covering.

Set your category names
Set the permalink structure
pick a theme
upload your plugins
activate the plugins

For now:

Go take some good photos of the place
Scan the documents you want to link to
- Seller Property Disclosure Statement
- Lead based paint of if built before 1978
- Run a CMA and convert to pdf if desired
- Create a full color flyer and link to it.
Find the places and activities of interest near the property

That’s enough for now. We will go into each of these in post to follow.

Hey, it might seem like a lot, but in just three posts you’ve learned