Why grant all privileges doesn't work in Phpmyadmin?
Solution 1:
all
does not include the grant
privilege.
Quote from the documentation:
The optional WITH clause is used to enable a user to grant privileges to other users. The WITH GRANT OPTION clause gives the user the ability to give to other users any privileges the user has at the specified privilege level.
To grant the GRANT OPTION privilege to an account without otherwise changing its privileges, do this:
GRANT USAGE ON *.* TO 'someuser'@'somehost' WITH GRANT OPTION;
So, in your case:
GRANT ALL PRIVILEGES ON `dbname`.* TO 'userA'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;