Unable To Create WordPress Tables For foo.com with no default MySQL Host

v3
#1

It appears to me that the following lines are not compatible with the mysqlhost= param in ee.conf.

Because @$MYSQLHOST is used the web server / database server must be the same or the created user can’t login from the web server.

Please confirm I’m not missing something.

James

Starting @ Line 726

Create Separate User & Grant Permission

echo -e “WPDBNAME = $WPDBNAME \nWPDBUSER = $WPDBUSER \nWPDBPASS = $WPDBPASS” &>> $INSTALLLOG
mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS -e “create user ‘$WPDBUSER’@’$MYSQLHOST’ identified by ‘$WPDBPASS’”
mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS -e “grant all privileges on <code>$WPDBNAME</code>.* to ‘$WPDBUSER’@’$MYSQLHOST’”
mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS -e “flush privileges”

#2

Hello Jttacj1

First if you don't provide the mysql host then easyengine set MYSQLHOST=localhost Ref:https://github.com/rtCamp/easyengine/blob/master/usr/local/sbin/easyengine#L601

The issue (Unable To Create WordPress Tables) is seems like wp-cli is not properly installed, Please give me the output of following commands

ee version wp --info or wp --allow-root --info

In case wp-cli is not installed properly, you can install it by using following commands,

rm -rf /usr/share/easyengine/wp-cli /usr/bin/wp /etc/bash_completion.d/wp-completion.bash  

curl -s http://wp-cli.org/installer.sh | INSTALL_DIR='/usr/share/easyengine/wp-cli' bash  

ln -s /usr/share/easyengine/wp-cli/bin/wp /usr/bin/wp  

cp -i /usr/share/easyengine/wp-cli/vendor/wp-cli/wp-cli/utils/wp-completion.bash /etc/bash_completion.d/  

source /etc/bash_completion.d/wp-completion.bash
#3

I am having the same issue – Unable To Create WordPress Tables.

ee version: easyengine version: 1.3.7
wp --info: wp: command not found
wp --allow-root --info: wp: command not found

I have tried running the commands you mentioned above to reinstall wp-cli, but the last command is giving me an error:

bash: /etc/bash_completion.d/wp-completion.bash: No such file or directory

Ubuntu 14.04 x64 on DigitalOcean.

Your help would be greatly appreciated.

#4

Its seems like wp-cli is not installed properly

Please run the following commands

rm -rf /usr/share/easyengine/wp-cli  /usr/bin/wp /etc/bash_completion.d/wp-completion.bash  
curl -sL https://raw.github.com/wp-cli/wp-cli.github.com/master/installer.sh | INSTALL_DIR='/usr/share/easyengine/wp-cli' VERSION='0.14.1' bash   
ln -s /usr/share/easyengine/wp-cli/bin/wp /usr/bin/wp   
cp -i /usr/share/easyengine/wp-cli/vendor/wp-cli/wp-cli/utils/wp-completion.bash /etc/bash_completion.d/  
source /etc/bash_completion.d/wp-completion.bash
#5