0

I'm trying to update the password for the user account in a MySql database managed through PHPMyAdmin. I'm logged in as root and I'm changing the password through User accounts/change password. Here's the SQL query:

ALTER USER [user name]@'%' IDENTIFIED WITH mysql_native_password BY '*'

However, the query is failing with this error message:

#1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

I'm pretty confused about how the vendor supplied root account doesn't have this level of access. I didn't set up the database originally so I don't know if the creator screwed things up when they did, but I'm really hoping that I can find a way to fix this without scrapping and rebuilding the database. Does anyone know how to resolve this?

Improve this question
1
  • It seems that your user does not have sufficient privileges. Run SELECT CURRENT_USER() then for that user run SHOW GRANTS for youruser@yourhost; and post the output Commented yesterday
Related questions
622
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
551
MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)
422
brew install mysql on macOS
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.