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 co
> 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
like this:
sed -i 's/$/;/' AllGrants.sql
Give it a try !!!
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 11:37 AM
To: Sebastian Mendel; mysql@lists.mysql.com
Subject: RE: mysql privileges
Here is a follow-up question: Using
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.
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.15a, when I connect to MySQL as the user
super and give the command:
select lname from hr w
* 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]
Hello,
ok, you can tell me i'm a crazy boy...
I've made a lot of changes to privileges in a mysql server.
Then, i saw 2 root account: the first may be able to access from
localhost, the second from all hosts.
Mysql server is inside our intranet so i decided to drop [EMAIL PROTECTED]
Now we have
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.
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
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
'fabackup'@localhost;
Query OK, 0 rows
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
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.
2) I'm trying to figure out how the privileges effect the system. I
understand what each one does, but h
"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
Hello all:
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 mysql.
If I setup a user with no privile
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 som
Hi fellows,
I have a MySQL privileges question and hope someone can provide some
input on it.
I have setup a user who can access only one db, say 'DB1'.
About the privileges, I set the account privilege like this:
1) In user table, this account has Host='%&#
ead more about MySQL privileges at:
http://www.mysql.com/doc/P/r/Privileges_provided.html
FH> thanks
FH> Felik
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/
hi,
In MySQL, pls tell me which privileges should I grant
to every
user so they can change their password?
thanks
Felik
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
-
Hi
Just type: mysql -u root
Regards
> -Oryginalna wiadomoæ-
> Od: COLLINEAU Franck FTRD/DMI/TAM
> [mailto:[EMAIL PROTECTED]]
> Wys³ano: 29 padziernika 2001 15:05
> Do: '[EMAIL PROTECTED]'
> Temat: MySQL privileges
>
>
> Hi!
>
> I'm w
Hi!
I'm working on a Linux Mandrake 8.1 station.
I have installed MySQL. I have typed './mysql_install_db'
When i type mysql, i have the prompt mysql>
But when i type "create database phpdig" i have the error message: "ERROR
1044: Access denied for user:
'@localhost' to database 'phpdig'."
Can a
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
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'
>
>
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'
What can I do to change it back to the origi
35 matches
Mail list logo
