At 4:12 PM -0800 3/5/08, Garris, Nicole wrote:
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
% needs quotes around it.
I recommend always quoting the username and hos
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
At 11:57 -0500 4/21/04, Carl Karsten wrote:
I am sure that i used mysqldump to create a script that had both CREATE TABLE
and GRANT commands, but now I can't figure out how.
mysqldump doesn't generate GRANT statements.
Perhaps you are thinking of some other program.
--
Paul DuBois, MySQL Documentat
I am sure that i used mysqldump to create a script that had both CREATE TABLE
and GRANT commands, but now I can't figure out how.
Carl K
http://www.personnelware.com/carl/resume.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
alyst-Programmer
www.programEz.net
> -Original Message-
> From: Charles Cantrell [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 11:55 PM
> To: '[EMAIL PROTECTED]'
> Subject: GRANT command question
>
>
> I have recently set up mySQL on a Mandrake relea
running as expected. I
have the book "PHP and mySQL Web Development" by Luke Welling and Laura
Thomson, and have been working through the examples there.
The question I have is about the GRANT command, and the apparent results
there. I don't know if my problem is one of understanding w
Hi!
On Jul 25, Charles Cantrell wrote:
>
> I am attempting to set up an administrative user, that has the same
> privileges as root. I have been able to set up a user that appears to have
> all privileges, with the exception of GRANT privileges to other users. This
> user can create new database
running as expected. I
have the book "PHP and mySQL Web Development" by Luke Welling and Laura
Thomson, and have been working through the examples there.
The question I have is about the GRANT command, and the apparent results
there. I don't know if my problem is one of understanding w
sql,query
What are all the cipher strings possible using the GRANT command
and the CIPHER clause? The docs only give one example.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
rspr=FCngliche Nachricht-
> Von: Diego, Emil [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 7. Februar 2002 22:00
> An: '[EMAIL PROTECTED]'
> Betreff: RE: GRANT command (ERROR 1047)
>=20
> Try this
>=20
> GRANT ALL PRIVILEGES ON *.* TO root@localh
Joachim,
Thursday, February 07, 2002, 11:18:43 AM, you wrote:
JH> I am using the following versions of mysql on suse linux 7.2:
JH> frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
JH> server: version 3.23.47
JH> If I try to u
I am using the following versions of mysql on suse linux 7.2:
frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
server: version 3.23.47
If I try to use the GRANT command I get
#mysql -u root mysql
mysql> GRANT ALL ON *.* TO root@localh
Joachim,
Thursday, February 07, 2002, 11:18:43 AM, you wrote:
JH> I am using the following versions of mysql on suse linux 7.2:
JH> frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
JH> server: version 3.23.47
JH> If I try to u
-Ursprüngliche Nachricht-
> Von: Diego, Emil [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 7. Februar 2002 22:00
> An: '[EMAIL PROTECTED]'
> Betreff: RE: GRANT command (ERROR 1047)
>
> Try this
>
> GRANT ALL PRIVILEGES ON *.* TO root@localhost
I am using the following versions of mysql on suse linux 7.2:
frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
server: version 3.23.47
If I try to use the GRANT command I get
#mysql -u root mysql
mysql> GRANT ALL ON *.* TO root@localh
7;s University
Phone: (902)420-5893
Fax: (902)420-5035
-Original Message-
From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:35 PM
To: 'Andrew Dumaresq'; [EMAIL PROTECTED]
Subject: RE: Problem with Grant command
It's correct, just insert a
It's correct, just insert at the end of line:
WITH GRANT OPTION;
rtfm
Vaso
-Original Message-
From: Andrew Dumaresq [mailto:[EMAIL PROTECTED]]
Sent: 2002. január 22. 19:31
To: [EMAIL PROTECTED]
Subject: Problem with Grant command
Hello,
I have what I consider to be a very st
Hello,
I have what I consider to be a very strange problem, I log in into mysql
on my localhost I can select from and manually modify tables using
insert select and delete, but I cannot do Grant. I typed the following
command:
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'my passw
Hello,
I am trying to add a user to the mysql server so that they can access only
certain tables from one of the databases on the server. Anyway the command
that I give is:
GRANT SELECT,DELETE,UPDATE,INSERT,INDEX on clubnet.hsa_exec_listserv to hsa@"%"
identified by 'hsaadmin';
The table that
flush privileges.
Julia A. Case wrote:
> When I create a database for a customer I normally just use the following command
>
> grant all on database.* to user;
>
> And this works fine... But one customer on one of his databases can't use the alter
> command... So I went in and did a "grant
When I create a database for a customer I normally just use the following command
grant all on database.* to user;
And this works fine... But one customer on one of his databases can't use the alter
command... So I went in and did a "grant alter on database.* to user" and that
didn't fix it.
You don't.
Privileges can be set for a column in a table, but not by record.
Mark van Brenk wrote:
>
> Greetings, and I'm sorry if this is a topic that's already been covered, but I've
>read over about 100 of the past mails and can't find something similar.
>
> How do I GRANT UPDATE to specifi
Greetings, and I'm sorry if this is a topic that's already been covered, but I've read
over about 100 of the past mails and can't find something similar.
How do I GRANT UPDATE to specific columns in specific records?
Example:
I've got a table "u" which covers complete data on each user for the
23 matches
Mail list logo
