Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 23:18:14 -0700 > From: James Moe > > On 10/03/2016 08:16 PM, Richard wrote: >> If you want/need to use it I believe you need to use the >> "backtick" to quote the name >> > Yes, that worked. Thank you. > Is there an easy way to rename a

Re: Mystery error in GRANT statement

On 10/03/2016 08:16 PM, Richard wrote: > If > you want/need to use it I believe you need to use the "backtick" to > quote the name > Yes, that worked. Thank you. Is there an easy way to rename a database? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc

Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 18:39:22 -0700 > From: James Moe <ji...@sohnen-moe.com> > > opensuse v42.1 > linux 4.1.31-30-default x86_64 > 10.0.26-MariaDB > > I have a database named "sma-v4-01". The GRANT statement does not > like that databas

Re: Mystery error in GRANT statement

use v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (420

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (420

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

I think this is one of those times you would update the mysql.user table directly, then flush privileges. JW On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent dae...@daevid.com wrote: I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for the very specific

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

directly, then flush privileges. JW On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent dae...@daevid.com wrote: I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for the very specific mysql.time_zone_name table?? I don't want to GRANT it to every individual user manually

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

, then flush privileges. You can grant access to the time zone tables just as you would do to any other table. GRANT SELECT ON `mysql`.`time_zone_name` TO '%'; GRANT SELECT ON `mysql`.`time_zone_name` TO '%'@'%'; GRANT SELECT ON `mysql`.`time_zone_name` TO ''@'%'; GRANT SELECT ON `mysql

RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

-Original Message- From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au] Sent: Friday, October 15, 2010 2:33 PM To: MY SQL Mailing list Subject: Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! Hi On 16/10/2010, at 1:47 AM, Suresh Kuna wrote: Hey Daevid

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

Hi, On 16/10/2010, at 8:50 AM, Daevid Vincent wrote: Thanks for the reply Jesper, but either there isn't a solution in your response, or I'm missing it? What I mean is that you have to explicitly give the grant to each user that should be allowed to query the table. You can't run one

RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

-Original Message- From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au] Sent: Friday, October 15, 2010 5:54 PM To: MY SQL Mailing list Subject: Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! Any user can get into mysql, it's what they can do after that's

How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for the very specific mysql.time_zone_name table?? I don't want to GRANT it to every individual user manually, I want one single GRANT that encompasses every user simultaneously. I've tried all of these, and they all are valid

GRANT issues

Greetings, I am attempting to set up permissions on DB with the following code from the terminal on Mac OS 10.6 logged into mysql with a user that has access to the mysql database GRANT SELECT ON pet_calendar.* TO username@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; I can get

Re: GRANT issues

Hi Steve Your statement will allow you to SELECT from any table in the pet_calendar database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT statement. If you would like to have a super user, just GRANT ALL Mike - Original Message - From: Steve Marquez smarq

RE: GRANT issues

| +-+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +-+ 1 row in set (0.00 sec) best regards liuyann From: smarq...@marquez-design.com Subject

GRANT ALL error - newbee

from supercrunch with mysql -u root -h cruncher -p. This seemed to work fine. But, one of the setup statements follows along with the result. I can't find the error. Help! mysql GRANT ALL PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1064 (42000): You

Re: GRANT ALL error - newbee

(supercrunch) is being used as the home for Dupal6. I connected to the cruncher system from supercrunch with mysql -u root -h cruncher -p. This seemed to work fine. But, one of the setup statements follows along with the result. I can't find the error. Help! mysql GRANT ALL PRIVILAGES ON *.* TO 'g

RE: GRANT ALL error - newbee

PRIVILAGES should read PRIVILEGES -Original Message- From: Gary Roach [mailto:gary719_li...@verizon.net] Sent: Wednesday 15 September 2010 19:11 To: mysql@lists.mysql.com Subject: GRANT ALL error - newbee I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the first

Grant Privileges Problem

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

Re: Grant Privileges Problem

Never mind. Had to add @'localhost' On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi victorsube...@gmail.comwrote: 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

GRANT USAGE (was: Re: login issue..pls help)

what is the purpose of 'Grant usage ' command http://search.mysql.com/search?site=refman-50q=grant+usagelr=lang_en Check the documentation, if you have more questions after that, get back to us. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database

Re: reverting to passwd-less root w/out --skip-grant-tables

@bluepolka.net wrote: I'm trying to get back to an earlier state where we started mysqld withOUT --skip-grant-tables but the root user had no password. Yes, insecure, but we're in restoration mode here. How do I reset/revert the root password to no password without running with --skip-grant

Re: reverting to passwd-less root w/out --skip-grant-tables

Thanks for the tips, all. Looks like we've got it restored via --skip-grant-tables and restoring some missing user rows (which caused me not to be able to see DBs in 'show databases'). I was also confused about being able to load an empty string '' into the non-null mysql.user.password field

reverting to passwd-less root w/out --skip-grant-tables

I'm trying to get back to an earlier state where we started mysqld withOUT --skip-grant-tables but the root user had no password. Yes, insecure, but we're in restoration mode here. How do I reset/revert the root password to no password without running with --skip-grant-tables? Thanks

Re: reverting to passwd-less root w/out --skip-grant-tables

Is there a specific reason you cannot do it with --skip-grant-table? You should theoretically also be able to overwrite the files user.* (there should be 3) in /var/lib/mysql/mysql/ (replace everything up to and including teh first mysql in that path with your mysql data dir) when the server

How do you remove a user from the grant table?!!

How the F do you remove a user from the grant table?!! The mysql.com site is down too by the way... (r...@localhost) [(none)] SHOW GRANTS FOR 'madc'; ERROR 1141 (42000): There is no such grant defined for user 'madc' on host '%' (r...@localhost) [(none)] SHOW GRANTS FOR 'madc'@; ERROR 1141

RE: How do you remove a user from the grant table?!!

*mysql create user 'test'@'localhost' identified by 'pass';* Query OK, 0 rows affected (0.00 sec) *mysql GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';* Query OK, 0 rows affected (0.00 sec) *mysql select * from information_schema.user_privileges where grantee like 'test'@'localhost

Re: GRANT and ticks or no ticks...

2009/5/27 Daevid Vincent dae...@daevid.com Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED

GRANT and ticks or no ticks...

Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (single quotes) GRANT ALL PRIVILEGES

FW: GRANT and ticks or no ticks...

Now I'm really confused. I just did this: REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%'; GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; and then I get this: SHOW GRANTS FOR 'user'@'10.10.10

GRANT privileges should check for db.table existence

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

Re: FW: GRANT and ticks or no ticks...

Start the server with --skip-grants-table. That will disable logins. Then do delete from mysql.user and restart :) Walter On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent dae...@daevid.com wrote: Now I'm really confused. I just did this: REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user

Re: GRANT privileges should check for db.table existence

*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 dae...@daevid.com wrote: I'm a little concerned and disappointed that the GRANT command doesn't

Re: FW: GRANT and ticks or no ticks...

On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent dae...@daevid.com wrote: So why mySQL is putting back ticks in there even though I didn't, Because it doesn't save your original statements, but recreates an appropriate set from the grant tables. and more importantly why doesn't the second

Re: grant user create privilege

, John Clement john.clem...@readingroom.comwrote: I'm clearly doing something wrong. All I want is to grant a user rights to create databases: grant create on *.* to 'user'@'localhost' identified by 'pass'; doesn't do the trick, nor does grant super on *.* to 'user'@'localhost' identified

Re: grant user create privilege

if you don't have a file permissions error on the datadir directory. On Wed, May 6, 2009 at 9:14 AM, John Clement john.clem...@readingroom.comwrote: I'm clearly doing something wrong. All I want is to grant a user rights to create databases: grant create on *.* to 'user'@'localhost

RE: grant user create privilege

You're right. As the root user, we've created dozens of databases on this server. I'm still not entirely sure what I was doing wrong but the lines from Sudhir mysql -u root -ppassword mysql create user 'user'@'localhost' identified by 'password' ; grant mysql create on *.* to 'user

RE: grant user create privilege

15:09 To: Jim Lyons Cc: John Clement; mysql@lists.mysql.com Subject: Re: grant user create privilege Did you flush privileges after creating the user? On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote: It's hard to believe this to be the case since I assume you've created other

grant user create privilege

I'm clearly doing something wrong. All I want is to grant a user rights to create databases: grant create on *.* to 'user'@'localhost' identified by 'pass'; doesn't do the trick, nor does grant super on *.* to 'user'@'localhost' identified by 'pass'; The user in question was originally

Re: grant user create privilege

John, Are you loggin in as: mysql -u 'user' -p If not, you should (from the local host obviously). The other thing to check is once you are logged in, run the following command: mysql show grants; This will tell you what the grants are for the user that is logged in (and whether or not you are

[Fwd: GRANT/REVOKE deny only 1 table in db from a user]

like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ---BeginMessage--- -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 GRANT SELECT ON X.* TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X'; I need to change that slightly so that I add a more specific 'deny

GRANT/REVOKE deny only 1 table in db from a user

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 GRANT SELECT ON X.* TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X'; I need to change that slightly so that I add a more specific 'deny' REVOKE SELECT ON X.Y TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X' obviously this doesn't work as there is no grant

Re: grant user privileges

On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same

Re: grant user privileges

On Wed, 16 Apr 2008, Daniel Brown wrote: On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant

Re: grant user privileges

databases. Such as: GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'passwordString'; FLUSH PRIVILEGES; Then, when updating privileges for 'admin', just include *.* instead of a particular database.table limit. Keep in mind, though, that 'admin' will then have

Re: grant user privileges

Sebastian Mendel schrieb: Hiep Nguyen schrieb: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do

grant user privileges

hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root): grant all on test

Re: grant user privileges

Can you give the output of the command show grants for admin; Thank You, -srini Hiep Nguyen wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's

Re: grant user privileges

Hiep Nguyen schrieb: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root

MySQL 4 Grant command

OK, what is wrong with the following statement? MySQL 4.1 doesn't like my syntax ... mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'myownpassword';

Re: MySQL 4 Grant command

At 4:12 PM -0800 3/5/08, Garris, Nicole wrote: OK, what is wrong with the following statement? MySQL 4.1 doesn't like my syntax ... mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'myownpassword'; % needs quotes around it. I recommend always quoting the username

grant user

hi all, i have a user that can only access localhost, how do i grant this user permission so that can also be accessed from 192.168.1.50? thanks t. hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: grant user

GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50' IDENTIFIED BY 'password' WITH GRANT OPTION; Or if you want a root user from a subnet GRANT [ALL PRIVILEGES|Appropriate Privileges]ON *.* TO root@'192.168.1.%' IDENTIFIED BY 'password' WITH GRANT OPTION; http

Re: grant user

On Mon, 3 Mar 2008, Hiep Nguyen wrote: hi all, i have a user that can only access localhost, how do i grant this user permission so that can also be accessed from 192.168.1.50? i got it. thanks t. hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: grant user

, March 03, 2008 11:15 AM Subject: Re: grant user On Mon, 3 Mar 2008, Hiep Nguyen wrote: hi all, i have a user that can only access localhost, how do i grant this user permission so that can also be accessed from 192.168.1.50? i got it. thanks t. hiep -- MySQL General Mailing List

How to grant privileges using REVOKE statement

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

Access denied for GRANT using root yet manual user insertion is fine

The grant flag is enabled on the root account: mysql SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; ++ | Grant_priv | ++ | Y | ++ 1 row in set (0.01 sec) mysql SHOW GRANTS FOR 'root'@'localhost'; Grants for [EMAIL PROTECTED

Access denied for GRANT using root yet manual user insertion is fine

The grant flag is enabled on the root account: mysql SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; ++ | Grant_priv | ++ | Y | ++ 1 row in set (0.01 sec) mysql SHOW GRANTS FOR 'root'@'localhost'; Grants for [EMAIL PROTECTED

Re: Access denied for GRANT using root yet manual user insertion is fine

With assistance from a friend this issue has been rectified. The current GRANT was not sufficient. After executing the new GRANT with 'ALL PRIVILEGES' (using the --init-file switch) the root user can now issue GRANTS. Additionally I apologise for duplicate posts, It was not intentional. On 9/2

Re: Problem with GRANT ... 'user'@'%'

On my servers i'm using the 'user'@'localhost' for PHP apps. running on the local web-server. Those users allocated for web-apps can only connect to their specific DB from localhost. On Tue, May 22, 2007 03:19, Miguel Cardenas wrote: Localhost is indeed a special value that isn't include in '%'.

Re: Problem with GRANT ... 'user'@'%'

If you don't specify a hostname in SHOW GRANTS, '%' is assumed. My mistake for not telling you this before. If you enable networking, and connect with mysql -h 127.0.0.1 instead of mysql -h localhost Well, in fact 127.0.0.1 and localhost produce the same effect but by using

Re: Problem with GRANT ... 'user'@'%'

Localhost is indeed a special value that isn't include in '%'. It's a feature not a bug ;) Regards, Bingo! That was the point! If i connect to the server ip or server name it works perfectly, but if I try to connect to localhost it fails unless I add a new user specific to localhost :D

Re: Problem with GRANT ... 'user'@'%'

Hm, I didn't know that! I thought it was only a special value to the client tools, which I know will try to connect via socket on UNIX machines when they see 'localhost' but will try to connect via TCP/IP when they see '127.0.0.1'. Thanks for pointing this out! Baron In fact that was the

Re: Problem with GRANT ... 'user'@'%'

from any host? Remember to quote the user and host carefully. So, GRANT ... TO 'user'@'%' not GRANT ... TO [EMAIL PROTECTED] If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' And see what host it claims the permissions are for. If you did

Re: Problem with GRANT ... 'user'@'%'

connections from any host? Remember to quote the user and host carefully. So, GRANT ... TO 'user'@'%' not GRANT ... TO [EMAIL PROTECTED] If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' And see what host it claims the permissions are for. If you did

Re: Problem with GRANT ... 'user'@'%'

Remember to quote the user and host carefully. So, The quoting is okay, I tested again If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' I've sent this command: grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass'; Then tested the show grants

Re: Problem with GRANT ... 'user'@'%'

You are still missing the GRANT for 'myuser'@'localhost' On Mon, May 21, 2007 03:06, Miguel Cardenas wrote: Remember to quote the user and host carefully. So, The quoting is okay, I tested again If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' I've sent

Re: Problem with GRANT ... 'user'@'%'

Hi, Miguel Cardenas wrote: Remember to quote the user and host carefully. So, The quoting is okay, I tested again If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' I've sent this command: grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass

Problem with GRANT ... 'user'@'%'

Hello list I have a problem adding a user with host '%' ... *** If I add a user with host '%' when trying to connect get this error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) *** If I add the same user with localhost it connects and works fine... My

Re: Problem with GRANT ... 'user'@'%'

to quote the user and host carefully. So, GRANT ... TO 'user'@'%' not GRANT ... TO [EMAIL PROTECTED] If you have doubts about what you actually granted, do this: SHOW GRANTS FOR 'user' And see what host it claims the permissions are for. If you did it wrong, it will say no such user exists

variables in grant statement

I would like to be able to use variables for user and table names in grant statements executed in a stroed procedure. It looks like grant statements are not compatible with prepare. Does any one know a good way to do this. Thanks - Ahhh...imagining

Problems w/ Grant Tables

BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'mysqluser'@'%' mysql mysql grant all on mrtablecloth.* to dev identified by 'pass'; Query OK, 0 rows affected (0.00 sec) mysql Bye server312# mysql -udev -ppass ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using

Re: Problems w/ Grant Tables

IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.04 sec) mysql CREATE USER mysqluser IDENTIFIED BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'mysqluser'@'%' mysql mysql grant all on mrtablecloth.* to dev identified by 'pass'; Query OK, 0 rows affected (0.00 sec) mysql Bye

Unable to GRANT REPLICATION REQUIRE X509 and SSL

Is it possible to require both secure connections and x509 verification on a replication user? If so, what's the syntax? I couldn't find references to this use in the manual, lists or bug tracking system. Using mysql 4.1.21 10x, Amit -- MySQL General Mailing List For list archives:

Re: Grant privs to multiple tables at once?

You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT statements for you. Write a query along these lines: SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';') FROM INFORMATION_SCHEMA.TABLES WHERETABLE_SCHEMA = 'test' AND TABLE_NAME LIKE

Grant privs to multiple tables at once?

at once and the * wildcard appears to only work by itself, not when appended to a string (i.e. I can't do grant select on biggie.foo_* to 'foouser'...). I've tried multiple variations of wildcards, to no avail. Please tell me I'm not going to have to explicitly grant privs to each table

Re: Grant privs to multiple tables at once?

by itself, not when appended to a string (i.e. I can't do grant select on biggie.foo_* to 'foouser'...). I've tried multiple variations of wildcards, to no avail. Please tell me I'm not going to have to explicitly grant privs to each table. There are actually several set of tables

Re: Grant privs to multiple tables at once?

because I don't see anything in the manual or in the MySQL book on granting to multiple tables at once and the * wildcard appears to only work by itself, not when appended to a string (i.e. I can't do grant select on biggie.foo_* to 'foouser'...). I've tried multiple variations

Re: Unable to grant replication slave/client to class c

Michael M. schrieb: I'm attempting to take a brand new mysql server build on gentoo and set up replication. I'm using GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@192.168.1.0/255.255.255.0 IDENTIFIED BY 'secret'; I'm not sure if this is correct syntax. Use the specific IP

Unable to grant replication slave/client to class c

I'm attempting to take a brand new mysql server build on gentoo and set up replication. I'm using GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@192.168.1.0/255.255.255.0 IDENTIFIED BY 'secret'; I've tried various combinations of removing the quotes, tried not using a password

[solved] Re: grant modify, doc on grant.

Thanks Dilipkumar, the syntax works fine mysql grant file on *.* to 'wr'@'localhost'; so the file privilege is for ALL databases. by the way, to allow alter, the syntax is like : mysql grant alter on dr4.* to 'wr'@'localhost'; here the alter privilege is specific to a database

Re: [solved] Re: grant modify, doc on grant.

Firstly, I apologize for my incorrect db level grant in the syntax I posted. Secondly, by going to mysql.com/grant I found the GRANT syntax page, which states: The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative

Re: grant modify, doc on grant.

Thank you Sheeri for answering, I guess this syntax works for you, but for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian sarge ) mysql GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

Re: grant modify, doc on grant.

Hi, You can try this option by grant file on *.* to [EMAIL PROTECTED] identified by 'db123'; Query OK, 0 rows affected (0.03 sec) For all the Databases. Gilles MISSONNIER wrote: Thank you Sheeri for answering, I guess this syntax works for you, but for me NO, this DO NOT work ( I run

Re: grant modify, doc on grant.

Gilles MISSONNIER wrote: Hello How to set FILE privilege enable to an already defined user ? It seems that I have to read the all manual for that. I cannot find an example in the on line manual. snip sheeri kritzer wrote: GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd

Re: grant modify, doc on grant.

Dude listen, You can given file privileges to existing users for all the Db's as if you specify as grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [ *Error* ] If you mention to all the DB for a user as: grant file on *.* to [EMAIL PROTECTED] identified by 'passwd

Re: grant modify, doc on grant.

Dilipkumar wrote: Dude listen, You can given file privileges to existing users for all the Db's as if you specify as grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [ *Error* ] If you mention to all the DB for a user as: grant file on *.* to [EMAIL PROTECTED

grant modify, doc on grant.

set up an user mysql GRANT SELECT, INSERT, UPDATE, CREATE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; 2- It works fine : mysql select my_item from my_table ; give it fine. 3- Now I want to select and put the results into a file : mysql select my_item from my_table into outfile'/tmp

Re: grant modify, doc on grant.

GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; It won't set up a new account, just add the privilege for you. -Sheeri On 5/26/06, Gilles MISSONNIER [EMAIL PROTECTED] wrote: Hello How to set FILE privilege enable to an already defined user ? It seems that I have to read

Grant to some database question

I have a database 'DB1' and user 'user1'. How to allow this user to full access (read/write/create etc.) only to database 'DB1' and deny to other databases, including view its names? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: REVOKE GRANT OPTION - is that possible?

privileges, his account details details will still persist in the user Grant table. This may not be a worry to you since he cannot get at any database resource. To remove any trace of him, you must delete him from the user table. (if you're playing with MySQL 5.0 then DROP USER is the ticket). Final

Re: REVOKE GRANT OPTION - is that possible?

Yes, and from database and table level too, but you must revoke GRANT OPTION seperately from all other privs like this: REVOKE GRANT OPTION ON database.tableFROM user GRANT and REVOKE are essential to your database security, I would think twice before adding a layer on top of them

Re: REVOKE GRANT OPTION - is that possible?

On 02.01.2006 13:41 (+0100), Imran Chaudhry wrote: GRANT and REVOKE are essential to your database security, I would think twice before adding a layer on top of them. There is potential for error and you dont want that where security is related. It is probably worth the pain of learning

REVOKE GRANT OPTION - is that possible?

on the database. So I'm close to finished now, but there's one major point that seems to be impossible or at least undocumented: How can I revoke a GRANT OPTION on a database or table from a user? The manual http://dev.mysql.com/doc/refman/5.0/en/grant.html says something about REVOKE ALL

Re: REVOKE GRANT OPTION - is that possible?

How can I revoke a GRANT OPTION on a database or table from a user? The manual http://dev.mysql.com/doc/refman/5.0/en/grant.html says something about REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... but this can only revoke the GRANT OPTION on a global level as it seems

mysqladmin --skip-grant-tables error

According to the Mysql online manual, to reset a root password one procedure is to issue the command: ./mysqladmin --skip-grant-tables to have full access to the database and update the root password as per the instructions in the manual. My problem is when I issue the command ./mysqladmin

Re: mysqladmin --skip-grant-tables error

Alfred Vahau wrote: According to the Mysql online manual, to reset a root password one procedure is to issue the command: ./mysqladmin --skip-grant-tables to have full access to the database and update the root password as per the instructions in the manual. My problem is when I issue

Re: mysqladmin --skip-grant-tables error

Michael Stassen wrote: Alfred Vahau wrote: According to the Mysql online manual, to reset a root password one procedure is to issue the command: ./mysqladmin --skip-grant-tables to have full access to the database and update the root password as per the instructions in the manual. My

Re: Grant confusion

then, I go and check the grants using SHOW GRANT There is no such grant defined for user 'myuser' on host '%.mydomain.com' OK, so there are no grants so that's why access is denied. Then I try to re-enter the grant: grant all on my_db.* to 'myuser'@'%.mydomain.com' identified by 'foobar'; Query OK

  1   2   3   4   5   6   >