Re: Root user Access denied - Please Help!

2002-05-23 Thread Egor Egorov
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

Re: Root user Access denied - Please Help

2002-05-22 Thread Ryan Hatch
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