This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

STM Issue: mysql> admin Access denied

When issueing the following:

mysql> GRANT ALL ON storage.* to 'dwhitson'@'IP Address' IDENTIFIED BY 'password';

ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'storage'

Anyone seen this or have any ideas what the issue might be please let me know; thanks.

  • Dave,

    Try doing the following before you run that query...

    1. log into the database as the admin user.

    2. use mysql database.

    3. execute the following: update user set Grant_priv='Y' where user='admin';

    4. execute the following: flush privileges;

    5. exit mysql.

    6. repeat steps 1 and 2 above.

    7. execute your query.

    These steps worked for me.

    -Shane

    http://www.loop1systems.com