Setting root password

Question

How do you set the root password in MySQL 5.6.16?

I have tries using:

UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='root';

But it's showing me: Error 1064<42000>

Are you literally typing `PASSWORD<'newpass'>`? You need to use parenthesis (`()`), not angle brackets (`<>`). `SET password=PASSWORD('newpass')` — gen_Eric, Apr 02 '14 at 15:46
@user3490152: Show us the *entire* error message, not just the error code. — gen_Eric, Apr 02 '14 at 15:46

score 3 · Answer 1 · edited Apr 02 '14 at 15:53

3

I think the command you are looking for is "SET PASSWORD".

For example it can be used like this:

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

edited Apr 02 '14 at 15:53

AeroX

answered Apr 02 '14 at 15:46

Tezyn

score 0 · Answer 2 · answered Apr 02 '14 at 15:47

0

I think the table name is user not user.root update user set password=PASSWORD("NEWPASSWORD") where User='root';

answered Apr 02 '14 at 15:47

score 0 · Answer 3 · answered Apr 02 '14 at 15:48

0

Try this:

update mysql.user set Password = PASSWORD('yourNewPass')
where User = 'root' and Host = 'localhost'

answered Apr 02 '14 at 15:48

Hackerman

Its showing update command denied to user '@localhost' for table 'user' – Thejas B Apr 02 '14 at 15:55
1

are you logged into mysql console? – Hackerman Apr 02 '14 at 15:57

3 Answers3