My sql server installation error

Hi
I am trying to install My Sql Server, But I could not, Its showing an error " unable to connect user root throguh localhost with (Password="yes")"

I have installed Xampp, but that is for my php stuff. But now i would like to install my sql server seperatly for my java program.

Is there any problem with that?

Please suggest me...

Thanks in advace
onanarAsked:
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.

BALMUKUND KESHAVCommented:
Pl.explain the version of MYSQL as well as OS on which you are installing. Pl put the screen print of the screen where you are getting this error :

Bm Keshav
0
onanarAuthor Commented:
Hi

Thanks for your quick response.. I am using windows XP and I am installing Mysql-5.1, Please find the attached scrren shot. Ii is asking for the current password even though I uninstalled the Mysql.
New-Microsoft-Office-Word-Docume.docx
0
BALMUKUND KESHAVCommented:
@ Onanar :
I am  unable to open your docx file, b/c i am using word 2000. Any how have you completely uninstalled Mysql and rebooted the system.
If yes, please check MYSQL-Service, in Win-xp, if its still showing, please remove it and try to reinstall.

For knowledge base you refer the below link :
http://www.experts-exchange.com/Database/MySQL/Q_24524977.html

Bm keshav
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

onanarAuthor Commented:
I tried in many ways, but I could not finish the installation.. some times I am getting "windows service couuld not be started" and some times "unable to connect user root throguh localhost with (Password="yes")". Now I have decided to uninstall again.

can you please tell me what are the steps i need to do while installing.
here are my steps
1-> down load my sql community server from the below link
http://dev.mysql.com/downloads/
2-> down load the software Windows MSI installer for mysql server.
3-> Run the exe file in my system
these are the steps I have done so far..
I am getting the error only after giving the password for my root.
any ideas.?
0
BALMUKUND KESHAVCommented:
what error its showing ? The defaul root password is blank ( i mean null), During installation its again asking current password ? After uninstallation and refresh installation it should not ask for current password, it should only ask for new password and confirmation.

Can you tell me win xp version/edition and service pack ? or try to install it on another m/c with os win'xp prof. service pack >=2

Bm keshav

0
onanarAuthor Commented:
I am using Windows XP version 2002 service pack 3. After uninstalation also it isasking  current password. is there any problem with Xampp. I have installed this in my computer, will i need to uninstall this one ? because it has got mysql . by the way there are 2 downloads for windows
1->windows
2-windowsx64
which one i need to install.
0
BALMUKUND KESHAVCommented:
it's 1->windows..
If you have already Mysql lower ver. installed on this system, then you will have to uninstall it, so its better to install it on a fresh PC.

Bm Keshav
0
onanarAuthor Commented:
I have installed MySql server in another pc. But now I am not able to connect to that server.
The error is like this

"could not connect to specified instance
my sql error number 2003
can not connect to sql server on '192.168.2.100'(10061)"

But when i check the ping, it is pinging.

I have used mysql query browser and administrator to connect to this one

pls suggest me..
0
BALMUKUND KESHAVCommented:
Have you downloaded the latest version of mysql query browser /administrator from mysql site ?
If yes, pl, check the following :

userId, i.e. root (is default)
password i.e. blank (is default)
port i.e. 3306 (is default)

bm keshav

0
BALMUKUND KESHAVCommented:
Pl.refer the below link and read the author's comment as under :

http://www.experts-exchange.com/Databases/Mysql/Q_21368770.html

I fixed the problem. From the connection screen I pressed CTRL and pressed 'Skip'. Then from Administrator I stopped the MySQL service and started the service whithin MySQL Administrator. Then I open the Administrator again it worked. I didn't know it was that easy.

Try to do as advised above .

bm keshav
0
onanarAuthor Commented:
yes, I have installed latest version of query browser, and now I tried with
user id-root
password=blank
port-3306
 I am getting error like
mysql error number 1130
host 192.168.2.101 is not allowed to connect sql server
this host is mine..
0
onanarAuthor Commented:
Hi
I have installed it again in my system, still it is asking for current password, and sfter that it is shoiwng an error like

windows service can not be start.
pls suggest me

thanks in advance
0
onanarAuthor Commented:
how to uninstall?
I am just going to control panel -> add or remove programs and there i uninstalled the server5.1

and i am restrting the PC .

is there any thing i need to do after that
0
BALMUKUND KESHAVCommented:
@onanar : Your uninstallation procedure is right, but pl. check win service there should not be mysql service/instance running after uninstall.

Any how have you tried the method menttioned in below link :

http://www.experts-exchange.com/Databases/Mysql/Q_21368770.html

Method is :

I fixed the problem. From the connection screen I pressed CTRL and pressed 'Skip'. Then from Administrator I stopped the MySQL service and started the service whithin MySQL Administrator. Then I open the Administrator again it worked. I didn't know it was that easy.

Bm Keshav
0

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
onanarAuthor Commented:
Thanks a lot BMKHESAV , I have cmpleted my taks with your help.
0
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.