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
sudoSetup sudo access to mysql userSubmitted by sandip on Sun, 01/30/2011 - 02:13Here 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 »
|
User loginRecent blog posts
Who's onlineThere are currently 0 users and 6 guests online.
|