[EMAIL PROTECTED] wrote:
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement doe
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement does (at least) two things to
hi,
[EMAIL PROTECTED] wrote:
I rarely need to add users to a running setup but I always seem to run
into the same sort of problem: I grant privs to a user but they refuse
to show up. This user will be the one a web application goes through to
access the DB.
As the root user:
GRANT SELECT, I
[EMAIL PROTECTED] wrote:
I rarely need to add users to a running setup but I always seem to run
into the same sort of problem: I grant privs to a user but they refuse
to show up. This user will be the one a web application goes through to
access the DB.
As the root user:
GRANT SELECT, INSERT
Hi Sergei,
I can't think of anything else, but I would suggest checking the output of SHOW INNODB
STATUS for clues, just in case the foreign key is causing an odd error message. I
would not be surprised, as InnoDB FK error messages are sometimes hard to understand.
Cheers
Baron
Sergei wrote
Hello,
Thanks for the answer!
I checked the thing you suggested:
1) output of SHOW GRANT is correct
2) the problematic table is not a view
3) no triggers - only foreign key constraint. "ADD CONSTRAINT
`mydb2_table2_ibfk_1` FOREIGN KEY (`table2_user_id`) REFERENCES `table1`
(`usr_id`) ON DELETE
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been granted by this quer
Nevermind, I had a lingering entry in the db table. Once I deleted that
it worked as expected.
Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los Angeles, CA 90095
310/206-8216
-Original Message-
From: Lopez, Deni
Hello.
What is the output of the following statement:
show grants for 'root'@'localhost';
J C <[EMAIL PROTECTED]> wrote:
> According to phpMyAdmin I have:
> user 'root' on 'localhost'
> with no password
> with Global privileges set to 'All privileges'.
>
> If I do a SELECT us
On Saturday 10 April 2004 08:15 am, [EMAIL PROTECTED] wrote:
> hi
>
> I have redhat 7.2 running on my server with plesk
> i forgot mysql password for user root
> so i reset it by following way
>
> services mysqld stop
> safe_mysqld --skip-grant-tables &
> mysqladmin -u root fulsh-privileges passwor
On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote:
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT AL
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT ALL on *.* to
root IDENTIFIED BY 'password';
which is great, b
Andre MATOS <[EMAIL PROTECTED]> wrote:
>
> Is it possible to GRANT an USER to just UPDATE one specific FIELD instead
> of the entire TABLE?
Yes, you can grant UPDATE privilege on the certain column:
http://www.mysql.com/doc/en/GRANT.html
For example:
GRANT UPDATE(column1) ON db
"Ed Reed" <[EMAIL PROTECTED]> wrote:
>
> Is there any way to assign Privileges to databases/tables/fields via
> Groups rather than user by user?
>
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
[EMAIL PROTECTED] wrote:
>
> I am new to mysql admin. I have created a database and set a user name
> and passwd for it using
>
> grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw'
> with grant option;
>
> Now the xxx user is able to login in to the database with
>
At 14:03 -0400 7/2/03, me wrote:
On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote:
me <[EMAIL PROTECTED]> wrote:
i have a strange thing going on - i'm trying to update privileges on
some databases but it doesn't happened - even after flush privileges -
according to the manual th
On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote:
me <[EMAIL PROTECTED]> wrote:
i have a strange thing going on - i'm trying to update privileges on
some databases but it doesn't happened - even after flush privileges -
according to the manual the changes with GRANT an REVOKE sh
me <[EMAIL PROTECTED]> wrote:
>
> i have a strange thing going on - i'm trying to update privileges on
> some databases but it doesn't happened - even after flush privileges -
> according to the manual the changes with GRANT an REVOKE should take
> effect immediately but they don't. i'm using c
At 14:26 31/12/2002 +0100, Stefan Hinz, iConnect (Berlin) wrote:
Hi,
Dear list,
no one has answered my question up to now. Looking through the manual
again today, I still can't figure out what to do.
Sorry but your issue is my fault. In the next release I will update
the tables.
In the meantim
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Thomas Spahni" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, December 31, 2002 2:58 P
Stefan,
you may want to take the queries from the
mysql_fix_privilege_tables shell script and run them
manually. All queries are nice and clean in
the script and can be extracted with any editor.
Thomas Spahni
On Tue, 31 Dec 2002, Stefan Hinz wrote:
> just upgraded from MySQL 4.0.3 to 4.0.7 on
Dear list,
no one has answered my question up to now. Looking through the manual
again today, I still can't figure out what to do.
> just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home.
The problem is, I still have the _old_ privileges in my mysql tables,
not the new ones like super,
never mind it worked now , had to restart the server heh
-Original Message-
From: Dan Rossi [mailto:daniel@;electroteque.org]
Sent: Saturday, November 09, 2002 3:25 AM
To: Dan Rossi; [EMAIL PROTECTED]
Subject: RE: privileges when moving from mysql 3.23 to 4.0
i used this
Rossi [mailto:daniel@;electroteque.org]
Sent: Friday, November 08, 2002 9:20 AM
To: [EMAIL PROTECTED]
Subject: RE: privileges when moving from mysql 3.23 to 4.0
how is there a way to retain the user privileges in the mysql table when
dumping from mysql 3.23 to 4.0 ? i dont want to have to reset
how is there a way to retain the user privileges in the mysql table when
dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these
individually , let me know thanks
-
Before posting, please check:
http://www.mysql.co
>
> Hi, I read the book, but there is not explain about it.
>
> I would like to know when I give privileges to the user, in the table
> level, and after I give privileges in the database level. Do I replace
> the privileges?
Any time you execute a query, MySQL looks for the privileges needed for
OK two thinks to lookat
1. Use GRANTS as you will not have so much truble with them
2. Use "mysqlaccess" this will tell you if you have got the privileges
right..
If a user can select in 'user' table then he can do so on all databases.
(what ever is set in 'db')
If a user can select in 'db'
On Tue, 15 Oct 2002, Alexander Burbello wrote:
>
> Hi, I read the book, but there is not explain about it.
>
> I would like to know when I give privileges to the user, in the table
> level, and after I give privileges in the database level. Do I replace the
> privileges?
>
>
> There are two tab
Alec,
Saturday, October 05, 2002, 5:14:59 PM, you wrote:
>>Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a
>> global level privilege:
>> http://www.mysql.com/doc/en/News-4.0.2.html
AdCaQdC> Thank you. That page says that "To use these, you must have run the
AdCaQdC> my
Victoria Reznichenko said:
>Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a
> global level privilege:
> http://www.mysql.com/doc/en/News-4.0.2.html
Thank you. That page says that "To use these, you must have run the
mysql_fix_privilege_tables script after upgrading."
At 16:24 +0300 10/2/02, Victoria Reznichenko wrote:
>Alec,
>Tuesday, October 01, 2002, 6:50:31 PM, you wrote:
>
>AdCaQdC> What privileges do I need for creating a TEMPORARY table? I
>seem to have
>AdCaQdC> locked myself out of this - and yet I can create permanent
>tables, which
>AdCaQdC> seems
Alec,
Tuesday, October 01, 2002, 6:50:31 PM, you wrote:
AdCaQdC> What privileges do I need for creating a TEMPORARY table? I seem to have
AdCaQdC> locked myself out of this - and yet I can create permanent tables, which
AdCaQdC> seems the wrong way round.
AdCaQdC> N:\>mysql -ualec
AdCaQdC> Welco
You seem to havew a leading space in your newuser account.
Juri Nysschen wrote:
>Hi
>
>I have a problem with privileges on MySql NT 3.23.52. I hope that someone
>can provide me with a solution.
>
>If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
>another db (CUSTOMDB)
Ralf,
Wednesday, July 03, 2002, 4:48:11 PM, you wrote:
RN> The subject says it all: What rights does a user need to have (minimal
RN> rights of course) to be able to execute PURGE MASTER LOGS command?
Since version 4.0.2 user must have SUPER privilege.
before 4.0.2 you must have PROCESS privile
Alexander,
Tuesday, July 02, 2002, 5:54:48 PM, you wrote:
AB> I would like to know what does mean the privilege
AB> "References_priv" on the table users??
It's for future features...
If you will grant references_priv, user can create foreign keys.
--
For technical support contracts, goto ht
At 11:54 -0300 7/2/02, Alexander Burbello wrote:
>I would like to know what does mean the privilege
>"References_priv" on the table users??
It's unused.
>
>Regards
>
>Alexander
>
>
>
>
>sql, query
-
Before posting, please chec
Simon,
Monday, April 08, 2002, 7:05:34 PM, you wrote:
SG> have got a backup script that locks the MySQL tables then use cp to copy
SG> the tables.
SG> It then tar, then zips them up.
SG> So my queston is what is the minimum privileges that this MySQL back user
SG> needs just to lock tables?
Sin
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live Lif
After reviewing the MySQL documentation about the available privileges and
what
they would be used for, I still was not able to find my answer.
Can another user, besides root, use the replication commands?
What would be the minimum set of privileges that could use SLAVE START,
SLAVE STOP, SHOW SL
> Hi All,
> Now, I want to give to 'dbuser' privileges to read ONLY 'name' and
> 'address' columns from table 'TBL1'.
> So, I added record to mysql.user table (with no global privileges) -
> thans to thar 'dbuser' is able to connect to MySQL server, and it
> works OK. Further I added records to
Jacob Friis Larsen writes:
> What privileges should I give my user so that I can do the SHOW PROCESSLIST
> on all databases ?
PROCESS, I think, although it's somewhat of a guess.
I wish someone with more knowledge about these things
could add a clarification to that section of the manual,
seein
Hi.
On Mon, Oct 01, 2001 at 01:51:35PM -0300, [EMAIL PROTECTED] wrote:
> Hi list members,
> I've just downloaded and installed MySQL 3.23.XX for an HPUX 11.00. Every
> time I try connect to it I must insert a record in the table user for the PC
> (host) in which I'm trying the connection.
You kn
42 matches
Mail list logo
