We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

My sql server installation error

onanar
onanar asked
on
Medium Priority
317 Views
Last Modified: 2012-05-07
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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

Author

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
CERTIFIED EXPERT

Commented:
@ 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 :
https://www.experts-exchange.com/Database/MySQL/Q_24524977.html

Bm keshav

Author

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.?
CERTIFIED EXPERT

Commented:
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

Author

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.
CERTIFIED EXPERT

Commented:
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

Author

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..
CERTIFIED EXPERT

Commented:
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

CERTIFIED EXPERT

Commented:
Pl.refer the below link and read the author's comment as under :

https://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

Author

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..

Author

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

Author

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
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks a lot BMKHESAV , I have cmpleted my taks with your help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.