Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 08-06-2010, 12:22 AM   #1
Beta Member
 
Join Date: Aug 2010
Posts: 1
Default access denied for root@localhost(using password:yes)

hi, I am working on my site which runs on tomcat server with mysql database developed in java. I am facing a problem while installing mysql. I have a website in my server which runs on joomla and wamp. So, when I install mysql as separate component(not the one present in wamp). I get the error 1045: access denied for root@localhost (using password yes). how can i get rid of this? trying to resolve since a week.
And can we have two mysql instances in a machine(mysql of wamp and individual mysql component) ?
__________________

gint59 is offline   Reply With Quote
Old 08-07-2010, 05:00 PM   #2
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,425
Default Re: access denied for root@localhost(using password:yes)

You need to use mysqladmin to set the root password for the first time. Assuming my password here is bobby:

Code:
mysqladmin -u root password bobby
Quote:
And can we have two mysql instances in a machine(mysql of wamp and individual mysql component) ?
Yup - but they'll need to be separate installations, using separate sockets and run on separate ports. It's possible but not what's generally done - the norm is to use the same install and just have separate databases with separate users (each user only having permissions for each database.) Beyond that there's not a whole lot of need for separate installations on the same server.
__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:03 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0