Reset Password in Mysql

7 replies [Last post]

Fri, 07/23/2010 - 21:15

arkiii

Joined: 02/10/2010

Points: 18

Hello Everyone,

I have had a strange issue come up in that I can no longer login with the password I set as the administrator.

It seemed to happen after i locked down security on my LAMPP stack. now it does not recognize my email address and password giving me an error.

I have tried to use the "forgot email" link to email me the password but that gives me the same error :

an internal server error access denied for user: 'root'@'localhost' using password: 'NO'

So my question is can i reset the password using MySQL.

Thanks

Fri, 07/23/2010 - 21:40

jeff

Joined: 06/29/2009

Points: 93

It sound like maybe your root password has changed?
Perhaps:

http://www.howtoforge.com/reset-forgotten-mysql-root-password

If not that then

http://lmgtfy.com/?q=mysql+reset+root+password

I am not sure where in the database the login credentials are stored for kalturaCE...

Fri, 07/23/2010 - 21:52

arkiii

Joined: 02/10/2010

Points: 18

I'm able to log into phpmyadmin with no problems. I can see the kaltura database but i'm not sure what i should be looking for.

adminkuser looks like it has password fields but they are encripted..

any ideas?

Sun, 07/25/2010 - 03:35

arkiii

Joined: 02/10/2010

Points: 18

I just went ahead and deleted kalturaCE and reinstalled it. I created a totally new database. Everything went smoothly...

After a bit of googling, I finally have KalturaCE working on Fedora 13 . I'm using XAMPP for linux 1.73 and it is working very weil. The only think left to do is to enable memcached, but uploading videos is working fine...

Sun, 08/08/2010 - 12:20

Kalturian

Joined: 01/05/2009

Points: 1697

Hi arkiii,

Thanks for sharing!

Did you do anything special to get CE to work on your deployement (Fedora 13 & XAMPP for linux 1.73)?
What bumps if any did you had while installing?

Thu, 08/19/2010 - 22:12

arkiii

Joined: 02/10/2010

Points: 18

Kalturian,

Plenty of bumps. So many i can't remember everything i had to try. I should have written down all the steps. Getting the XAMMP for linux configured was first issue. Not too bad after i found out the right combination of Linux 13, XAMPP 1.73 and KalturaCE. I also had to gleem lots of info from multiple sites like pieces of a puzzle...