Not able to see users in User Manager

[sanketjoshi4]

Hi,

I disabled the select permission for root and now, I am not able to see users and permissions to re enable the same. I deleted and replaced the entire directory, cleared browser cache, restarted my device, and still, in a new instance on the application, this change is persistent.

Is the user permission configuration stored somewhere in DB ?
Please suggest how to reset everything to default settings otherwise.

Thanks and regards,
Sanket Joshi

[Samnan]

User permissions are diretly fetched from mysql, nothing stored elsewhere.

You can run a mysql command line and then try fix like this

       mysql > GRANT ALL on *.* to 'root'@'localhost';
       mysql > flush privileges;

This might fix things up from you, just relogin to MyWebSQL after this.

[Elvin-zl]

the same problem , i viewed the soucecode , it seems like caused by the mysql version , if u use mysql5.7+ , there is no field in mysql.user table named "password", but the select user list method used the filed , i tried add this field in this table , the userlist can load , but add user can not work ,unfortunately , we should change the source code ... i dont know weather the author still focus this project , im writing java , dont want to fix it myself ...

[Elvin-zl]

@Samnan please help me , i want to use this project , cause its UI beautiful than phpadmin a lot !!

[Samnan]

@Elvin-zl i am currently busy in another project. Will do my best to update the code to work with new mysql versions.

PR's are always welcome from community!

[Elvin-zl]

thanks for reply , wait in hope ~

[Samnan]

@Elvin-zl this issue is fixed in latest github code, you may test it out.