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
>
*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I
am. If I want to be treated like an idiot, I'll use microsoft software.
On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent wrote:
> I'm a little concerned and disappointed that the GRANT command doesn't do
> any sort of c
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
Need to know the correct syntax for granting a new user access to a =
MySQL database with select, insert and updates privileges only and only on a =
particular database and table (although there are multiple tables).
Tried using the following:
grant Select,Insert,Update on Ruby.oCeremony to beilby
Scott Gerhardt writes:
> I was just wondering what the "USAGE" privilege is good for and where it
> would be used?
>
> Pauls's book says that USAGE is a special "no privileges" privilege.
>
>
> ___
>
> Scott A. Gerhardt P.Geo.
> Gerhardt Information T
