how to emulate "su mysql" in ubuntu?

[Tom H]

On Wed, Jul 28, 2010 at 12:03 PM, Patrick Doyle <wpdster at gmail.com> wrote:
> On Wed, Jul 28, 2010 at 12:00 PM, Robert P. J. Day
> <rpjday at crashcourse.ca> wrote:
>> On Wed, 28 Jul 2010, Patrick Doyle wrote:
>>
>>> I see that sudo takes a -u argument, perhaps
>>>
>>> $ sudo -u mysql /bin/sh
>>>
>>> might do the trick.
>>
>>  yes, that appears to work, but i could *swear* that was also one of
>> the first things i tried.  i must have tested every subtle variation
>> of that except for that.  argh.  thanks.
>>
> And, of course, Marius Gedminas gave the more elegant solution of:
>
> $ sudo -u mysql -s

sudo -s == su
sudo -i == su -