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
Have a Mac and need email encryption?
Get GnuPG here:
http://www.versiontracker.com/dyn/moreinfo/macosx/10258
You will need a GUI to manage the keychain:
http://www.versiontracker.com/dyn/moreinfo/macosx/13561
You will need the plugin for Apple Mail called GPGMail:
http://www.sente.ch/software/GPGMail/English.lproj/GPGMail.html
As always, use at your own risk. 
James
For users on a PC, your choices are many but below are the most popular choices:
You can download a 30 day demo of PGP here: (PC & MAC Compatible with support)
http://www.pgp.com/downloads/desktoptrial/desktoptrial2.html
After 30 days you will need to purchase the software. It runs 99.00 for pgp desktop home.
A compatible free GPG/GnuPG program is also acceptable:
http://www.gpg4win.org/ (PC Only, personally tested with Vista/XP)
This software works best with Mozilla ThunderBird:
http://www.mozillamessaging.com/
With an addon called “EnigMail”:
http://enigmail.mozdev.org/home/index.php
James
