#9221: Alter User (Change Password) can not be done by visual editor in MySQL 5.6

anilkalshetti reported 2013-06-03T06:40:43Z · last modified 2013-06-07T06:30:12Z

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	App - Visual Editing
Version	12.0

ADS Version: 14.0.0-alpha-27

Database: MySQL 5.6

1.Connect to MySQL 5.6 database.

2.Go to Security->Users->Right click,Alter User.

3.Now under General tab for Login Information, change Password

4.Click on Alter button.

Alert message displayed "Can't find any matching row in the user table"

5.Please take a look at script generated in screenshot

a)It generates script as:

SET PASSWORD FOR `anil2`=PASSWORD('admin@12')

PFA of screenshot for reference,

Image File name:

1. ADS14.0.0-alpha-27-MySQL 5.6-User_Alter_change_password-image1

2. ADS14.0.0-alpha-27-MySQL 5.6-User_Alter_change_password-image2

----------------------------------------------------------------------------------------------------------------------------

Database: MySQL 5.5

1. Same error occurs for MySQL 5.5.

PFA of screenshot for reference,

Image File name:

1. ADS14.0.0-alpha-27-MySQL 5.5-User_Alter_change_password-image1

2. ADS14.0.0-alpha-27-MySQL 5.5-User_Alter_change_password-image2

All Comments (2) Change History

ivangron 2013-06-03T21:00:53Z

alter user for mysql was not qualifying the user name with the host info. This is now fixed and back ported to versions 13 and 12.

anilkalshetti 2013-06-07T06:30:12Z

Verified in ADS 14.0.0-beta-14