Error 1045 when using MySQL or SQLyog

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.
iangilsenanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UmeshSenior Principal Technical Support EngineerCommented:
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!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
UmeshSenior Principal Technical Support EngineerCommented:
Any updates?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.