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
*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'm a little concerned and disappointed that the GRANT command doesn't do
any sort of checking (like a foreign key for example) to verify that the
database and table exist?!
I get the case of *.* but it seems crazy to me that it would allow foo.bar
when neither a database named 'foo' nor a table
Hi All!
Here is a funny thing I come across when investigating our privilege control
system. Consider the following situation:
mysql> GRANT ALL ON `%o`.* TO rafal;
mysql> GRANT SELECT ON foo.* TO rafal;
The intention is that rafal has all privileges for all objects in databases
whose name en
What I have here is a database-driven website. In the past, I created a
database and grant privileges to it. Now, I'm creating a carbon copy of
it into another website which will be a test website with a test
database. So, when I try the grant privileges to the test database, it
returned a
Have you tried: GRANT USAGE on mysql.* TO ... (fill in with your user's
information).
>From the docs (http://dev.mysql.com/doc/mysql/en/GRANT.html)
USAGE = Synonym for ``no privileges''
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ginger Cheng <[EMAIL PROTECTED]>
Hello, MySQL gurus,
I am wondering how I can grant a user the privileges to all the db except
for mysql DB. THere are many databases so I don't want to grant one by one.
But 'revoke all on mysql.* from user' does not work. Thank you for help
ginger
--
MySQL General Mailing List
For list archiv
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
PROTECTED]; [EMAIL PROTECTED]
Assunto: GRANT PRIVILEGES doesn't perform the way I expect it to??
I'm having a little trouble with granting the correct privilege to the
user with one database instead of all databases. When I do this with
all databases, it work great..
--snip--
//
I'm having a little trouble with granting the correct privilege to the
user with one database instead of all databases. When I do this with
all databases, it work great..
--snip--
//Issued SQL Command...
GRANT ALL ON *.* TO 'Username'@'localhost.domain.com'
IDENTIFIED BY 'Password'
//Corre
hat the results
should be, or if I have another problem.
I am attempting to set up an administrative user, that has the same
privileges as root. I have been able to set up a user that appears to have
all privileges, with the exception of GRANT privileges to other users. This
user can create new
s Valentin
Tokyo/Japan
2003年 6月 4日 水曜日 01:31、ajos さんは書きました:
> Use it after the grant command:
>
> flush privileges;
>
> >hi everybody...
> >
> >i just installed mysql 4.0.13 on a redhat linux 8.0
> >when i create a database as root and then grant privileges to ano
Use it after the grant command:
flush privileges;
>hi everybody...
>i just installed mysql 4.0.13 on a redhat linux 8.0
>when i create a database as root and then grant privileges to another user
>like this:
>GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY &quo
localhost" in this case.
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> > 2003å¹´ 6月 3æ—¥ ç«æ›œæ—¥ 11:31ã€Kalin Mintchev
ã•ã‚“ã¯æ›¸ãã¾ã—ãŸ:
> > > hi everybody...
> > >
> > > i just installed
ven need "-h localhost" in this case.
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
>
>
> 2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました:
> > hi everybody...
> >
> > i just installed mysql 4.0.13 on a redhat linux 8.0
> > when i creat
linux 8.0
> when i create a database as root and then grant privileges to another user
> like this:
> GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd";
>
> everything seems to be fine but then if i log in as "user" and try to get
> to the
hi everybody...
i just installed mysql 4.0.13 on a redhat linux 8.0
when i create a database as root and then grant privileges to another user
like this:
GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd";
everything seems to be fine but then if i log in as "user&
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
On Saturday 14 December 2002 02:49, John Dell wrote:
> Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are
> working), but when you view the mysql.user table, all privileges are
> showing up as 'N', when some of them should be 'Y'. Anybody seen this or
> understand what's g
Hi,
Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are
working), but when you view the mysql.user table, all privileges are showing
up as 'N', when some of them should be 'Y'. Anybody seen this or understand
what's going on?
For example:
GRANT SELECT ON dbname.* TO test
Hi,
I resubmited again for anyone with solution to assist me.
I had one question. I would like to set permission for remotely backup using
mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup
A(10.0.0.1) server.
The command I run at B server are:
mysqldump --opt -h10.0.0
Hi,
I had one question. I would like to set permission for remotely backup using
mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup
A(10.0.0.1) server.
The command I run at B server are:
mysqldump --opt -h10.0.0.1 -uadmin -pXXX comers > comers.txt
(p/s : I want to dump
Hi,
This morning, I wanted to add a new database to mysql for a web based
application. However, I don't seem to be able to grant any privileges to
the database. This is what I do
# mysql -uroot -p
mysql> use mysql
Database changed
mysql> select * from user where user='root' and host='localhost';
>
>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
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
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 Technologies
[EMAIL PROTECTED]
___
31 matches
Mail list logo
