Skip to main content
Database Administrators

Return to Question

added 3 characters in body
Source Link
Julien Vavasseur
Julien Vavasseur
  • 10.2k
  • 2
  • 28
  • 46

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

 SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');

I am getting an "access denied" error:

Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

 SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');

Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password:

 SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');

I am getting an "access denied" error:

Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

Improved formatting
Source Link
Shanky
Shanky
  • 19.1k
  • 4
  • 36
  • 58

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

 SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');
Access denied for user 'bmcrae'@'%' to database 'mysql'

Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');
Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

 SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');

Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

Improved formatting
Source Link
edit approved May 25, 2016 at 14:15
Rathish Kumar B
edit approved May 25, 2016 at 14:15
Rathish Kumar B
  • 2.3k
  • 5
  • 24
  • 36

In MySQL 5.6.27 User 'bmcrae', user 'bmcrae' has create_user_privcreate user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied""access denied" error: SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************'); Access denied for user 'bmcrae'@'%' to database 'mysql'

SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');
Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

MySQL 5.6.27 User 'bmcrae' has create_user_priv and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error: SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************'); Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

In MySQL 5.6.27, user 'bmcrae' has create user privileges and is able to create a new user. However, when trying to change another user's password, I am getting an "access denied" error:

SQL: SET PASSWORD FOR 'newuser' = PASSWORD('***************');
Access denied for user 'bmcrae'@'%' to database 'mysql'

I have re-read the relevant MySQL documentation and not found anyone else having such issues. Any advice?

Source Link
user2795934
user2795934
  • 13
  • 2