Page 1 of 1

changing password on mysql wont work

PostPosted: 03. August 2005 02:26
by morkz
hello everyone

i read the notes and looked at the Addendum 2 : "MySQl & PHP " and want to change my password that connects to mysql at present its just as xampp default root and ""

however when i went into commnad prompt and went into the apporipate area it didnt work...

i wanted to use user = test and password abc or do i have to leave the username as root?

it states that mysqladmin unable to change password 'Acess denied for user ''@%' to database 'mysql'

PostPosted: 03. August 2005 02:27
by morkz
alright i just figured it out i have to leave username as root...

can anyone explain why?

PostPosted: 03. August 2005 09:49
by Wiedmann
however when i went into commnad prompt and went into the apporipate area it didnt work...

When you do what?

BTW:
http://localhost/phpmyadmin/ --> privileges

i'm having the same problem...

PostPosted: 03. August 2005 14:18
by CaptainOok
i'm having the same problem!
i tried using the command line: mysql -u root -p
but i couldn't log in. also tried with password "root", but still couldn't log in.

i tried changing the password in config.inc.php, but no use.
i also tried using winmysqladmin to change the password in my.ini, but still no use.

help?

PostPosted: 03. August 2005 14:28
by Wiedmann
i tried using the command line: mysql -u root -p
but i couldn't log in.

I'm badly with guessing... Any output/message when you execute this command?

yes

PostPosted: 03. August 2005 14:32
by CaptainOok
here it is:
C:\apachefriends\xampp\mysql\bin>mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

PostPosted: 03. August 2005 15:54
by Wiedmann
This happens after the XAMPP installation or after a while?
(You have made some changes by your self?)

well...

PostPosted: 03. August 2005 16:06
by CaptainOok
it's happened after a while. i might've made some changes, but i can't tell you what they were.
any way to reset any changes made? maybe i should just reinstall it...?