Page 1 of 1
changing password on mysql wont work
Posted:
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'
Posted:
03. August 2005 02:27
by morkz
alright i just figured it out i have to leave username as root...
can anyone explain why?
Posted:
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...
Posted:
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?
Posted:
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
Posted:
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)
Posted:
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...
Posted:
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...?