• Hello, having some issues that I cannot figure out.

    I am trying to get my live site into WAMP:
    (not sure how important this is, but its a MU site)

    So far, I have:

    Backed up entire site and database, then unzipped it in the C:\wamp\www folder under the file name “spanish”

    Created a database in phpmyadmin, called “spanish” then loaded the original database.sql file.

    After that I went to wp_options and manually changed all the URL’s to https://localhost/spanish/

    I went to the wp-config and changed everything to:

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘spanish’);

    /** MySQL database username */
    define(‘DB_USER’, ‘root’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ”);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

    &

    define(‘WP_DEBUG’, false);

    define(‘MULTISITE’, true);
    define(‘SUBDOMAIN_INSTALL’, false);
    define(‘DOMAIN_CURRENT_SITE’, ‘localhost’);
    define(‘PATH_CURRENT_SITE’, ‘/spanish/’);
    define(‘SITE_ID_CURRENT_SITE’, 1);
    define(‘BLOG_ID_CURRENT_SITE’, 1);

    and the .htaccess file has been tried with the original as well as the following generic:

    # BULLETPROOF DEFAULT .HTACCESS

    # WARNING!!! THE default.htaccess FILE DOES NOT PROTECT YOUR WEBSITE AGAINST HACKERS
    # This is a standard generic htaccess file that does NOT provide any website security
    # The DEFAULT .HTACCESS file should be used for testing and troubleshooting purposes only

    # BEGIN BPS WordPress
    # CUSTOM CODE WP REWRITE LOOP START
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ – [L]
    RewriteCond %{HTTP_HOST} ^www\.localhost\$ [NC]
    RewriteRule ^(.*)$ https://localhost/$1 [R=301,L]

    RewriteCond %{REQUEST_URI} !(/$|\.)
    RewriteRule (.*) %{REQUEST_URI}/ [R=301,L]

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^ – [L]
    RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
    RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
    RewriteRule . index.php [L]
    # WP REWRITE LOOP END
    # END BPS WordPress

    Obviously I am missing something… Can someone please help me sort this out?

    Thank you!
    Dave

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi migpro, how do you do?

    It seems that you are using root as your mysql username. Although it seems you are on a localhost- You probably already know that it isn’t advisable to be using the above credentials.

    That said, you may have edited the privileges for your user root. You can check it out via phpmyadmin > Users Tab.

    Please let us know how it goes. Thank you!

    Thread Starter MIGPRO

    (@migpro)

    All that info gets changed to connect with the live database before I put it back on the server. I didn’t change any privileges… Right now, for some reason I cannot get the site to come up on the WAMP. I have other sites that come up fine so its not an issue with WAMP or privileges… Can you or someone else help?

    May I know if there are any error showing up at least? Can you try regenerating the .htacess file by modifying your permalink and saving it please. That is via your wordpress dashboard.

    Please let us know how it goes. Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error Establishing Database Connection’ is closed to new replies.