Re: root without permissions...

2004-08-29 Thread jose usoz
On Sun, 29 Aug 2004 12:26:25 -0400 Wesley wrote: > Exit mysql. OK, then that would seem to mean that you don't have a > root user with 'localhost' as an allowable host. As long as you can ^^ > log in as jusoz, see if you can issue this: Thanks !!! localized the prob

Re: root without permissions...

2004-08-29 Thread jose usoz
> It looks like you can log in to the mysql client as root. Do you have > permission to change the password once you're logged in? > > [EMAIL PROTECTED] jusoz]$ mysql -u root -p > Enter password: > Welcome to the MySQL monitor... > > mysql>USE mysql; > Database changed. > > mysql>UPDATE user SET

Re: root without permissions...

2004-08-29 Thread Wesley Furgiuele
Jose: It looks like you can log in to the mysql client as root. Do you have permission to change the password once you're logged in? [EMAIL PROTECTED] jusoz]$ mysql -u root -p Enter password: Welcome to the MySQL monitor... mysql>USE mysql; Database changed. mysql>UPDATE user SET Password = PAS

root without permissions...

2004-08-29 Thread jose usoz
Hello, these are my first days with mySQL. Yesterday all is well. Today i changed some permissions in the databases and groups. I think i have returned to the original permissions, but i not have any permission with the user root. Is possible to restore this user?: **login with my passw -> [EMAIL