Avatar billede fredand Forsker
01. april 2005 - 16:19 Der er 4 kommentarer og
2 løsninger

How to set the root password?

Hello!

I try to install mysql but I can not set the new root password right.

When I install mysql I can log in without any password like:

C:\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.49-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

But if I try to change it like:

UPDATE user SET Password=PASSWORD('mupmup') WHERE user='root';

Or like in the manual:

C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysqladmin -u root password mupmup

I can not log in again I just get:

C:\mysql\bin>mysql -u root -p
Enter password: ******
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

So if any one got any idea please let me know!

Best regards
Fredrik
Avatar billede plx Nybegynder
01. april 2005 - 16:44 #1
have you tried flushing the privileges after change of password?

FLUSH PRIVILEGES;
Avatar billede arne_v Ekspert
01. april 2005 - 18:13 #2
try:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');

(assuming you can get in again !)
Avatar billede fredand Forsker
04. april 2005 - 12:53 #3
Hello!

Suddenly it just start to work. I do not know what I did right. The first 6 times it didn't work.
Very strange!

BTW
I insist you guys should give me a "svar" so I can reward you for your time!

Best regards
Fredrik
Avatar billede arne_v Ekspert
04. april 2005 - 12:59 #4
.
Avatar billede plx Nybegynder
04. april 2005 - 15:44 #5
ok. But forgetting to flush the privileges can explain why it just suddenly started to work
Avatar billede fredand Forsker
04. april 2005 - 16:32 #6
Thanks Mates!
/Fredrik
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester