6th September 2007

How To Install WordPress on IIS 6.0

posted in IIS 6.0, PHP |

In the final article in this series I am going to demonstrate how to install and configure WordPress on an IIS 6.0 web server. WordPress is a free open source blogging platform which requires both PHP and MySQL and is renowned for its “Famous 5 Minute Installation”. However, it was because the installation was taking considerably longer than 5 minutes that I decided to start writing my own installation guide.

This walkthrough only covers the actual installation and configuration of WordPress itself; it is assumed that you already have PHP and MySQL installed and working correctly on your IIS 6.0 web server. If you have not already installed PHP you can do so by following the steps in this article here (http://www.iisadmin.co.uk/?p=4). If you have not already installed MySQL you can do so by following the steps in this article here (http://www.iisadmin.co.uk/?p=5)

Create the MySQL Database

WordPress uses a MySQL database as the back-end to store its content. To create a new MySQL database open the MySQL Command Line utility and execute the following commands


CREATE USER ‘wordpress’@’localhost’ IDENTIFIED BY ‘wordpress’;

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON `wordpress` . * TO ‘wordpress’@’localhost’;


We have now created a dedicated database which WordPress will use and an associated user account which has permission to add and delete content in that database.

Install and Configure WordPress

In this walkthrough I will be using the latest version of WordPress (2.0.4 at the time of writing) Start by creating a dedicated folder for the WordPress files and then extract the WordPress files into this folder. In this example I am going to extract the WordPress files to ‘C:\wp’

Now rename the file ‘wp-config-sample.php’ to ‘wp-config.php’ and then edit this file to provide the appropriate values for your environment. I have kept things very simple in this example and I have used a database called ‘wordpress’ and created a user called ‘wordpress’ with a password of ‘wordpress’. I am also running MySQL on the web server so my server’s hostname is ‘localhost’. As a result my wp-config.php file looks like this.

Configuring IIS

In this example I am going to host my WordPress blog on the PHP test web site which I created in the previous article (If you haven’t configured PHP and MySQL on your server yet its probably a good idea to read those articles before continuing)

I want to use a unique URL for my blog so I am actually going to create a new virtual directory on that web site for WordPress to use. Right-click on the web site and click New | Virtual Directory which will invoke the Virtual Directory Creation Wizard.

Click Next to specify an alias for the virtual directory. In this example I am going to use the name ‘WordPress’ as my alias.

Pages: 1 2 3

This entry was posted on Thursday, September 6th, 2007 at 2:40 pm and is filed under IIS 6.0, PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

There are currently 67 responses to “How To Install WordPress on IIS 6.0”

Why not let us know what you think by adding your own comment! Your opinion is as valid as anyone elses, so come on... let us know what you think.

  1. 1 On September 19th, 2007, Miguel said:

    I followed all your tutorials step by step, and everything worked smoothly!. I got the wp blog running without any problems!… thanks for the great tutorials.

  2. 2 On October 16th, 2007, Franklin Wise said:

    I agree with Miguel, I followed the steps in all three tutorials and the installation was seamless. Thank you so much for contributing these steps to the community!

  3. 3 On October 28th, 2007, Dustin Earnhardt said:


    First off, I must say you’ve done a fantastic job with this site. I’ve used your guides three times now (the first two with no difficulties at all) to setup a webserver. Unfortunately, on my latest attempt, I’ve hit an odd snag that I can’t seem to fix. I successfully completed parts one and two (setting up PHP and MySQL) and the bulk of part three (this article). I have run through the install script of WordPress and I can get to the admin console, however when I attempt to view my site, I get an HTTP 500 error. I was wondering if you’d be able to perhaps help me troubleshoot this some. Below are some links that may help:

    My PHP Info file:

    My WordPress admin login page: (email me for the password if you think it may help. There’s nothing on this server that is of any importance at the moment so I can send it to you.)

    And the broken main page:

    Any insight you could give me would really help.

    Thanks and keep up the great site!

  4. 4 On October 30th, 2007, Paul Lynch said:

    Hi Dustin,

    Thanks for your kind comments – I appreciate it. Now, if you could enable full logging on your IIS web site and then post the relevant log file extract showing the 500 error I might be able to help you out.

    Paul Lynch

  5. 5 On October 31st, 2007, Dustin Earnhardt said:


    Thanks for the reply but I’ve taken the novice approach to fixing the problem: Reformat and try again.

    Sure enough though, it worked.

    I should mention though two significant differences between your guide and my setup, so that hopefully they will help someone else. First, I’m using Whiist (Windows Home IIS Toolkit) installed on Windows Home Server. All in all, this isn’t a big deal, but one thing worth noting is that Windows Home Server comes with pre-installed with websites to be shared on homeserver.com. That being said, I did not perform the step where you flushed all the application extensions for testing PHP. Instead, I used the GUI to add the .php extension to my site.

    There are two specific things worth noting here about the method I chose to use. First, to add PHP globally to all sites on the server, right click on the “Web Sites” folder (directly under the local computer) and go to properties. Then add the .php extension to the application extensions. The second thing is that you will get a warning message regarding “ScriptMaps” and that certain pre-existing child nodes already define the “ScriptMap” category. If you choose the “Select All” option and redefine the ScriptMap for all the child nodes, you will enable PHP on all the sites, and not just one. (Ultimately, I think this is what really helped me.)

    Anyway, I’m sure what I did makes more sense to you than it did to me when I did it, but hopefully this will help some other readers.

    Thanks again for the excellent walkthroughs!

    Take care,

  6. 6 On December 10th, 2007, Richard said:

    I am having an error with the

    GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON `wordpress` . * TO ‘wordpress’@’localhost’;

    When I type that in I get. “ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”word
    press’ . * TO ‘wordpress’@’localhost” at line 1″

    The only difference that I can between yours and mine is that I am using 5.0.45 of mysql and yours is 5.0.26

    I have tried copying and pasting several times and typed it in manually a few times and always get the same result. Here is a screencap of the error.


  7. 7 On December 18th, 2007, Scott Richmond said:


    I too was having the same problem! After a fair bit of cross-referencing it looks like the syntax error was due to the wrong colans being used. Talk about picky!
    Anywho, the correct line is thus:

    GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON `wordpress` . * TO `wordpress`@`localhost`;

    You can manually type it up. Just make sure you use the ` colan (Located on the tilde key (the key next to the 1 and below the ESC buttons)).

  8. 8 On January 17th, 2008, Corey said:

    Hi there, great tutorial btw. My only question is how can I get it working when my iis is on the C drive and the network guys say that websites need to be on the E drive? I get the “No input file specified.” error when I try to do this.

    PHP is installed on C.
    Mysql is installed on C.

    Thanks in advance.


  9. 9 On January 19th, 2008, daz said:

    thank you for your instruction i once agion insalled yet uing your guide and agian i have the same problem

    my wordpress works using index.php… but i can not login
    when i enter wp-login.php i am redirecfted to wpadmin with the page telling me

    The website declined to show this webpage
    HTTP 403
    Most likely causes:
    This website requires you to log in.

    after following your instructions i did have the login page once but when the details where entered i got the same and since then no login pages

    thanks for your help in this matter

  10. 10 On February 15th, 2008, Ian said:


    I have followed your steps to install PHP, MYSQL and WordPress 2.3.2 on IIS on Win 2003, but in the wordpress admin it takes an age to load the pages.


    If I click on ‘write’ it takes around 30-40 seconds for this page to load.

    Is there anything I can do to speed this up ? and what could be causing this ?


  11. 11 On March 11th, 2008, Tom said:

    I followed every instruction to the “t.” However, when I browse to the site from anywhere except the localhost, I only see a text/html page. The style sheets are not loading. What do I need to do?

  12. 12 On March 28th, 2008, Server Move: Hosting My Own Site(s) - stevienova.com said:

    […] How to Install PHP on IIS 6.0How to Install MySQL On IIS 6.0How to Install WordPress on IIS 6.0 […]

  13. 13 On April 13th, 2008, David said:

    Ran in to problems with this from the off, trying to install this on my local PC. I couldn’t get the command line statements to work, so created a new Catalogue called wordpress and user called wordpress using the MySQL administrator, I assigned the privileges, adjusted things in the wp-config.php and set-up the site in IIS. I preview the page and I get an error: “Error establishing a database connection” – what am I missing?

  14. 14 On April 27th, 2008, Blogs are up and running « Niraj Bhatt’s Personal Blog said:

    […] hours because I would just refuse to read the manuals and nothing involves any .Net but thanks to http://www.iisadmin.co.uk/?p=6 I was eventually able to successfully install and configure PHP, MySQL and WordPress on Windows […]

  15. 15 On April 27th, 2008, Niraj Bhatt said:

    Thanks of this write up as it had help me setting up my blog on IIS.

  16. 16 On May 19th, 2008, Aleem said:

    I am trying to do a step by step of Installing WordPress on IIS on my blog. I am basically documenting all the steps I took to have IIS, DNS, Webmail setup on my site. If anyone wants to use it as a resource its at http://www.aleemonline.com/index.php/hosting-wordppress-with-iis/


  17. 17 On July 22nd, 2008, Jake Scott said:

    Thanks for the awesome tutorial, just wondering if you have the time to do a tutorial on using mod_rewrite to enable pretty urls 🙂


  18. 18 On August 18th, 2008, Darren Kitchen said:

    Thanks, your tutorial was very helpful. PHP version 5.2.6’s windows installer configured with IIS as an ISAPI filter right from the wizard which saved a little time too.


  19. 19 On August 18th, 2008, Darren Kitchen said:

    @Tom, per your problem with the CSS not loading: In the WordPress admin panel go to Settings and under the General tab change the WordPress Address and Blog Address to your domain instead of Localhost. 🙂

  20. 20 On September 24th, 2008, Mike said:

    Followed your example…installing wordpress2.6.1 on iis6.0. Already have php working fine but when I do the install and try to log in as the admin I get a message saying “you do not have sufficient privliges”.

    Have yet to find any resources that address how to solve this issue.


  21. 21 On October 15th, 2008, Rob said:

    Superb tutorials!

    I have run into a problem with the install though. I get this error:

    WordPress database error Table ‘wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1224081955;a:1:{s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) made by add_option WordPress database error Table ‘wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘random_seed’, ‘87456ee01cec4e1a574eeb18bcae9a5b’, ‘yes’) made by add_option WordPress database error Table ‘wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘JNjK!ZYMn%0Z’, ‘yes’) made by add_option

    Has anyone seen this? I googled it, and still haven’t found a resolution yet. Should I just wipe everything and do another install?

  22. 22 On October 29th, 2008, Dan said:

    Awesome tut! One question, have you noticed that you can’t update any of the theme files through the webui theme editor? In IIS 7 I was getting an error (can’t remember what it was now), and in IIS 6 it acts like it modifies it… but then when you refresh the screen and look at the code, no changes actually take.

    Are all the permissions changes you’ve done listed? Do you have the same problem with your installation?

    Thanks again for sharing!


  23. 23 On October 30th, 2008, Paul Lynch said:


    Yes I am aware of this issue. The problem is caused by the fact that the anonymous IUSR account doesn’t have permission to modify your WordPress files (which I think is probably a good thing)

    You can verify this by running Sysinternals’ Process Monitor on your server whilst trying to update a theme using the GUI – you will probably see Access Denied errors in the log.

    My best advice is not to alter this behaviour and only ever upload changes to your WordPress files using an FTP client.


    Paul Lynch

  24. 24 On November 7th, 2008, Welcome - FatFrame.com said:

    […] thank the author of these tutorials: http://www.iisadmin.co.uk/?p=4 http://www.iisadmin.co.uk/?p=5 http://www.iisadmin.co.uk/?p=6 These articles helped me get this site up and hosted personally in less than five hours. The final […]

  25. 25 On November 30th, 2008, DNoble said:

    Thanks for the Step by Step. After following every set of instuctions I could find this was the only set that actually worked with the latest PHP, Latest MYSql, and Latest WordPress. Whis I had found your blog first.

  26. 26 On December 17th, 2008, Dan said:

    An interesting read.

    It’s such a shame that there’s no way to install wordpress if a client is using a shared server Microsoft server. I know have to convince them to change their hosting options. Wish me luck!

  27. 27 On February 4th, 2009, Mitch said:

    Great tutorial, but I’m stuck. I’ve followed your instructions but when I try to browse to http://localhost/worpdress I get an error along the lines of “Fatal Error… Database tables missing”

    I’ve searched high & low for solutions but to no avail. Any help is much appreciated as I’m at my wits end and I would give up now if it wasn’t a task for my job.

    Thanks in advance.

  28. 28 On February 23rd, 2009, Chris said:

    Thanks… your instructions worked a treat. I went round the houses for a few days looking for an alternative .net blog engine because a had problems installing wordpress using their documentation. I found your blog and decided to have another go and bam! all up and running in 15 minutes flat! Please keep up the good work. Maybe WordPress should scrap their famous 5 minute install and link to yours instead.

  29. 29 On March 13th, 2009, Ray said:


    Do you know if you can install WordPress Version 2.7 (Latest) on Windows 2008 IIS server?


  30. 30 On March 13th, 2009, Paul Lynch said:

    Hi Ray,

    Yes, you can install WordPress 2.7 on Windows 2008 (IIS 7.0) – there’s a good guide here :



    Paul Lynch

  31. 31 On April 29th, 2009, Rob said:

    Cheers for this series – you’ve made it painless!
    Thank you very much.

  32. 32 On April 30th, 2009, alf eli said:

    i followed the previouse tutorial everything went well tks ..

    Now i can see php info sql entries etc etc but when i go to C:\Inetpub\wwwroot\wp-admin\install.php go to a blank page thats wired can u pleass iluminate me and suggest what can be wrong pleass ?all php pages i try to access are blank .

    Alf Eli

  33. 33 On May 7th, 2009, Don H said:

    I am (trying to / hoping to) develop a new Webpress website on my local machine (XP Pro SP3) before pushing it to the host. Alas, XP Pro does not support IIS 6. It only has 5.1 and then a scaled down version of that. I’d like to use Xampp/Apache but, at the moment at least, my host only supports IIS.

    Your articles are the only things even close to a clear set of instructions I’ve found on the web, but they are for IIS 6 on Server 2003. How much, if any of it, applies to XP Pro / IIS 5.1?

  34. 34 On May 8th, 2009, James said:

    Hey there,

    I ran across this post while in search of a fix for my plug-ins not updating.

    I assume it’s the same situation with themes not updating/uploading, etc.

    However, I FTP’d my archives to the correct folder, extracted them, etc, and they still don’t show up in wordpress. Any ideas?

  35. 35 On June 27th, 2009, Willow Wright said:

    OK, I’ve followed your instructions, except for creating a Virtual Directory….I’ve got WordPress files installed directly I’m using as the root of the site. I’ve tested PHP and it’s working fine. The site is accessible. I’ve configured the wp-config.php exactly as suggested, except I’ve given it the real names I’ve created for my MySQL database, user and password. And when I attempt to get the install.php file to run, it says, “No input file specified.”

    Do you have any suggestions? I could really use some assistance. Thanks in advance. WCW

  36. 36 On June 27th, 2009, Willow Wright said:

    Please forgive my illiteracy….I meant to say that I’ve got WordPress files placed in the folder that I’m using as the root of this Website.

    I hope that makes better sense. WCW

  37. 37 On July 21st, 2009, WordPress, IIS, Permalinks and index.php | Richard Shepherd said:

    […] are plenty of links out there about how to do this, and the one I referred to most was How To Install WordPress on IIS 6.0. It is, more or less, […]

  38. 38 On July 28th, 2009, Ajay Kumar Pandey said:

    Mr. Paul
    You have done nice work. i follwoed your every step in all three tutorial
    I am able to run the PHP and MySql,
    I am not able to configure the Mysql for PHP
    I am using PHP 5.1.4 and mysql-5.0.83-win32 I have changed the three lines in php.ini and restarted the IIS also. I am not able to locate the problem. When i am accesing the index.php its always shows the PHP page not mysql
    wating for your immediate reply

  39. 39 On August 20th, 2009, Ron Spitzer said:

    I have followed the instructions and get everything up and running but am unable to do a lot of the functions. None of the tinymce editor works and I get errors from all the admin pages. They start with this error and not much else works after that.
    Webpage error details

    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0)
    Timestamp: Thu, 20 Aug 2009 01:06:10 UTC

    Message: Invalid character
    Line: 12
    Char: 293
    Code: 0
    URI: http://rspitzer.homeserver.com:8009/wordpress/wp-admin/load-scripts.php?c=1&load=jquery,utils,quicktags&ver=b64ae9a301a545332f1fcd4c6c5351b4

    Message: Invalid character
    Line: 1
    Char: 300
    Code: 0
    URI: http://rspitzer.homeserver.com:8009/wordpress/wp-admin/load-scripts.php?c=1&load=hoverIntent,common,jquery-color,wp-ajax-response,wp-lists,jquery-ui-core,jquery-ui-resizable,admin-comments,jquery-ui-sortable,postbox,dashboard,plugin-install,thickbox,media-upload&ver=678e1505aa95fa2e2bc5e32f8227d388

    I have tried loading this on 2 different servers with IIS6 and they both get exactly the same issue. Any help would be appreciated.

  40. 40 On August 20th, 2009, Bryan Migliorisi said:

    Great article. One thing that you are missing here is setting up pretty permalinks with WordPress and IIS6. Linux\Apache has mod_rewrite but IIS doesnt support this out of the box so I recently wrote a blog entry explaining how to do this here:


  41. 41 On August 20th, 2009, Ron Spitzer said:

    I finally found the problem with my site not working. Apparently the PHP.INI file that I have has an entry for magic_quotes_runtime = on. Changing this to off fixed everything.
    My blogs now work 100%

  42. 42 On August 21st, 2009, Installing Wordpress, PHP and MySQL on Windows 2003 with IIS | Matthew Hodgson said:

    […] some weeks tweaking various versions of PHP and MySQL I finally found a tutorial that worked over on the IIS Admin Blog. The tutorial leads you through both the installation of PHP 5 and MySQL […]

  43. 43 On October 3rd, 2009, James said:

    Thanks so much for this tut!

  44. 44 On October 13th, 2009, USAIDIT » How to Install/Serve WordPress on IIS 6 said:

    […] bloke did a good job detailing the required steps to complete this process – from installing mysql, […]

  45. 45 On November 1st, 2009, WordPress on 64bit IIS6 « Chris J Owen said:

    […] again, this is a fairly well documented process and shouldn’t cause you too many problems. The only other bump in the road I hit was that I […]

  46. 46 On November 2nd, 2009, Michael Randall said:

    I have PHP, MySQL and WordPress on my server. I go to install WordPress and receive the following error:

    PHP has encountered an Access Violation at 011F3744.

    I see multiple people having this issue, but no fixes? Has anyone seen this??

    PHP 5.2.11
    MySQL 5.0.87 Win 32
    WordPress 2.8.5
    Windows 2003 latest updates
    IIS 6.0

  47. 47 On November 4th, 2009, Lissandro said:

    I have an error that i really don´t understand… any google have references, only those one i put there, about the following error:

    “PHP has encountered an Access Violation at 03157BF0”

    The error appears when i navigating in the pages whose are not in the “smart” mode, like ?p=177 or ?p=112. Pages like http://www.myblog.com/category/article works very well, by the way they works only when god wants! kkkkkk

    I have
    PHP 5.2.11
    MySQL 5.0.87 Win 32
    WordPress 2.8.5
    Windows 2003 latest updates
    IIS 6.0
    just like Michael Randall wrote…

    any help would be glad!
    I´m trying to make an intranet service in my company… any ideas, problems or solutions would be really enjoyfull

  48. 48 On November 17th, 2009, Ajay said:

    Wonderfull example.
    But how to configure the mail server for wordpress

  49. 49 On January 10th, 2010, Gary said:

    Great help, thanks for taking the time to put this up.

  50. 50 On January 26th, 2010, Sean said:

    Thanks so much!

  51. 51 On February 12th, 2010, David said:

    For people receiving the error “PHP has encountered an Access Violation” try copying libmysql.dll from c:\php to c:\windows\system32

    This solved the issue for me.

  52. 52 On March 6th, 2010, Chris Davis said:

    Absolutely fantastic. I’m a longtime ASP.NET/MS SQL developer and had never touched PHP or MySQL or WordPress. You made installation fast and trouble-free.

  53. 53 On May 22nd, 2010, Configuring Wordpress on IIS6 « Wayne Palmer is Creating Software said:

    […] How to install WordPress on IIS6 […]

  54. 54 On August 3rd, 2010, dsv210 said:

    Hi there
    we’ve installed wordpress within our website on windows 2003 server running IIS we’re using isapi 2.11 to re-write our site urls – but this doesn’t work with permalinks and the canonical plug-in also doesn’t work for the same reason – is there any way around this?
    so far we’ve been offered the following solutions but neither is very palatable.
    either upgrading the server to windows 7 – but we have about 70 websites that would need to be moved – or upgrading to isapi 3 (around 25 of our sites use isapi 2.11 and this would mean re-writing all the rules for all the sites which would be a huge task and we’d have to use a test server)
    on the other hand the blog is a lot of work and we don’t want to spend the next year writing for the blog to discover it has then to be abandoned for not being seo friendly
    look forward to your suggestions on this

  55. 55 On September 10th, 2010, PHP on IIS? « Rickardblog said:

    […] to me figured I’d give it a try, but of course it needs to run in PHP, then I found this (http://www.iisadmin.co.uk/?p=6) To save the click, it’s a blog post about installing and configuring WordPress on a Windows […]

  56. 56 On September 10th, 2010, Chris Rickard said:

    Very informative and very useful, many thanks for this!

  57. 57 On September 21st, 2010, James said:

    Hi. Thanks for this, your article is the only one that I’ve found to work, although I had to use an older version of PHP to get the basic wordpress install working. I can get to the wp-admin folder/dashboard but I’m unable to get the actual site to load up. It seems to serve the .php page but the page is blank. I’ve searched all over the place but have had no luck. It’s a clean install of WordPress 3.01 running on IIS6.0 server. I have extended logging hourly within IIS, but the logs don’t really tell me much.

    Any ideas or help on this would be much appreciated, thanks.


  58. 58 On September 21st, 2010, James said:

    Hi, I have managed to get the basic front end to display by moving the wordpress installation from d:\inetpetpub\wwwroot to c:\inetpub\wwwroot.

    However none of the links or other pages work at present, a 404 is returned. I did use the Velvet Blues Update plugin to change the url’s from http://www.domainname.com to http://localhost (as the domain isn’t yet pointing to it), so it may be something to do with that.

    Thanks, James.

  59. 59 On October 27th, 2010, Stephen said:

    I have mysql (5.1) installed and have found your instructions very helpful. However, I receive the following error when attempting the ‘grant select’ statement. I can’t see what I am doing wrong…

    mysql> create user ‘wordpress’@’localhost’ identified by ‘wordpress’;
    Query OK, 0 rows affected (0.17 sec)

    mysql> grant select , insert, update , delete , create , drop , alter on ‘wordpr
    ess’ . * to ‘wordpress’@’localhost’;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near ”word
    press’ . * to ‘wordpress’@’localhost” at line 1

  60. 60 On October 27th, 2010, Stephen said:

    I tried

    GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON `wordpress` . * TO ‘wordpress’@’localhost’;

    but this produces the following output…

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near ‘* ‘wo
    rdpress’ TO ‘wordpress’@’localhost” at line 1

  61. 61 On October 27th, 2010, Stephen said:


    remove the quotes around the database name…

    mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON wordpress . * TO ‘wordpress’@’localhost’;
    Query OK, 0 rows affected (0.02 sec)

  62. 62 On December 19th, 2010, Anjum Bhat said:

    Very informative.I still have some errors “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”

  63. 63 On January 28th, 2011, FJ said:

    I am running IIS6 on Windows Server 2003 and SQL Server 2005. I have PHP 5.2.6 running with the SQLSRV 1.0 driver for PHP. My SQLServer database is on another machine than my web site. I continue to get the error message of “Error establishing a database connection”. The database is running, and the password is correct. I have successfully connected to the database using ODBC connections.

    What else do I need to check/do?

  64. 64 On March 16th, 2011, Sacy said:

    I have done everything and now WordPress in up and running on IIS , even I have enabled XML-RPC in WordPress admin panel but it is not working showing response that , I need to enable XML-RPC on Server.
    Is there any setting on IIS to enable XML-RPC or anyting else needs to do for using XML-RPC in WordPress ?

  65. 65 On April 16th, 2011, Roch said:

    What I am looking to do is similar. I am looking to have a static page as well as the blog appear on the main page of my wordpress site. Right now going to the settings section will only allow me to do one or the other. any feedback would be appreciated.

  66. 66 On November 26th, 2011, mukesh said:

    No need to install any ISAPI filter to remove the index.php from WordPress permalinks.No need of .htaccess file..Use these simple steps to WordPress Permalinks in IIS 6.0 using Custom 404 Redirect for Windows Shared hosting/manas hosting or any windows shared hosting.


  67. 67 On April 18th, 2012, Jason said:

    Maybe you could give some advice on how to setup pretty permalinks on IIS6, Microsoft 2003 server? All i could do was setting index.php at the beginning of the every post URL. Now it goes like this: “mydomain.com/index.php/mypost/” This won’t do for SEO. Any thoughts on that one?

Leave a Reply

You must be logged in to post a comment.

  • Calendar

  • May 2018
    M T W T F S S
    « Sep