MySQL: Access Denied for Users to Database
I am trying to create a database on my remote sql server - clearDB - on Heroku. I linked to this:
mysql --host='<<cleardbhostname>>' --user='<<lsdj234>> --password
My username and password are derived from the result of running the heroku config. When I tried to run
CREATE DATABASE mydb;
I got it:
ERROR 1044 (42000): Access denied for user '<<lsdj234>>'@'%' to database 'mydb'
When I ran SHOW GRANTS for current_user I got:
GRANT USAGE ON *.* TO '<<lsdj234>>'@'%' IDENTIFIED BY PASSWORD '*asfe4545235' WITH MAX_QUERIES_PER_HOUR 3600 MAX_USER_CONNECTIONS 10 |
| GRANT ALL PRIVILEGES ON `heroku_ljl4455lkj`.* TO '<<lsdj234>>'@'%'
What's happening? How do I resolve this?
+3
source to share