Hello.
You should start mysqld-nt with --skip-grant-tables option and
manually update the user table. Connect to server using mysql
command line client. Execute the following statements:
use mysql;
update user set Grant_priv='Y' where user='root' and host='localhost';
Restart the se
On Saturday 14 December 2002 23:07, tlr7425 at garnet dot acns dot fsu dot edu
wrote:
> how exactly do I change the Root user's password for mysql?
>
> like this? :
>
> mysqladmin -u root -p'newpasswd' ? (without a space between -p and
> 'newpasswd' ?)
>
> and, if that is correct, I guess I'd
After loging in mysql as root, enter the command:
SET PASSWORD FOR root=password('the_new_password');
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 14, 2002 5:07 PM
> To: [EMAIL PROTECTED]
> Subject: Root user password changing
>
Miretsky,
Wednesday, May 22, 2002, 8:41:57 PM, you wrote:
M> I tried to create a password for the root user in a new installation of
M> MySQL by typing
M> % mysql -u root mysql
M> Then typing and update statement like
M> Update user set password = "somepassword" where user="root";
You must use
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
"Miretsky, Anya" wrote:
> I tried to create a password for the root user in a new installation of
> MySQL by typing
> % mysql -u root mysql
> Then typing and update statement li
I've been watching this thread and wonder if not following instructions may be
contributing to the present confusion.
On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote:
>>>Show me the output of the following:
>>> SHOW GRANTS FOR 'username'@'hostname';
>
>RQ> output:
>RQ> mysql> show gra
Rob,
Thursday, March 14, 2002, 10:15:54 PM, you wrote:
>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
RQ> output:
RQ> mysql> show grants for 'root@localhost';
RQ> ERROR 1064: You have an error in your SQL syntax near
RQ> 'grants for 'root@localhost'' at lin
>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
output:
mysql> show grants for 'root@localhost';
ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at
line 1
I noticed that my user table doesn't seem to have all the fields it
--- Simon Green <[EMAIL PROTECTED]> wrote:
> Hi Jeff
> As long as you have a user that has access to all of
> MySQL and can enter
> from root on the systems, what you call it is not
> important.
> Infact it is a good thing to change the root user
> name for security.
> Simon
Thanks for the respon
Hi Jeff
As long as you have a user that has access to all of MySQL and can enter
from root on the systems, what you call it is not important.
Infact it is a good thing to change the root user name for security.
Simon
-Original Message-
From: Jeff Corliss [mailto:[EMAIL PROTECTED]]
Sent:
10 matches
Mail list logo
