Bug: Sqlyog Doesn't Recognize Database Names Escaped With A Backsl

[larsen]

I think this is a problem of SQLyog:

Plesk (12.5.30, a server administration tool) creates entries in “mysql.db” like “t3_example_com” when the database name contains underscores.

 

When SQLyog (12.2.2, 64-bit, Win7) shows the privileges of a user that is allowed access to that database, none is checked.

 

[Sibin A S]

Hello Larsen,

 

Can you please clarify a bit more by elaborating on,

 

• Whether the database was created using SQLyog?
• Do you find the database listed under the specific user it was created ?

 

To view objects on which the user has privileges, check “Show only privileged objects” at the bottom left corner of the ‘User Manager’ dialog. 

 

After checking the checkbox, do you find the object to which the user has privileges in the list?

 

Regards,

Sibin

[larsen]

> Whether the database was created using SQLyog?

No, it was created by Plesk.

 

> Do you find the database listed under the specific user it was created ?

SQLyog shows the database name without backslashes. It doesn’t show privileges for the user for that database.

 

> To view objects on which the user has privileges, check “Show only privileged objects” at the bottom left corner of the ‘User Manager’ dialog. 

Oh, I have overlooked that feature completely before. Very useful!

 

> After checking the checkbox, do you find the object to which the user has privileges in the list?

Yes, SQLyog then shows the database name with backslashes.

 

[Sibin A S]

Hello Larsen,

 

Can you please attach the screenshots of the same.

[larsen]

[attachment=2070:1.png] [attachment=2071:2.png]

[Author]

Posts