does not save Manage User Privileges
I try to save the changes I make in the "Manage User Privileges" option, select all the checkboxes, and save.
But when I access the option again, the changes aren't saved.
View image error here: https://i.imgur.com/UVGmQUy.jpeg
What could be the problem with cPanel? Why isn't it saving checkbox changes? How can I fix it?
-
Hey there! That page isn't designed to save the clicks from the previous time you accessed the page, so what you're seeing is normal. It is only designed to let you change the settings for that user.
Do you think it would be a better experience if it showed the existing settings for that user so you could see what they are?
0 -
Exactly what you're describing is happening: the hosting user tries to save the privileges (by checking the boxes), and cPanel doesn't save the changes.
When they return to view the selected checkboxes, they remain blank. That is, it doesn't save the changes made.What could be the problem with cPanel? Why isn't it saving checkbox changes? How can I fix it?
0 -
No, I'm saying that is exactly the expected behavior - the changes ARE saved to the database user, but they just aren't retained in the interface. If you check the user's privileges manually on the database you'll see they update.
0 -
They are not recorded in either the interface or the database.
How do I view or modify privileges manually?
0 -
You'll want to use the show grants command to see this:
mysql -e "show grants for 'vanessa8_wrdp@localhost';"
and that will show you everything applied to that database user.
0 -
mysql -e "show grants for 'vanessa8_wrdp@localhost';"
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 1141 (42000) at line 1: There is no such grant defined for user 'vanessa8_wrdp@localhost' on host '%'0 -
Interesting - do you see anything in the main cPanel error log (/usr/local/cpanel/logs/error_log) when you submit that form to change the permissions? I'm wondering if something just isn't connecting properly.
0 -
Warning (“MysqlBase::_do_cpanel_mysql_with_newuser_privs”, line 598): The syste m failed to grant privileges on the database “vanessa8_wrdp1” to the user “vanessa8_wrdp1” because of an error: (XID ek5j bc) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
0 -
So there we go - the system isn't able to access that user through cPanel at all. Does this command show any results?
mysql -e "select * from mysql.user;" | grep vanessa8_wrdp1
0
Please sign in to leave a comment.
Comments
9 comments