I would like to thank everyone who gave suggestions about how to fix the mysql
privileges. Here's what we did:
We did a mysqldump on the mysql table on the old machine.
We brought the mysqldump into the mysql table on the new machine
We ran mysql_fix_privilege_tables
We gave the commandf
> AllGrants.sql
AllGrants.sql will have all GRANTS but each line has no semicolon at the end
Just append a semicolon at the end of every line like this:
sed -i 's/$/;/' AllGrants.sql
Give it a try !!!
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Wed
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 <
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 us
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.
Please help me!
-Origi
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 c
ldump.
Please help me!
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 1:24 AM
To: mysql@lists.mysql.com
Subject: Re: mysql privileges
Malka Cymbalista schrieb:
> Thanks for your reply. When I do show grants, I get back
>
&
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 from
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 from the hr table. But
why no
Hi,
On Tue, Mar 18, 2008 at 8:49 AM, Malka Cymbalista
<[EMAIL PROTECTED]> wrote:
> We are currently running MySQL 4.0.15a on a Sun Solaris server. We are
> moving to a Linux machine running MySQL 5.0.45.
> I am having a problem with permissions in MySQL.
>
> On the current machine running 4.0.
* now i can access with [EMAIL PROTECTED] but i can't create databases
What does "show grants" display when you login as root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is this a typical situation? If those 1 or 2 tables have higher security
requirements than the rest, so some users should have access to all the
tables except them, another option would be to move them to a separate db.
Then you could grant the average user access to the db with the rest of the
I am afraid you have read the docs correctly. Privileges exist at 4
levels: Global, Database, Table, and Column. So, for someone to only see
part of a database, you have to GRANT permissions to the specific tables
that user gets rights to work with. No other way around it.
However, you may be
Greetings,
I am sorry if I am asking a question that has already been answered
somewhere. If it was and you know where - please let me know.
I am trying to give access to a user, who should have access to a
specific database with over 200 tables and should not have access to
one or two of them.
[EMAIL PROTECTED] wrote:
> I am running MySQL 4.1.1-alpha-standard on RH Linux 9. I've found strange
> problem with privileges:
>
> mysql> grant reload on *.* to 'fabackup'@'localhost';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> grant create, insert, drop on mysql.ibbackup_binlog_marker to
At 12:24 -0700 6/8/03, Mike Walth wrote:
Hello:
I was wondering if anyone had any advice to a couple questions.
1) Can I add additional columns to the user and db tables of mysql. These
would be for administrative purposes only.
You can, but doing so is unsupported, and the server won't do anyt
"Mike Walth" <[EMAIL PROTECTED]> wrote:
> I have gone through the documentation, and also the archives, and still
> can't grasp why things happen with privileges.
>
> Here is what I am trying to understand and accomplish. For my own benefit
> I'm trying ot understand the user and db tables of mys
Hi Mike,
there are two reports on devshed which I believe are an excellent source.
There is really nothing to add. Print them off read them carefully on your
way home and tomorrrow you will be 2 steps further.
http://www.devshed.com/Server_Side/MySQL/Access/page1.html
http://www.devshed.com/Ser
mmand and nothing unusal from what it reported.
>
>Regards,
>Michael
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "Yat-Shing Tam" <[EMAIL PROTECTED]>
>Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
>Sent: Wednesday, July
gt;
Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 17, 2002 10:23 PM
Subject: Re: MySQL Privileges Question
> Did you try:
>
> FLUSH PRIVILEGES;
>
> Also, to see what user can do with his permissions you can try this:
>
> SHOW GRANTS FOR us
Did you try:
FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this:
SHOW GRANTS FOR username;
Mihail
Quoting Yat-Shing Tam <[EMAIL PROTECTED]>:
> Hi fellows,
>
> I have a MySQL privileges question and hope someone can provide some
> input on it.
>
>
Look up skip_grants in the manual
- Original Message -
From: "Chee-Siong Cheong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 14, 2001 23:02
Subject: Mysql privileges problem
> Hi everyone,
>
> Recently I accidentally modify the user permission of "root" from
> "loc
Chee-Siong Cheong writes:
> Hi everyone,
>
> Recently I accidentally modify the user permission of "root" from
> "localhost" to "any" with webmin. After I modified, I can no longer connect
> to the database with my machine, the error is
>
> ERROR 1045: Access denied for user: '@localhost'
>
>
23 matches
Mail list logo
