Big picture: trying to update a 5 year old WordPress site without losing all the calendar plug-in posts.
Macro: downloaded MAMP to setup a local test site. Cannot get past index page to connect to database.
What works:
- Index page shows my test sites (I have three versions of wordpress
Installed (3.0.5 / 3.9.1.1 / 4.4.2), so I can incrementally test and
upgrade) - I can login to phpMyAdmin no problem
- I exported the old database to a .sql file, then imported it up to the new Local database, it showed up fine, but tells me “Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.5.48”
- The wp-config.php usernames and passwords all match to the database
After many searches and most of the day trying different things, I am stumped. Obviously, I am a complete noob to MySQL and PHP.
What I have tried:
- Changing port to 90 instead of 80
- Changing the user to ‘root’ and ‘admin’
- Changing from define(‘DB_HOST’, ‘localhostâ); to define(‘DB_HOST’, ‘86.42.246.7:80â); and define(‘DB_HOST’, ‘86.42.246.7:90â);
Notes:
- I initially edited the files with textedit, but noticed it was changing single quotes to leave syntax errors – now I’m using Dreamweaver.
- Is it possible I could just import each table one at a time into a newly created database?
Please help me out!
EDIT
I changed the database password, but I got this error message
“phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.”
