changing password on mysql wont work

Problems with the Windows version of XAMPP, questions, comments, and anything related.

changing password on mysql wont work

Postby morkz » 03. August 2005 02:26

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'
morkz
 
Posts: 2
Joined: 03. August 2005 02:20
Location: melbourne australia

Postby morkz » 03. August 2005 02:27

alright i just figured it out i have to leave username as root...

can anyone explain why?
morkz
 
Posts: 2
Joined: 03. August 2005 02:20
Location: melbourne australia

Postby Wiedmann » 03. August 2005 09:49

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
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

i'm having the same problem...

Postby CaptainOok » 03. August 2005 14:18

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?
CaptainOok
 
Posts: 3
Joined: 03. August 2005 11:33

Postby Wiedmann » 03. August 2005 14:28

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?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

yes

Postby CaptainOok » 03. August 2005 14:32

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)
CaptainOok
 
Posts: 3
Joined: 03. August 2005 11:33

Postby Wiedmann » 03. August 2005 15:54

This happens after the XAMPP installation or after a while?
(You have made some changes by your self?)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

well...

Postby CaptainOok » 03. August 2005 16:06

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...?
CaptainOok
 
Posts: 3
Joined: 03. August 2005 11:33


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 65 guests