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. 12 2823
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 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 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
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
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
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 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 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 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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: KnockKnock |
last post by:
Hi all,
I have run into a bit of a problem. I recently setup mysql to run on a
Debian Linux box I setup. I am by no means an expert on either linux or
mysql. I know enough to just be dangerous....
|
by: Ola Ogunneye |
last post by:
--=_7B255FAE.1F7E0C30
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Hello all,
Let me start out by saying that I am still a newbie. I just freshly
installed...
|
by: Ryan Schefke |
last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
..I just sent this out to the win32 distribution list but no one has...
|
by: SteveWa |
last post by:
I have installed MySQL 4.0.15-0 from a RPM at the MySQL.com website
using the command line syntax:
root# cd /tmp/downloads
root# rpm -i MySQL-server-4.0.15-0.i386.rpm
after I install that...
|
by: ruud |
last post by:
I just installed MySQL server 3.23.58-1. Now I can't find the password en
can's change the settings. Who knows this password?
|
by: os2 |
last post by:
hi
i have installed mysql via yast under suse 9
linux:/home/mcollin # rcmysql start
Starting service MySQL done
i try to change the password...
|
by: MLH |
last post by:
I'm supposed to set a password for the MySQL root user. The output of
mysql_install_db instructed me to run the following commands...
/usr/bin/mysqladmin -u root -h appserver password mynwewpasswd...
|
by: Atli |
last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users.
Anyone should be able to get...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |