Restart mySQL service after root password change

[Florian]

I've been stumbling over this, what I consider strange, behaviour. I
installed mySQL on a Win2k machine and tried to change the root password,
which didn't seem to work.

I changed it this way:

c:>mysql
mysql> use mysql
mysql> update user set password=PASSWORD('test') where user='root';
mysql> exit

and then tried to login this way:

c:>mysql -u root -p
password: test

which didn't work. Then, after many unsuccessful attempts, I restarted the
service and suddenly the password I had set worked. Then I realized that (at
least for the root password) I needed to restart the mySQL service everytime
I changed the root password, otherwise it would not become effective.

Is this by design??? Am I doing something wrong?

This is not a COMMIT like issue, is it?
Thanks.

[Ward Taylor]

Florian wrote:

I've been stumbling over this, what I consider strange, behaviour. I
installed mySQL on a Win2k machine and tried to change the root password,
which didn't seem to work.

I changed it this way:

c:>mysql
mysql> use mysql
mysql> update user set password=PASSWORD('test') where user='root';
mysql> exit

and then tried to login this way:

c:>mysql -u root -p
password: test

which didn't work. Then, after many unsuccessful attempts, I restarted the
service and suddenly the password I had set worked. Then I realized that (at
least for the root password) I needed to restart the mySQL service everytime
I changed the root password, otherwise it would not become effective.

Is this by design??? Am I doing something wrong?

This is not a COMMIT like issue, is it?
Thanks.

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Ward Taylor]

Florian wrote:

I've been stumbling over this, what I consider strange, behaviour. I
installed mySQL on a Win2k machine and tried to change the root password,
which didn't seem to work.

I changed it this way:

c:>mysql
mysql> use mysql
mysql> update user set password=PASSWORD('test') where user='root';
mysql> exit

and then tried to login this way:

c:>mysql -u root -p
password: test

which didn't work. Then, after many unsuccessful attempts, I restarted the
service and suddenly the password I had set worked. Then I realized that (at
least for the root password) I needed to restart the mySQL service everytime
I changed the root password, otherwise it would not become effective.

Is this by design??? Am I doing something wrong?

This is not a COMMIT like issue, is it?
Thanks.

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Ward Taylor]

Florian wrote:

I've been stumbling over this, what I consider strange, behaviour. I
installed mySQL on a Win2k machine and tried to change the root password,
which didn't seem to work.

I changed it this way:

c:>mysql
mysql> use mysql
mysql> update user set password=PASSWORD('test') where user='root';
mysql> exit

and then tried to login this way:

c:>mysql -u root -p
password: test

which didn't work. Then, after many unsuccessful attempts, I restarted the
service and suddenly the password I had set worked. Then I realized that (at
least for the root password) I needed to restart the mySQL service everytime
I changed the root password, otherwise it would not become effective.

Is this by design??? Am I doing something wrong?

This is not a COMMIT like issue, is it?
Thanks.

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Florian]

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Florian]

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Florian]

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try the command FLUSH PRIVILEGES; after changing the password.
Cheers

[Aggro]

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html

[Aggro]

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html

[Aggro]

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html

[Florian]

Hehe - I do have this manual on my computer but only used it as a reference,
obviously a mistake - considering that it says it right here:

If you modify the grant tables manually (using INSERT, UPDATE, etc.), you
should execute a FLUSH PRIVILEGES statement or run mysqladmin
flush-privileges or mysqladmin reload to tell the server to reload the grant
tables. Otherwise, your changes will have no effect until you restart the
server. If you change the grant tables manually but forget to reload the
privileges, you will be wondering why your changes don't seem to make any
difference!

Thanks!

"Aggro" <sp**********@yahoo.com> wrote in message
news:ok****************@read3.inet.fi...

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html

[Florian]

Hehe - I do have this manual on my computer but only used it as a reference,
obviously a mistake - considering that it says it right here:

If you modify the grant tables manually (using INSERT, UPDATE, etc.), you
should execute a FLUSH PRIVILEGES statement or run mysqladmin
flush-privileges or mysqladmin reload to tell the server to reload the grant
tables. Otherwise, your changes will have no effect until you restart the
server. If you change the grant tables manually but forget to reload the
privileges, you will be wondering why your changes don't seem to make any
difference!

Thanks!

"Aggro" <sp**********@yahoo.com> wrote in message
news:ok****************@read3.inet.fi...

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html

[Florian]

Hehe - I do have this manual on my computer but only used it as a reference,
obviously a mistake - considering that it says it right here:

If you modify the grant tables manually (using INSERT, UPDATE, etc.), you
should execute a FLUSH PRIVILEGES statement or run mysqladmin
flush-privileges or mysqladmin reload to tell the server to reload the grant
tables. Otherwise, your changes will have no effect until you restart the
server. If you change the grant tables manually but forget to reload the
privileges, you will be wondering why your changes don't seem to make any
difference!

Thanks!

"Aggro" <sp**********@yahoo.com> wrote in message
news:ok****************@read3.inet.fi...

Florian wrote:

Thanks, that worked just fine. I got this fancy book but that author
certainly didn't mention that one...

Try using the MySQL manual with your book and you get better results:

http://www.mysql.com/doc/en/index.html