Hello Shravan,
Thursday, September 19, 2002, 5:45:59 PM, you wrote:
SD> I am able to stop the server when i specify the
SD> password for the user root.
SD> But if the user "shravan" (who does not have a
SD> password) who tries to stop the server started by
SD> himself, then it fails.
User "shravan" must have Shutdown_priv:
http://www.mysql.com/doc/en/Privileges_provided.html
SD> Thanks,
SD> SKD
SD> --- Victoria Reznichenko
SD> <[EMAIL PROTECTED]> wrote:
>> Shravan,
>> Wednesday, September 18, 2002, 10:17:29 PM, you
>> wrote:
>>
>> SD> I am completely new to MySQL. I installed the
>> source
>> SD> version of MySQL on Solaris 2.8. I did
>> SD> "mysql_install_db".
>>
>> SD> I started the server by saying
>> SD> "bin/safe_mysqld --user=mysql &". The server
>> started
>> SD> my creating "mysql.sock" file in the /tmp
>> directory.
>> SD> Now i
>> SD> want to stop the server. How should i do it?
>>
>> SD> I did "bin/mysqladmin -u mysql shutdown"
>> SD> The error message that came up was:
>> SD>
>> **************************************************
>> SD> /home/shravan/extra/mysql/bin/mysqladmin:
>> shutdown
>> SD> failed; error: 'Access denied for user:
>> '@localhost'
>> SD> (Using password: NO)'
>> SD>
>> **************************************************
>>
>> SD> I also tried "bin/mysqladmin -u root shutdown"
>> and
>> SD> also
>> SD> "bin/mysqladmin -u shravan shutdown". But i
>> could not
>> SD> get the server down.
>>
>> Do users 'root' and 'shravan' have passwords? if so,
>> you should use
>> mysqladmin -u root -p shutdown
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
