?
Solved

Error 1045 when using MySQL or SQLyog

Posted on 2005-03-05
4
Medium Priority
?
3,096 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:iangilsenan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 1000 total points
ID: 13515819
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!
0
 
LVL 26

Expert Comment

by:Umesh
ID: 14111977
Any updates?
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question