Report this

What is the reason for this report?

Setting Up NGINX with Wordpress - MYSQL Setup

Posted on March 22, 2014

I’m wanting to migrate an existing Wordpress installation to my new droplet.

I created a droplet with the default LAMP stack. I thought I would try NGINX, so I removed Apche and installed Nginx, referring to

https://www.digitalocean.com/community/articles/how-to-configure-single-and-multiple-wordpress-site-settings-with-nginx

https://www.digitalocean.com/community/articles/how-to-migrate-wordpress-from-shared-hosting-to-a-cloud-server-with-zero-downtime

I’m not clear what needs to be done to setup Mysql. Do I need to follow step 2 as outlined here: https://www.digitalocean.com/community/articles/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu

If I try to run the install script, it appears the root password for mysqp has already been set, so I’m not sure if this step is needed or not

root@portlandhdgraphics:/usr# /usr/bin/mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we’ll need the current password for the root user. If you’ve just installed MySQL, and you haven’t set the root password yet, the password will be blank, so you should just press enter here.

Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user ‘root’@'local



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

If you do not remember your password that was set in the first installation process. You may need to reinstall mysql to get the password set again or you can try this http://www.howtoforge.com/reset-forgotten-mysql-root-password <br> <br>I do not know what linux distro you are running but that should cover pretty much all of them.

Take the easier route and use easyengine, it will take care of all that. <br> <br>https://github.com/rtCamp/easyengine

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.