Installing WordPress on Windows 10 with manual MySQL install

  • Ok. I have Windows 10 Pro with IIS and PHP (latest versions) installed. I have the latest MySQL and MySQLWorkbench. When I start the WordPress 5.1.1 install it displays this long error:

    WordPress database error Table ‘wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘nonce_key’, blah blah blah – it goes on forever)

    So I have verified my PHP is correct because I can create a table in the WordPress database by running this in a test.php file:

    $sql = “CREATE TABLE MyGuests (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP
    )”;

    I installed MariaDB just to rule out this new MySQL and I GET the EXACT same error. Any ideas?

Viewing 3 replies - 1 through 3 (of 3 total)

  • Check IIS and MySql logs.

    Thread Starter furythreetwo

    (@furythreetwo)

    I turned on logging in PHP and it was able to complete the install – it bypassed the error and continued while logging this error:

    WordPress database error Table ‘wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘nonce_key’, ‘(=o)Z-t!nu%H(=o)Z-t!nu%H}}ryOFR/u5Y_wItq(a%;XM8/fN&o<‘, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by wp_can_install_language_pack, WP_Upgrader->fs_connect, Automatic_Upgrader_Skin->request_filesystem_credentials, WP_Upgrader_Skin->request_filesystem_credentials, request_filesystem_credentials, wp_nonce_field, wp_create_nonce, wp_hash, wp_salt, update_site_option, update_network_option, add_network_option, add_option

    It is far easier to get a computer and install Ubuntu 18.04 on it for WordPress. I dropped Apache2, Mariadb, PHP 7.3 on it in a few hours. Less resources and easy to point DNS to it and do port forwarding on your router to it.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Installing WordPress on Windows 10 with manual MySQL install’ is closed to new replies.