"Andrea Beyreuther" <[EMAIL PROTECTED]> wrote: > I have the following problem: > > I can't connect to the mysql server. I always get error messages (access denied). > > I installed it on Windows XP Professional. > > The mysql server is running as service. A web server is running as service too (IIS > V5.1). > > The my.ini (e:\windows\my.ini) contains: > [mysqld] > basedir=n:/mysql/ > datadir=n:/mysql_data/ > [WinMySQLAdmin] > Server=N:/mysql/bin/mysqld-nt.exe > > > N:\>n:\mysql\bin\mysql mysql > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > I always get the error above. > > By testing the server I get following errors: > N:\mysql\bin>mysqlshow -u root mysql > mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
Seems your user root has a password. Use -p option to specify a password. > N:\mysql\bin>mysqladmin version status proc > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' You doesn't have entry in the table user for anonymous user. > N:\mysql\bin>mysql test > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
