Unable to create database user (ee Wordpress install)


#1

Hi, this worked fine on Digital Ocean but on Linode I get this error. “Unable to create database user” which leads to a partial installation without any wp-config.php It does install the database but without the user assigned to it.

This is the latest EasyEngine 2.2.2

here is the relevant log output after I tried this operation . . .

root@noize:~# cat /var/log/easyengine/*
EasyEngine (ee) 2.2.2 execution started [Mon Dec 22 18:45:41 EST 2014]
EasyEngine (ee) command: /usr/local/sbin/ee site create tylerlongo.com --wp
nginx-custom					install
php5-fpm					install
mysqld is alive
php5-fpm					install
postfix						install
PHP binary:	/usr/bin/php5
PHP version:	5.5.20-1+deb.sury.org~trusty+1
php.ini used:	/etc/php5/cli/php.ini
WP-CLI root dir:	phar://wp-cli.phar
WP-CLI global config:	
WP-CLI project config:	
WP-CLI version:	0.17.1
EE_DOMAIN_CHECK = tylerlongo.com 
EE_SITE_CREATE_OPTION = --wp 
EE_SITE_CACHE_OPTION = --basic 
EE_NETWORK_ACTIVATE =  
EE_WP_SUBDOMAIN =  
EE_NGINX_CONF = wp/basic.conf
Creating tylerlongo.com, please wait...
Creating symbolic link for tylerlongo.com
Creating htdocs & logs directory
Downloading WordPress, please wait...
Downloading WordPress 4.1 (en_US)...
Using cached file '/root/.wp-cli/cache/core/en_US-4.1.tar.gz'...
Success: WordPress downloaded.
EE_DB_NAME =example_com
EE_DB_USER = example_com 
EE_DB_PASS = xxxxxxxxxx
EE_MYSQL_HOST = localhost 
EE_MYSQL_GRANT_HOST = localhost
[ Mon Dec 22 18:45:43 EST 2014 ] Unable to create tylerlongo_com database user, exit status =  1

#2

@jimlongo

Would you please confirm, that the same database user already does not exist at your mysql server.

use this command mysql -e "SELECT User FROM mysql.user;"


#3

Thanks harshadyeola,

I did ensure that, still no luck.

However after looking at the latest logs further, I completed the ee.config file supplying a wordpress username, password, and email - after that the ee site create process worked as expected.

Thanks again, jim


#4

Hi @jimlongo

Glad to know that you resolved your issue.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


#5