Here is how to give dba user sudo access as mysql user.
visudo and add:
dbauser ALL=(mysql) ALL
Basically, it defines that user "dbauser" can run all commands as "mysql" user.
For the dbauser to get mysql shell, run:
$ sudo -u mysql -i
Setup sudo access to mysql user
Submitted by sandip on Sun, 01/30/2011 - 02:13
Here is how to give dba user sudo access as mysql user. visudo and add: dbauser ALL=(mysql) ALL Basically, it defines that user "dbauser" can run all commands as "mysql" user. For the dbauser to get mysql shell, run: $ sudo -u mysql -i »
|
See AlsoUser loginRecent blog posts
Who's onlineThere are currently 0 users and 5 guests online.
|