worcpublib

HandySolo,

This is very handy, wish I found it earlier. Had an error though and I think I know why. In the instructions for MySQL Client it says the following:

“$ mysql -u ”adminusername” -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> CREATE DATABASE ”databasename”;

So I typed in mysql> CREATE DATABASE ”wordpress”; and got an error…

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 ”’wor
dpress”’ at line 1

Now I notice the SQL version numbers are different(server version: 3.23.54 versus 5.0.18), so I assume this is the cuprit. Is there an updated version of this session?

Thank you for all the help, much appreciated.
Mike

OK, now I have php files loading correctly. After searching and searching I came accross a really good install article.

http://echerng.net/blog/archive/2005/11/23/181.aspx

So back to starting the install.php. I tried running it and it gives me an “Error establishing a database connection.”

I setup MySQL as instructed. Here is the beginning of my wp-config.php file.

<?php
// ** MySQL settings ** //
define(‘DB_NAME’, ‘wordpress’); // The name of the database
define(‘DB_USER’, ‘root’); // Your MySQL username
define(‘DB_PASSWORD’, ‘mypassword’); // …and password
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

WHee mypassword is a substitute. Did I miss something???

UPDATE!

I made sure IIS knows about PHP as it correctly points to the PHP.exe. To be quite frank, the manual install is not that helpful, I read the entire install.txt and it did not help that much. It gives notes about what you could do and what things do, but doesn’t tell you what needs to be done in an orderly fashion is you would. So where am I? Well I went back and tried the standard install again and I am at the same stage. I try to open the wp_install.php to load the tables and it doesn’t come up.

Any suggestions,

Thank you for any help, much appreciated!!!!

_mike

I realized the location soon after I wrote the post and threw it in the wwwroot folder (slight oversight), didn’t matter though. And yes I used the wimpy php standard install. Hey how else am I supposed to learn right? I did try the advanced install and there was no difference really. So when you say “manly-man-get-your-hands-dirty install” as to what are you referring too? Is it the advanced install?

Also I got the message about making sure the IUSR account has certain permissions, I thought IIS created this account by default? I will create it anyway.

“Did you configure IIS to actually know about and use PHP?” No, not sure how but I will have a “manly” look around,

Thank you for the help man,

Mike