hi , see -skip-grant-tables in dev.mysql.com/doc Mathias
Selon Seena Blace <[EMAIL PROTECTED]>: > 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
