ERROR 1045 (28000) Access denied for non root user!
Install mysql :
$sudo apt-get install mysql-server
$sudo apt-get install mysql-client
that means there is no test users and no users with none passpord;
Step 2: install phpmyadmin
the script create the database and user for PMA, It run smoothly!
I create a wordpress user by doing :
mysql> CREATE USER wordpressuser@localhost IDENTIFIED BY '****';
mysql> GRANT ALL PRIVILEGES ON wordpress. TO wpdbuser@localhost;
mysql> FLUSH PRIVILEGES;
mysql -uwordpressuser -p
after entering the correct password ,I got this ERROR 1045.
I should tell you guys that:
I can access root by using: mysql -uroot -p;
I can access root by using phpmyadmin web client;
It all work perfectly except the new wordpress user, any one has this problem before?