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 command
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
.
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
GRANT SHOW DATABASES
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
@lists.mysql.com
Subject: RE: mysql privileges
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
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
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 PROTECTED] wrote:
Yes you will have all the GRANTS for every user sitting
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
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.15a,
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
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
* 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]
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
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
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
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
[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
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
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
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
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 mysql.
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 username;
Mihail
Quoting Yat-Shing Tam [EMAIL PROTECTED]:
Hi fellows,
I have
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 17, 2002 10:23 PM
Subject: Re: MySQL Privileges Question
Did you try:
FLUSH PRIVILEGES;
Also, to see
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='%' User='user_name
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.
I have
Felik,
Tuesday, March 26, 2002, 10:11:31 AM, you wrote:
FH In MySQL, pls tell me which privileges should I grant
FH to every
FH user so they can change their password?
They should have grant privilege but it's not right way giving
access to MySQL privilege tables.
You can read more about MySQL
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!
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
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 working on a Linux Mandrake 8.1 station.
I have installed
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
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'
What
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&qu
35 matches
Mail list logo