Jump to content


Photo

How Can I Remove the Password from User 'root'


  • Please log in to reply
1 reply to this topic

#1 Len Jacobson

Len Jacobson

    Junior Member

  • Member
  • Pip
  • 15 posts
  • Gender:Male
  • Main OS: Other

Posted 26 May 2012 - 09:27 AM

I have been happily using the Uniform Server on my Windows 7 laptop for a couple of years. But now that I have installed Version 8.5.4, I have a problem pertaining to the password for user 'root' on the MySQL server.

Prior to using this version, there was no default password for 'root'. I was perfectly content with having no password for 'root' because I use the Uniform Server solely as a test server on my laptop. I am not concerned about security in that environment.

So now I see that after installing Uniform Server, the user 'root' has a password of 'root'. If I try to delete that password, I lose the ability to get into 'phpMyAdmin', and still my PHP code (that does not reference a password for 'root') fails when trying to connect to the MySQL server.

The "Change Password" utility (that comes up when clicking on 1 and then "Server Configuration" and then "MySQL") will not allow me to enter nothing for the password.

Can anyone suggest a way to allow no password for the user 'root'?

#2 traxxus

traxxus

    Member

  • Member
  • PipPip
  • 80 posts
  • Location:Switzerland
  • Main OS: Windows 7

Posted 28 June 2012 - 04:25 AM

Do it with commandline?

http://www.cyberciti...-root-password/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users