Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi wrote:
> Hi;
> I created a user and then granted privileges:
> grant all to victor identified by 'pw';
> Looked good. Tried to log in as victor an no go. Please advise.
> Victor
>
I should have looked before I answered. I apologize to you and the rest of
the list for having my head up my a**..
I RTFM (http://dev.mysql.com/doc/mysql/en/GRANT.html) and find:
The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION
SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER pr
Sorry,
grant REPLICATION SLAVE on forum to repltest2@'%' IDENTIFIED BY
'replforum';
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which
privileges can be used.
(using 4.20)
Regard's
Vincent
You were attempting to gr
You were attempting to grant replication rights to all of the TABLES in
the database "forum". Try it again like:
grant REPLICATION SLAVE on forum to repl@'%' IDENTIFIED BY 'replforum';
and see if it works better ;-)
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[E
