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
>
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
Trying to setup a new user for replication purpose, here what i got :
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2566 to server version: 4.0.20-standard
grant REPLICATION SLAVE on forum.* to repl@'%' IDENTIFIED BY 'replforum';
ERROR 1221: Wrong usage o
>
>So would anyone explain to me how can I setup up a good privileges of
>mysql server.Thx
Take a look at the manual. It's all there.. as far as I remember..
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/
Hello everyone:
After I have successfully installed mysql server 3.23.37 and connect
to it and do some operations.but I have found that there is a security
hole that other users can use "mysql" database !!!.
And I have started the server like that:
bin/safe_mysqld -Sg &
then
mysql>grant al
