ser'@'host'.
>
>Regards,
>Bhavin.
>- Original Message -
>From: "Michael Knauf/Niles" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, June 26, 2002 6:31 AM
>Subject: I can login to mysql as root but not as any other
;Michael Knauf/Niles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 6:31 AM
Subject: I can login to mysql as root but not as any other user...
>
> mysql is running on an i386 box with Red Hat Linux 7.0
>
> this works:
> mysql -u root -p
>
mysql is running on an i386 box with Red Hat Linux 7.0
this works:
mysql -u root -p
--it askes for the root password, and lets me into the mysql monitor. I can
create databases and tables, life seems good.
than I try something like:
Grant all on *.* to user identified by 'password';
where us