Page 1 of 1

Not working changed pass for mysql

PostPosted: 15. February 2007 10:16
by durbatuluk
Hi I have a strange problem... When I change on local password for mysql and restarted I cant connect for new password... Just error 1045 I dont know why but every way I change pass after i cant login for that .... Do you know why? Thx

PostPosted: 15. February 2007 10:26
by Wiedmann
but every way I change pass

Can you describe your ways?

(You have made any changes in the MySQL configuration?)

PostPosted: 15. February 2007 10:31
by durbatuluk
First I changed pass in phpmyadmin and then restart mysql after changed config file in phpmyadmin and after i cant login...
Second i changed pass in console and the same way etc... Just i cannot login with new pass...

PostPosted: 15. February 2007 10:48
by Wiedmann
First I changed pass in phpmyadmin
Second i changed pass in console

Can you explain both way more detailed?

BTW:
How can you change your password in the console, if you can't login after the first password change with phpMyAdmin?

PostPosted: 15. February 2007 10:55
by durbatuluk
No It means that I tried more ways to change pass... (create one)
Default is no pass.. So i create (change) it with phpmyadmin I tried every way in here for create pass http://www.apachefriends.org/en/faq-xampp-windows.html
But when i want login I cant...

PostPosted: 15. February 2007 11:29
by Wiedmann
But when i want login I cant...

You mean, after your password change, you can't login with a password, but you can login without a password (without additional changes)?

PostPosted: 16. February 2007 08:39
by durbatuluk
Yes, exactly! So where is my problem?

PostPosted: 16. February 2007 09:36
by Wiedmann
I tried every way in here for create pass http://www.apachefriends.org/en/faq-xampp-windows.html

Let us talk about "method 1".
What happens if you execute this command:
Code: Select all
mysqladmin -u root password secret

(copy 'n paste of the command window)

PostPosted: 17. February 2007 10:07
by durbatuluk
OK now it works suddenly it works... never mind... I have another problem now... Apache after while cant start... Just say :
The Apache service named reported the following error: Unable to open logs ... I am a bad luck man