- - - - -

MySQL question


  • Please log in to reply
4 replies to this topic

#1 shrdlu

shrdlu

    Small Orange

  • Members
  • PipPip
  • 12 posts

Posted 18 January 2011 - 11:03 PM

Hi guys

This isn't really a coding question, but here goes anyway.

I recently installed MySQL+php+drupal on my laptop for some learning&testing. The problem is, I can't recall what I used for the root password for the MySQL setup... I tried deleting MySQL along with any leftover folders and reinstalling, but that doesn't seem to work. I also followed the method for resetting database password on the MySQL forums but it doesn't seem to work for some reason.

The simplest way should be just deleting the whole thing and reinstalling from scratch right? Can anyone tell a foolproof way of doing that?

I'm running 32bit win vista.

thanks!

#2 davidatfuzzylime

davidatfuzzylime

    Designer; coder; geek

  • Members
  • PipPipPipPipPip
  • 425 posts

Posted 19 January 2011 - 04:41 AM

Sounds like the root password is still floating around in a settings file. Try reinstalling it, then following these instructions:

http://dev.mysql.com...ermissions.html
fuzzylime: we know design
Save money when you sign up! Go here then use code giveme15 to get 15% off or giveme5 to get $5 off your order.

#3 billzo

billzo

    Very Large Orange

  • Members
  • PipPipPipPipPip
  • 587 posts

Posted 19 January 2011 - 09:34 AM

The default installation of MySQL allows connections only from localhost (it did when I installed it).  So, there really is no need for a complex password on your personal development server.  Just use your name or something.  Outsiders cannot connect.  

You could also try a package like XAMPP that will install Apache, MySQL, PHP, Perl, phpMyAdmin, and other stuff.  It's got everything you need.  I've never used it, but people recommend it highly on webmaster forums.
Posted Image
Click here to sign up with A Small Orange today!  

ASO servers are fast and they offer excellent support for a great price.  ASO is the BEST host around!

I have been with ASO since June 2007 and recommend this host highly.  ASO has only gotten better over time.  There is no better testimonial about the quality of service of a webhost than a long-term customer like me.  Don't make a frustrating and time-consuming mistake of signing up with any other webhost.  ASO is what you need.

Whether you are hosting a small hobby site like a Wordpress blog, a serious business website, or need a Dedicated Server, VPS or Cloud hosting, ASO has superior quality professional-level hosting packages for you.


View A Small Orange Hosting Plans


$$$ Coupon codes to save you money $$$

Code to save $5: saveme$5
Code to save 15%: saveme15%


Enter the coupon codes when ordering to get your discount. Save $5 or 15% off your initial order.

Sign up with A Small Orange today!  You will be glad you did.
Posted Image

#4 jednorozec

jednorozec

    Eclectical Engineer

  • Volunteer Moderators
  • PipPipPipPipPipPip
  • 1,120 posts

Posted 19 January 2011 - 02:36 PM

XAMPP is a very painless install of everything you need. You can even put it on a memory stick and carry your site around with you.
Join ASO and use a coupon to Save $5 or Save 15%

#5 shrdlu

shrdlu

    Small Orange

  • Members
  • PipPip
  • 12 posts

Posted 22 January 2011 - 04:42 AM

Thanks guys! Another uninstall with revo uninstaller solved the issue.

Thanks about the xampp recommendation! I'll definitely look into it.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users