Page 1 of 1
how to change role in mysql
Posted: Fri May 15, 2020 2:46 pm
by rjmon
How to change admin role to user in mysql?
Re: how to change role in mysql
Posted: Fri May 15, 2020 4:08 pm
by jbrunkow
Are you asking to downgrade privileges of an admin user in
Linux, or create a
MySQL account for your admin?
Most people would use
chown if they are changing Linux permissions, or something like the below command if they are doing it in
MySQL.
Code: Select all
mysql> GRANT ALL ON example_database.* TO 'example_user'@'%';
Re: how to change role in mysql
Posted: Fri May 15, 2020 4:49 pm
by jbrunkow
It would probably be something like the following.
LINK
Are you trying to change permissions in MySQL or Linux?
Re: how to change role in mysql
Posted: Fri May 15, 2020 5:00 pm
by rjmon
trying to change in mysql. We have about 50 + admins.. now i have to degrade them to user role.
Re: how to change role in mysql
Posted: Mon May 18, 2020 9:34 am
by jbrunkow
In that case,
dropping the role entirely may be quickest way to go about this.
Code: Select all
DROP ROLE 'app_read', 'app_write';
Please see the
documentation for more information about revoking roles in MySQL.
Normally, it's not necessary to change these settings when managing Nagios XI, I would recommend backing the server up before you make any changes.
Backing Up and Restoring Nagios XI