1. Shell into your server.
2. get to the mysql prompt.
mysql -u root -p
mysql>

3. Create the database:
mysql> create database dbname;

(replace dbname with your database name)

4. Now, assign a user/pass to that database:
mysql> GRANT ALL PRIVILEGES ON dbname.* TO dbusername@localhost IDENTIFIED BY ‘goodpasswordhere’;

If you wish to give access to an “external” ip address: 123.123.123.123 do like so…

mysql> GRANT ALL PRIVILEGES ON dbname.* TO dbusername@123.123.123.123 IDENTIFIED BY ‘goodpasswordhere’;

If these lines are wrapped, it should be all on one line.

You could alternatively type it line upon line like so:

mysql> GRANT ALL PRIVILEGES ON dbname.* (hit enter)
mysql> TO dbusername@localhost (hit enter)
mysql> IDENTIFIED BY ‘goodpasswordhere’; (hit enter)

(replace dbname, dbusername, and goodpasswordhere with your desired information)

Now give your client this information: (common information needed for such things like wordpress installations)

host: localhost
database name: dbname
database user: dbusername
database pass: goodpasswordhere

Your done!

James

Quoted from Chad Larsen at www.trustwave.com: 3/23/09

The guidance on storage is that you can only store the first six and last
four and not have to comply with the encryption requirement. How that is
broken up is not a consideration, but I wouldn’t think that one could get
away with separating the PAN up and simply storing it in two locations
unless it was just the first six or last four. PGP and GNUPG implementing
strong cryptography are acceptable solutions but the key management becomes
a challenge.
—————–

James

Step by step…

1. Delete what you have currently uploaded. it will never work.
2. get the admin login for the existing wordpress website on their current host.
3. If they have wordpress 2.7.1 (latest) on the left side go to “Tools”.
4. Click on “Export”.
5. Save file to your local machine.
6. Ftp into their current host, browse to this directory: /wp-content/themes
7. Download all theme directories using “automatic”. There are mixture of images and php files.
8. Install a new wordpress website blog on new account.
9. Then you login to the new blog admin, click on “Tools”.
10. Click on Import. At bottom of that page, click on “WordPress”.
11. Import the file you previously exported on step 4-5.
12. Ftp into your new account, browse to /wp-content/themes
13. Upload the theme directories you downloaded in step 7.
14. Click on Appearance
15. Find the theme that matches their current site. Click on it and apply it.

You should be done. No promises but that is the logical migration steps to migrate an existing wordpress website.

James