9 Replies - 3997 Views - Last Post: 01 August 2012 - 07:50 PM

#1 miguel879  Icon User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 40
  • Joined: 20-July 12

I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 06:10 PM

I Forgot my root password in my phpmyadmin.. i try to retrieve it by using terminal but it seems it didnt work.. can somebody guide me about this... its my first time to encounter this problem..
Is This A Good Question/Topic? 1
  • +

Replies To: I Forgot my root password in my phpmyadmin..

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8963
  • View blog
  • Posts: 33,624
  • Joined: 12-June 08

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 06:18 PM

Is this on your machine? What OS is it running?
Was This Post Helpful? 0
  • +
  • -

#3 miguel879  Icon User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 40
  • Joined: 20-July 12

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 06:44 PM

ubuntu sir.. could you please guide me..?
Was This Post Helpful? 0
  • +
  • -

#4 no2pencil  Icon User is online

  • Toubabo Koomi
  • member icon

Reputation: 5191
  • View blog
  • Posts: 26,903
  • Joined: 10-May 07

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:28 PM

I would dump the databases, reinstall phpmyadmin, & load them back.

Seriously, what kind of an admin forgets root passwords?

I know which kinds, the ones that are not admins :)
Was This Post Helpful? 0
  • +
  • -

#5 miguel879  Icon User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 40
  • Joined: 20-July 12

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:37 PM

ahaha. yeah i already made it... without reinstalling phpmyadmin i still manage to reset and change my password yeah ... thanks again to never ending help of google.. ahahahahahahahahh
Was This Post Helpful? -1
  • +
  • -

#6 Atli  Icon User is online

  • D.I.C Lover
  • member icon

Reputation: 3712
  • View blog
  • Posts: 5,965
  • Joined: 08-June 10

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:39 PM

Are we talking about some phpMyAdmin specific password, or is this the actual MySQL root password?

If it's the latter, the MySQL manual provides details on how to recover from this.
C.5.4.1. How to Reset the Root Password
Was This Post Helpful? 0
  • +
  • -

#7 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8963
  • View blog
  • Posts: 33,624
  • Joined: 12-June 08

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:39 PM

.. then perhaps sharing what you did so future folk can solve the same problem..
Was This Post Helpful? 0
  • +
  • -

#8 miguel879  Icon User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 40
  • Joined: 20-July 12

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:44 PM

@no2pencil : im just new in this company and the one i replace didnt tell me the passwords. thats why i cant access the database..

heres the site hope it will help you also..

http://ubuntu.flowco...-root-password/
Was This Post Helpful? 1
  • +
  • -

#9 no2pencil  Icon User is online

  • Toubabo Koomi
  • member icon

Reputation: 5191
  • View blog
  • Posts: 26,903
  • Joined: 10-May 07

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:46 PM

Thank you for sharing the solution. Most often 'forgotten' passwords are not forgotten. They are trying to get away with something.
Was This Post Helpful? 0
  • +
  • -

#10 Atli  Icon User is online

  • D.I.C Lover
  • member icon

Reputation: 3712
  • View blog
  • Posts: 5,965
  • Joined: 08-June 10

Re: I Forgot my root password in my phpmyadmin..

Posted 01 August 2012 - 07:50 PM

Moved to the MySQL forum. This doesn't really have anything to do with PHP.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1