I have a little problem testing a setup. I created two droplets on DigitalOcean, one for PHP,Nginx, utils, mysql client and more, and the other droplet specially for percona server. both droplets have private network ips. I setup percona server to run on the private network ip, i put the permissions for root, everything worked OK. I tried to connect manually with mysql -u root -p from the first server and it connected. I even modified ee.conf with the remote ip.
when i’m trying to create a website gives me this error: root@devly:/etc/easyengine# ee site create devly.co --wpfc Creating devly.co, please wait… Creating symbolic link for devly.co Creating htdocs & logs directory Downloading WordPress, please wait… Setting up WordPress, please wait… [ Wed Oct 15 05:19:49 EDT 2014 ] Unable to create WordPress tables for devly.co, exit status = 1 root@devly:/etc/easyengine#
in EE log I find:
Success: WordPress downloaded. EE_DB_NAME = devly_co EE_DB_USER = devly_co EE_DB_PASS = CE2oQT0OddBAGzt EE_MYSQL_HOST = 10.133.243.36 EE_MYSQL_GRANT_HOST = 10.133.243.36 EE_WP_PREFIX = wp_ EE_WP_USER = Alex EE_WP_PASS = ofP0zSckBLGPxFm EE_WP_EMAIL = email@example.com ^[[34mSetting up WordPress, please wait…^[(B^[[m Error:
Error establishing a database connection
This either means that the username and password information in your
wp-config.php file is incorrect $
- Are you sure you have the correct username and password?
- Are you sure that you have typed the correct hostname?
- Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host. If you still need help you can alway$
[ Wed Oct 15 05:19:49 EDT 2014 ] ^[[31mUnable to create WordPress tables for devly.co, exit status = 1^[(B^[[m
on the db server the permissions are: grant all privileges on . to ‘root’@‘nginx-server-ip’ IDENTIFIED BY ‘REMOTE_MySQL_PASSWORD’ with grant option; flush privileges;
What’s wrong in my setup?