Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Error 1045 while installing MySQL

 
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

I'm getting 'Error Nr. 1045 -Access denied for user 'root'@localhost' (using password:YES)

It seems that I messed up while setting up root password,
I've uninstalled it many times to have a clean installation by removing it from add/remove in control panel, then deleting the service and deleting the folder in Program files.

It also seems that during new installation, if I don't enter existing root password, it shows me the same error but with (using password:NO).

I've searched many forums but nothing happened.
So finally Java Ranch
Please advise.
 
Ranch Hand
Posts: 148
Hibernate Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi pramod,

Which OS are you you using?

if you are using Microsofts OS then while installing the MySQL disable the firewall first and add the port exception to firewall after installation.

Thanks
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Vijay,

Ok, I'm using Win XP.

Trying..will let you know.

Thanks for the help.
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Now I'm getting the new error Could not start the service MySQL3 : Error 0.

First I deleted the existing service MySQL,
Then during fresh installation, I tried giving names like MySQL, MySQL2 etc. but it showed error for every name.]
And yes I checked the option of add firewall exception to this port.
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I read somewhere that in order to do the complete uninstallation, one needs to delete the file under "Program files" and then proceed with add/remove menu.
I'm trying to do that. Meanwhile during first try, I got the service can not start error. So I changed the service name and unchecked the box for setting password.
(It doesn't ask for existing root password though)

And now after 15 mins, I'm still getting the processing configuration window.

 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Got the solution guys !!!

While trying to install MySQL instance, I deleted almost everything I could see e.g. a folder in Program files, searched any entry starting with MySQL in the Search option and deleted them as much as possible. Also cleared the registry and deleted MySQL service again n again. All this didn't work.This happened for weeks.

And then I checked the machine of my friend who successfully installed it and found out that there is a folder called Application Data in Documents & settings/All users and this folder contained MySQL folder with two previously installed instances.
Deleted them and now I'm a happy user
 
Ranch Hand
Posts: 250
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It worked for me too
thanks prompd
 
Everyone is a villain in someone else's story. Especially this devious tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic