Install fails at Step 2 with [Table ‘wpress.wp_options’ doesn’t exist]

Despite following what appear to be following good instructions, I can’t get past the “Second Step� page, it reads:

————————–

Second Step

Now we’re going to create the database tables and fill them with some default data.

WordPress database error: [Table ‘wpress.wp_options’ doesn’t exist]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘siteurl’, ‘http://mydomain.com/wordpress’, ‘WordPress web address’, ‘yes’)

WordPress database error: [Table ‘wpress.wp_options’ doesn’t exist]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘blogname’, ‘My Weblog’, ‘Blog title’, ‘yes’)

…

————————–
Followed by another hundred of these errors. I would really appreciate some help.

I’m running on a dedicated Fedora Linux box with:

$ mysql -V
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

$ php -v
PHP 4.3.10 (cgi) (built: Dec 21 2004 10:27:48)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with the ionCube PHP Loader v2.4, Copyright (c) 2002-2003, by ionCube Ltd.

Here’s what I did:

$ cd ~/httpdocs

$ lynx -source http://wordpress.org/latest.tar.gz > latest.tar.gz

$ tar -xvzf latest.tar.gz
wordpress/
wordpress/wp-blog-header.php
wordpress/wp-login.php
… <snip> …
wordpress/wp-commentsrss2.php
wordpress/wp-atom.php
wordpress/wp-settings.php

$ cd wordpress/

$ mysql -u admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 665855 to server version: 3.23.58

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

mysql> CREATE DATABASE wpress;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON wpress.* TO wpress@localhost IDENTIFIED BY “somepassword”;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> EXIT
Bye

$ cp wp-config-sample.php wp-config.php

$ vi wp-config.php
[I edit the file]

$ cat wp-config.php
<?php
// ** MySQL settings ** //
define(‘DB_NAME’, ‘wpress’); // The name of the database
define(‘DB_USER’, ‘wpress’); // Your MySQL username
define(‘DB_PASSWORD’, ‘somepassword’); // …and password
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

// Change this to localize WordPress. A corresponding MO file for the
// chosen language must be installed to wp-includes/languages.
// For example, install de.mo to wp-includes/languages and set WPLANG to ‘de’
// to enable German language support.
define (‘WPLANG’, ”);

/* That’s all, stop editing! Happy blogging. */

define(‘ABSPATH’, dirname(__FILE__).’/’);
require_once(ABSPATH.’wp-settings.php’);
?>

From here I go to http://mydomain.com/wordpress/wp-admin/install.php and get:

Welcome to WordPress installation. We’re now going to go through a few steps to get you up and running with the latest in personal publishing platforms. You may want to peruse the ReadMe documentation at your leisure.
First Step »

Clicking First Step, I get:

First Step

Before we begin we need a little bit of information. Don’t worry, you can always change these later.
Weblog title:
Your e-mail:

, and I fill these out, and hit “Continue to Second Step”, and this is where the mess starts. I get:

Second Step

Now we’re going to create the database tables and fill them with some default data.

WordPress database error: [Table ‘wpress.wp_options’ doesn’t exist]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘siteurl’, ‘http://mydomain.com/wordpress&#8217;, ‘WordPress web address’, ‘yes’)

WordPress database error: [Table ‘wpress.wp_options’ doesn’t exist]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘blogname’, ‘My Weblog’, ‘Blog title’, ‘yes’)

WordPress database error: [Table ‘wpress.wp_options’ doesn’t exist]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘blogdescription’, ‘Just another WordPress weblog’, ‘Short tagline’, ‘yes’)

<… snip a hundred errors like this … >

WordPress database error: [Table ‘wpress.wp_users’ doesn’t exist]
INSERT INTO wp_users (ID, user_login, user_pass, user_email, user_registered, display_name, user_nicename) VALUES ( ‘1’, ‘admin’, MD5(’97d6ff’), ’email@mydomain.com’, NOW(), ’email’, ‘admin’)

WordPress database error: [You have an error in your SQL syntax near ‘ ‘wp_user_level’, ’10’)’ at line 1]
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (, ‘wp_user_level’, ’10’);

WordPress database error: [You have an error in your SQL syntax near ‘ ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’)’ at line 1]
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’);

Finished!

Now you can log in with the username “admin” and password “97d6ff”.

Note that password carefully! It is a random password that was generated just for you. If you lose it, you will have to delete the tables from the database yourself, and re-install WordPress. So to review:

Username
admin
Password
97d6ff
Login address
wp-login.php

Were you expecting more steps? Sorry to disappoint. All done! 🙂

of course, loading wp-login.php results in:


It doesn't look like you've installed WP yet. Try running install.php.

Wonderful! Ok WP wizards – what am I doing wrong!?

Thanks,

bitflow