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 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 like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password % my
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 like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password
% my
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
Rob,
Thursday, March 14, 2002, 7:01:02 PM, you wrote:
RQ> I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I
am getting an error message that says my host is not allowed to connect. I then tried
to run a GRANT query
RQ> under the mysql on the Linux machine to cr
I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am
getting an error message that says my host is not allowed to connect. I then tried to
run a GRANT query under the mysql on the Linux machine to create a valid user in the
hosts table.
I am using version 3.22