Error 1045 when using MySQL or SQLyog

iangilsenan
iangilsenan used Ask the Experts™
on
Hi,

I wanted to start using PHP and MySQL on my system so I installed the most recent copies of PHP (4.3.10) and MySQL (Server 4.1).

I chose all the default config settings for MySQL and didnt set any passwords.

When I use a command prompt and enter mysql the following occurs:

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

I installed a program called SQLyog and it gives the same error when connecting using:
host address: localhost
username: root
port 3306

After looking at the many solutions available on the net I can still not solve the problem.

Here are some more details:

I'm running Windows XP Pro Service pack 2

Norton Internet Security 2005 (have tried turning this off)

I use Internet Information Services 4 successfully running ASP pages. I have tested PHP pages and they work fine too.

MySql is installed at C:\Program Files\MySQL\MySQL Server 4.1

the my.ini file says:

[client]

port=3306

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 4.1/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

I would appreciate any help you can give.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Principal Technical Support Engineer
Top Expert 2009
Commented:
Hi!

Take a look at here..

http://swforum.sun.com/jive/thread.jspa?threadID=51500

(For windows 2k/XP)
Also not that when you follow default installtion options it would install in C:/Program Files/MySQL/MySQL Server 4.1/...so on..
because of space between dir it causes problem while starting/stoping service..so better to install it in C:/MySQL


Hope This Helps!
UmeshSenior Principal Technical Support Engineer
Top Expert 2009

Commented:
Any updates?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial