Is there any way I can change passwd of database without knowing the administrator . I'm unable to get into the mysql prompt due to access denied message.I want to change passwd.How to do this? After change passwd do you think we need to grant some priviledges? thanks
Anoop kumar V <[EMAIL PROTECTED]> wrote: The reason i sthat you have not provided authorisation privileges to the database or to the tables within the database for that user... Very often we think granting all to the database is enough to make our app work with a particular user - this may be true for some databases - but in mysql you must do a grant all on your_database.* for that user - you must explicitly authorise the user for each table (using * or each table name) within the database. Hope that helps, Anoop On 6/4/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:Hello. See: http://dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Seena Blace <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 17 lines --] > > Hi, > > I have been noticing following error when trying to connect mysql. > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > or > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > What could be reason? > > Is there any way I can connect to database without changing passwd? > thanks > > > --------------------------------- > Discover Yahoo! > Get on-the-go sports scores, stock quotes, news & more. Check it out! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Thanks and best regards, Anoop --------------------------------- Discover Yahoo! Get on-the-go sports scores, stock quotes, news & more. Check it out!