Operation CREATE USER failed for 'domain_com'@'localhost' - ee doesn't check if it has req'd privileges?

Ubuntu 12.0.3 LTS and easyengine version: 1.1.3

I use CLI to login to mySQL and verify it has all privileges. Then I run the site create command:

Enter The MySQL Username [root]:
Enter The MySQL Password:
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'domain_com'@'localhost'
Setting Up WordPress, Please Wait...
[ Sat Feb 8 16:26:53 EST 2014 ] Unable To Create WordPress Tables For domain.com

When I try to delete the site with ee, the DB can't be dropped using "root".

ee site delete domain.com
WPDBNAME = domain.com
WPDBUSER = domain.com
MYSQLHOST = localhost
Are You Sure To Drop domain.com Database (y/n): y
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ Sat Feb 8 16:28:13 EST 2014 ] Unable To Drop domain.com Database

But when I use:
mysql -u root -p -h localhost
.. I can use the DB and drop the DB that was created by ee.
It seems there's s something wrong in the way ee handles WP DB. Maybe it should first try to verify if it has necessary rights on the DB and exit if it doesn't.

What would be a workaround? Use a non-root user and give that user all privileges on the DB before ee starts creating the site?

Reference: similar issue that was closed is here:
#95

[rahul286]

Looks like .my.cnf file is missing. Can u create it and try again. Ref - https://rtcamp.com/tutorials/mysql/mycnf-preference/

~/.my.cnf existed, but with some weird password.
I changed the password but overall no improvement happened. It still doesn't work, although maybe in a different way.
I looked at ee log:

1. The WP DB gets created.
   I looked at the log and tried to login to mySQL using WP credentials and DB password given, it worked
2. However "show databases;" doesn't show the domain.com DB (I'm logged in using that domain user's identity).
3. I log out and then come in as root to see this guy's grants:
   Grants for domain.com@localhost
   GRANT USAGE ON . TO 'domain.com'@'localhost' IDENTIFIED BY PASSWORD '6-SNIP-1'
   GRANT ALL PRIVILEGES ON domain.com. TO 'domain.com'@'localhost'

I can't tell from this whether this is OK or not. While the user can log in to mySQL, he can't SHOW the WP created for it.

One additional error is what I mentioned in the other issue - the way wp CLI is invoked by the installer. From log of the same attempt to install site which fails here's what I see in the log (below). Maybe running this step manually would help, but I don't know if there are other steps after that.

If you REALLY mean to run this as root, we won't stop you, but just bear in mind that any code on this site will then have full control of your server, making it quite DANGEROUS.
If you'd like to continue as root, please run this again, adding this flag: --allow-root
If you'd like to run it as the user that this site is under, you can run the following to become the respective user:
sudo -u USER -i -- wp ...

P.S. I retried the procedure 2 more time to make sure what happens. What happens is that now with ~/.my.cnf the DB gets created, but it has no tables.

[ Sat Feb 8 17:40:04 EST 2014 ] Unable To Create WordPress Tables For domain.com

[rahul286]

This breaking is related to recent wp-cli change – wp-cli/wp-cli#973

We will update easyengine asap.

Sorry for inconvenience.

[rahul286]

@Rippler if you have removed easyengine, just install it again.

If it's still in broken state, please run following commands for a local fix:

rm -rf /tmp/easyengine
git clone -b stable git://github.com/rtCamp/easyengine.git /tmp/easyengine
cp -a /tmp/easyengine/usr/local/sbin/easyengine /usr/local/sbin/

Feel free to let us know if you face any other issue.

[hadifarnoud]

I have same issue with latest easyengine and wp-cli

UPDATE: if I login with root, I see no error. it's my non-root usernames that doesn't work even with sudo.

[gau1991]

@hadifarnoud ,
EE relies on .my.cnf , for non root user you need to copy it from root home folder (/root) to not root user home folder.

sudo cp /root/.my.cnf /home/user

replace user with your username

Now you are able to use EE with sudo command