> 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 database?
See the do
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
De
> Date: Monday, October 03, 2016 18:39:22 -0700
> From: James Moe
>
> 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
efault 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 (42
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 'x
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 'x
> -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,
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
> -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/20
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 ''@'%'
then flush privileges.
>
> JW
>
>
> On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent 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
>
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 wrote:
> I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
> the very specific mysql.time_zone_nam
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 the
ost |
+-+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+-+
1 row in set (0.00 sec)
best regards
liuyann
> From: s
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&
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 PRIVIL
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
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>
ystem 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
'' WITH
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
what is the purpose of 'Grant usage ' command
http://search.mysql.com/search?site=refman-50&q=grant+usage&lr=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
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
Aug 26, 2009 at 2:33 AM, Joe 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 pas
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 is
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?
*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_s
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)]>
2009/5/27 Daevid Vincent
>
> 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`.
On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent 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'
*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&
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 wrote:
> Now I'm really confused.
>
> I just did this:
>
> REVOKE ALL PRIVILEGES, GRAN
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 'f
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';
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 PASSWO
]
> Sent: 07 May 2009 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
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 'passw
y a "mkdir" in Unix, makes me wonder if you don't have a file
> permissions error on the datadir directory.
>
> On Wed, May 6, 2009 at 9:14 AM, John Clement
> wrote:
>
> > I'm clearly doing something wrong. All I want is to grant a user rights
>
ry.
On Wed, May 6, 2009 at 9:14 AM, John Clement
wrote:
> 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 t
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
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'
like you don't need the money,
love like you'll never get hurt,
and dance like nobody's watching.
--- Begin Message ---
-BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
GRANT SELECT ON X.* TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X';
I need to change that
-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.%' IDENTIF
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
s the case, then yes, it can be done but as far as I
know, only by selecting ALL databases.
Such as:
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY
'passwordString';
FLUSH PRIVILEGES;
Then, when updating privileges for 'admin
est) 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.* to 'admin'@'localhost';
grant all on test.* to 'admin'@'10.0.0.%';
GRANT ALL PRIVILEGES ON test.* TO 'admin'
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
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
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 gra
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 a
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 quotin
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';
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.
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
To
GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50'
IDENTIFIED BY '' 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 '' WITH GRANT
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]
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
whos
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 intentiona
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'@'
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'@'
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 '%'
> 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
> 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
> 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
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'@
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 g
> 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'@'%' i
host '%' is not working or need to do something
so it allows 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:
S
nd 'localhost' to
>> connect locally and from another location???, or...
>>
>> 2) for some reason a host '%' is not working or need to do something
>> so it allows connections from any host?
>
> Remember to quote the user and host carefully. So,
>
to do something so it
allows 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
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
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
sql> CREATE USER dev 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 d
> 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
server312# mysql -udev
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: http://lists.m
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_SCHE
'foo_'.
I'm hoping that I am just being blind 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 sel
ple 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 of wildcards, to no avail.
Please tell me I'm not going to
r 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 of wildcards, to no
a
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 i
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 combinati
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 administr
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'@'loc
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 [
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] identi
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.
sheeri kritzer wrote:
> GRANT FILE ON dr4.* to
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 wo
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 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
root.
1-I 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 :
my
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:http://lists
nd then revoke
his 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
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
> probab
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 .FROM user
GRANT and REVOKE are essential to your database security, I would
think twice before adding a "layer" on top of them. There is pot
> 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 GRA
ds 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
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
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 the
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
(using password: YES)
So 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
1 - 100 of 573 matches
Mail list logo