Difference between revisions of "Creating the Wordpress Database and User Account using PhpMyAdmin"

From MediaSmartServerWiki
Jump to: navigation, search
(Created page with 'After installing Wordpress on Windows Home Server, you need to create a database and a user account before running Wordpress for the first time. First, you need to logon to PhpM…')
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
After installing Wordpress on Windows Home Server, you need to create a database and a user account before running Wordpress for the first time.
 
After installing Wordpress on Windows Home Server, you need to create a database and a user account before running Wordpress for the first time.
  
First, you need to logon to PhpMyAdmin. If you have installed MySql using the MySql Installer for WHS Add-In, you can do this by running https://''servername''/pma (replace ''servername'' with your own servers name).
+
If you have installed MySql using the MySql Installer for WHS Add-In, you can do this by running https://''servername''/pma (replace ''servername'' with your own servers name).
 +
 
 +
You need to logon as "root" to PhpMyAdmin (if you used the MySql Installer for WHS, the default "root" password is blank, and I advise you to change this on the first page after you logon).  
  
 
[[File:Wordpress_Database.png|800px]]
 
[[File:Wordpress_Database.png|800px]]
Line 8: Line 10:
 
Now, refer to the screen print above and follow each step highlighted in Red.
 
Now, refer to the screen print above and follow each step highlighted in Red.
  
* Step 1 - Click on '''Privileges''' then click '''Add a new User.'''  
+
* Step 1 - Click on '''Privileges''' then click '''Add a new User.''' (If you don't see the Privileges tab here, you are not logged on as "root".)
 
* Step 2 - Type in your desired '''User name''' (wordpress is a good one) and ensure '''Use text field''' is selected. Ensure '''Host''' is set to '''Local''' from the drop down list and the text box will change to '''localhost''' and enter a '''Password''' and then confirm it in the '''Re-type''' box. Ensure the Password '''Use text field''' is also selected.
 
* Step 2 - Type in your desired '''User name''' (wordpress is a good one) and ensure '''Use text field''' is selected. Ensure '''Host''' is set to '''Local''' from the drop down list and the text box will change to '''localhost''' and enter a '''Password''' and then confirm it in the '''Re-type''' box. Ensure the Password '''Use text field''' is also selected.
 
* Step 3 - Click on '''Create database with same name and grant all priviliges'''.
 
* Step 3 - Click on '''Create database with same name and grant all priviliges'''.

Latest revision as of 12:19, 3 October 2009

After installing Wordpress on Windows Home Server, you need to create a database and a user account before running Wordpress for the first time.

If you have installed MySql using the MySql Installer for WHS Add-In, you can do this by running https://servername/pma (replace servername with your own servers name).

You need to logon as "root" to PhpMyAdmin (if you used the MySql Installer for WHS, the default "root" password is blank, and I advise you to change this on the first page after you logon).

Wordpress Database.png


Now, refer to the screen print above and follow each step highlighted in Red.

  • Step 1 - Click on Privileges then click Add a new User. (If you don't see the Privileges tab here, you are not logged on as "root".)
  • Step 2 - Type in your desired User name (wordpress is a good one) and ensure Use text field is selected. Ensure Host is set to Local from the drop down list and the text box will change to localhost and enter a Password and then confirm it in the Re-type box. Ensure the Password Use text field is also selected.
  • Step 3 - Click on Create database with same name and grant all priviliges.
  • Step 4 - Click on Go.

If you've followed all the steps above you've now created a user account and a database ready for running Wordpress.