473,856 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Getting Error Nr. 1045 during setup

I'm trying to install MySQL. During the security settings portion fo the
setup. I keep getting a Connection Error.
Error Nr. 1045
Access denied for user'root'@'loc alhost'(using password:YES)

........

I had Zonealarm running. Changed the trusted zone security setting to
low(disabled) then selected "retry" Failed again.

Rebooted, turned off Zonealarm, going through configuration wizard I changed
the root password to "YES" connection still failed...

I'm obviously not crossing a "T" somewhere. I'm a little lost.

Thanks in advance.

Greg Noss

Mar 24 '06 #1
3 22579
"Greg Noss" <ss*****@earthl ink.net> wrote in message
news:zv******** ********@newsre ad2.news.pas.ea rthlink.net...
I'm trying to install MySQL. During the security settings portion fo the
setup. I keep getting a Connection Error.
Error Nr. 1045
Access denied for user'root'@'loc alhost'(using password:YES)


Well, for what it's worth, in that error message, it does not mean that the
root password is literally "YES" -- it means that you did give a password.
In MySQL, it is possible to configure accounts that do not have a password.
It's even possible for the same account to have different privileges
depending on whether you supply a password or not. So in this error, the
fact that you were attempting to supply a password when it failed is
actually a relevant detail (though I have always thought that this error is
confusing for new users).

The first thing I'd check is if the MySQL service is running. You could get
this error in the client if there is no service for the client to talk to.
You can check the service by opening Control Panel -> Administrator Tools ->
Services.

Check the error log for clues. On my Windows machine, the error log is
location in C:\Program Files\MySQL\MyS QL 5.0 Server\data\<ho stname>.err
(where <hostname> is the name of my Windows machine).

Read the following page for many more tips on resolving "access denied"
errors:
http://dev.mysql.com/doc/refman/5.0/...ss-denied.html

Regards,
Bill K.
Mar 24 '06 #2
Thanks for your input, I had another app. that installed their version of
MySQL I wasn't using their functions I removed their version adn PRESTO
MySQL worked. Is it possible to run to different copies of MySQL on the
same machine?

Thanks,
Greg Noss

"Bill Karwin" <bi**@karwin.co m> wrote in message
news:e0******** *@enews2.newsgu y.com...
"Greg Noss" <ss*****@earthl ink.net> wrote in message
news:zv******** ********@newsre ad2.news.pas.ea rthlink.net...
I'm trying to install MySQL. During the security settings portion fo the
setup. I keep getting a Connection Error.
Error Nr. 1045
Access denied for user'root'@'loc alhost'(using password:YES)


Well, for what it's worth, in that error message, it does not mean that
the root password is literally "YES" -- it means that you did give a
password. In MySQL, it is possible to configure accounts that do not have
a password. It's even possible for the same account to have different
privileges depending on whether you supply a password or not. So in this
error, the fact that you were attempting to supply a password when it
failed is actually a relevant detail (though I have always thought that
this error is confusing for new users).

The first thing I'd check is if the MySQL service is running. You could
get this error in the client if there is no service for the client to talk
to. You can check the service by opening Control Panel -> Administrator
Tools -> Services.

Check the error log for clues. On my Windows machine, the error log is
location in C:\Program Files\MySQL\MyS QL 5.0 Server\data\<ho stname>.err
(where <hostname> is the name of my Windows machine).

Read the following page for many more tips on resolving "access denied"
errors:
http://dev.mysql.com/doc/refman/5.0/...ss-denied.html

Regards,
Bill K.

Mar 29 '06 #3
Greg Noss wrote:
Thanks for your input, I had another app. that installed their version of
MySQL I wasn't using their functions I removed their version adn PRESTO
MySQL worked.
I would guess that your copy of MySQL wasn't running at all; it was the
vendor's instance running on the same port. That would explain why your
password wasn't being recognized.
Is it possible to run to different copies of MySQL on the
same machine?


Yes, it should be possible to do so.

More recent versions of MySQL support the concept of running "instances"
of one installation.
http://dev.mysql.com/doc/refman/5.0/...e-manager.html

But if you want to run multiple instances of _different_ MySQL
installations (for example, if you want to keep several different
versions available for testing), it gets trickier.

They need to be installed in different directories, and they must not
touch each other's databases. They should listen on distinct ports. If
you run them as services on Windows, they need to use distinct service
names. On UNIX/Linux, they also need to have distinct locations for
their respective log files, init scripts, and socket files. Whew!

Regards,
Bill K.
Mar 30 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4596
by: Morten Gulbrandsen | last post by:
Hi programmers, Good morning ;-) I think something is wrong, Running windows I believe first I have to set some password, Which creates some user, Then I can grant the required privileges, for some databases. However granting privileges after setting password seems to reset some Other access,
0
1162
by: *** JB | last post by:
After an installation of Namo WebBoard messed up my MySQL installation - I have been unable to get it fully working again. My setup is as follows: Apache 1.3 / MySQL 4 / PHP 4 When I use phpmyadmin I get the following error: #1045 - Access denied for user: root@localhost' (Using password: YES) Any ideas what I am doing wrong? Thanks
4
15629
by: 21novembre | last post by:
Hi all, I got a quite strange problem when I tried to setup a database backup shell. I put it this way: "bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak" However, error 1045 came to me to say "Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect". None the less, I'm absolutely full of confidence on my correct username and password, simply because if I do it this way: "bin/mysqldump --opt...
3
4156
by: dstewart | last post by:
Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in rinetd, the error message is: ERROR 2013: Lost connection to MySQL server during query Using the exact same query from prompt on several clients (some are SuSE 9.1, some are older Redhat systems, but none are configured
3
33271
by: prasadbabu | last post by:
Hi Guys, I am new to this forum. So if i made any mistake please bare with me. Soon i ll follow all the guidelines as days pass through. I am getting following error when i try to login to mysql prompt. c:\mysql\bin>mysql -u root -p password:***** ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
0
1336
by: baghath | last post by:
I am using linux server in virtually(putty). that server have a mysql. I got the error (ERROR 1045) in when i type mysql time.i need ur help for how to rectify the error in command mode. Regards Baghathsingh.R
1
3204
by: ajd335 | last post by:
Hi all... I am working with PHP and mysql. I have one form from which i am importing data into the table. Now i want "email " field result into a text file I am using code select email from table_1 into outfile '/location/result.txt';
1
2311
by: ajd335 | last post by:
Hi all... I am working with PHP and mysql. I have one form from which i am importing data into the table. Now i want "email " field result into a text file I am using code select email from table_1 into outfile '/location/result.txt';
2
23267
ram09
by: ram09 | last post by:
im trying to dump my database for a replication but i encounter this error message... mysqldump: Got error: 1045: access denied for user 'ODBC' @ 'localhost' <using password NO> when trying to connect.... can somebody tell me how can i solve this problem please..
0
9921
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9765
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11065
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10700
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10795
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7934
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7098
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4177
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3203
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.