Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old Nov 27th, 2007, 12:53 AM   #1
Yeanni
Newbie
 
Join Date: Nov 2007
Location: kl,malaysia
Posts: 1
Rep Power: 0 Yeanni is on a distinguished road
Unhappy Connection Error (usually when MySQL is being installed over a previous version)

I installing and configuring Apache 2.2.4, MySQL 5.0.27 and PHP 5.2.1 on Microsoft Windows XP.

In some cases (usually when MySQL is being installed over a previous version), the MySQL Server Instance Configuration Wizard will give a Connection Error..

Problem occur when setting security options:

1.(i don't know current password)
2.enter root password
3.Confirm (retype) your password


error number 1045: the security setting could not be applied.
access denied for user 'root'@'localhost'

Any1 can help in tis installation. thanks..
Yeanni is offline   Reply With Quote
Old Nov 27th, 2007, 1:35 PM   #2
Infinite Recursion
Programming Guru
 
Infinite Recursion's Avatar
 
Join Date: Jul 2004
Location: United States
Posts: 3,453
Rep Power: 7 Infinite Recursion is on a distinguished road
Send a message via MSN to Infinite Recursion Send a message via Yahoo to Infinite Recursion
Re: Connection Error (usually when MySQL is being installed over a previous version)

Seems like the configuration wizard is not applying the new password so it leaves the root password blank.

When you start the MySQL command line client... just press ENTER when you are prompted for the password.

Change the root password by executing:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');



Maybe that will help.
__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."
Infinite Recursion is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Annoying MySQL Connection Problem mackay6 Other Web Development Languages 6 Oct 22nd, 2006 2:15 AM
MySQL connection bottleneck? Jimbo Other Web Development Languages 8 Jun 28th, 2006 8:27 PM
Tutorial - Using MySQL in C# Darkhack C# 12 Jan 17th, 2006 9:28 AM
Converting to a previous version of Delphi CaptainChaNinja Delphi 4 Aug 22nd, 2005 7:08 PM
Creating MySQL connection in C# OpenLoop C# 5 May 28th, 2005 12:46 PM




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 6:39 AM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC