Malka Cymbalista schrieb:
Thanks for your reply. When I do show grants, I get back
GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'super' @ 'localhost' ( mailto:super'@ 'localhost' ) identified by password...
So it looks like super doesn't have rights to select
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
[EMAIL PROTECTED] wrote:
Hi all!
Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:
--
SELECT pg_type.oid,
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file created by
mysqldump.
Brown, Charles schrieb:
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be included in the dump file created by mysqldump. What is the function
of
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles [EMAIL PROTECTED] wrote:
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be
Yes. Just use --all-databases as mysqldump option and the 'mysql' schema is
included.
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 12:15 PM
To: mysql@lists.mysql.com
Subject: Are user privileges included in MYSQLDUMP
Using mysqldump,
Yes you will have all the GRANTS for every user sitting in the 'mysql' schema
(from mysq.user) if you use the --all-databases option of mysqldump.
Here is something radical if you want to record the grants yourself:
Run the following query
SELECT CONCAT('SHOW GRANTS FOR
On Wed, 19 Mar 2008, Rolando Edwards [EMAIL PROTECTED] wrote:
Yes you will have all the GRANTS for every user sitting in the
'mysql' schema (from mysq.user) if you use the --all-databases
option of mysqldump.
Can I safely assume that dumping the database named mysql dumps just
as well as using
Yes !!!
mysqldump -h... -u... -p... mysql MySQLSchema.sql
Give it a try !!!
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 2:17 PM
Cc: mysql@lists.mysql.com
Subject: RE: mysql privileges
On Wed, 19 Mar 2008, Rolando Edwards [EMAIL
Here is something radical if you want to record the grants yourself:
Run the following query
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') UserGrants FROM
mysql.user WHERE user IS NOT NULL AND user '' AND host IS NOT NULL AND host
'';
This query will create a SHOW GRANTS FOR
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file allows security over rides. Please help
I have tried mysql -uroot. It
Hi,
On 3/19/08 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote:
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote:
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
Thanks,
John
DROP TABLE IF EXISTS
John Taylor-Johnston schrieb:
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
17 matches
Mail list logo