* Tim Johnson [101118 12:58]:
> * Tim Johnson [101118 11:05]:
> > using
> > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
> >
> > I have root access to the mysql command line.
> >
> > I need to grant access to user 'username' for all databases
> > except for the mysql database for both
* Tim Johnson [101118 11:05]:
> using
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
>
> I have root access to the mysql command line.
>
> I need to grant access to user 'username' for all databases
> except for the mysql database for both onsite (cgi script) and
> remote access.
>
>
using
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
I have root access to the mysql command line.
I need to grant access to user 'username' for all databases
except for the mysql database for both onsite (cgi script) and
remote access.
What is the syntax?
--
Tim
tim at johnsons-web.c
ok, i see
now the resultings files are owned by mysql.
every file has the same user granted, but the wrong one since
i can not chown user.group * as normal user.
So far i see it is the same problem as with "select into outfile"
Is there a fancy trick for mysqldump so i will create the correspondi
you also can do this:#sudo -u mysql "mysqldump command"
or
#su - mysql -c "mysqldump command"
2009/7/24 walter harms
>
>
> muhammad subair schrieb:
> > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
> >
> >> Hi list,
> >> i use mysqldump --tab to create database dumps. this will prod
muhammad subair schrieb:
> On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
>
>> Hi list,
>> i use mysqldump --tab to create database dumps. this will produce txt and
>> sql files.
>> the resulting sql files is owned by the user but the resulting datafile is
>> owned by mysql.mysql
>> is
# chown mysql.mysql datafile
2009/7/23 walter harms
> Hi list,
> i use mysqldump --tab to create database dumps. this will produce txt and
> sql files.
> the resulting sql files is owned by the user but the resulting datafile is
> owned by mysql.mysql
> is there any way to change that ?
>
> r
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and sql
files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
is there any way to change that ?
re.
wh
--
MySQL General Mailing List
For list archives: http://list
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 2:07 PM
To: mysql@lists.mysql.com
Subject: Access Rights ?
Hi all,
I am newbie using MySQL. I want to log each client request to database
server. I thought when server checks access rights of user(client)
will be good place to "log"
be confidential, privileged or
>>> otherwise legally protected. It is intended only for the addressee. If you
>>> received this e-mail in error or from someone who was not authorized to
>>> send it to you, do not disseminate, copy or otherwise use this e-mail or
m someone who was not authorized to send
>> it to you, do not disseminate, copy or otherwise use this e-mail or its
>> attachments. Please notify the sender immediately by reply e-mail and
>> delete the e-mail from your system.
>>
>>
>> -Original Message
nd delete
> the e-mail from your system.
>
>
> -Original Message-
>
> From: Sachin Gaikwad [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 06, 2008 2:07 PM
> To: mysql@lists.mysql.com
> Subject: Access Rights ?
>
> Hi all,
>
> I am newbie using MySQL. I wan
PROTECTED]
Sent: Monday, October 06, 2008 2:07 PM
To: mysql@lists.mysql.com
Subject: Access Rights ?
Hi all,
I am newbie using MySQL. I want to log each client request to database
server. I thought when server checks access rights of user(client)
will be good place to "log" all "acc
request to database
server. I thought when server checks access rights of user(client)
will be good place to "log" all "access/read/update" requests.
If somebody knows where exactly this is done in source code, I will
get a real kick start. Right now I am browsing through the source
Hi all,
I am newbie using MySQL. I want to log each client request to database
server. I thought when server checks access rights of user(client)
will be good place to "log" all "access/read/update" requests.
If somebody knows where exactly this is done in source code, I
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/> mysqlaccess 192.168.0.1 myuser membres
Could not op
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/> mysqlaccess 192.168.0.1 myuser membres
Could not op
BAUMEISTER Alexandre writes:
> Sinisa,
>
> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
> |
> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO
BAUMEISTER Alexandre writes:
> Sinisa,
>
> >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
> >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
> |
> >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON cont
Sinisa,
>> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
>> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
>|
>> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%'
>
Sinisa,
>> mysql> show grants for news@'192.168.1.%';
>>
>++
>> | Grants for [EMAIL PROTECTED]%
> |
>>
>+---
BAUMEISTER Alexandre writes:
> Sinisa,
>
> mysql> show grants for news@'192.168.1.%';
>
>++
> | Grants for [EMAIL PROTECTED]%
>|
>
>+
Sinisa,
>> What's happening ?
SM> Your story is quite strange.
SM> Can you run SHOW GRANTS on both user@localhost and user@remoteIP and
SM> see what they are showing ??
I had to make my applications work, so I removed the lines in 'user'
and 'db' tables for the remote IP. This solved
BAUMEISTER Alexandre writes:
> Bonjour,
>
> What's happening ?
>
> Regards,
> Alex.
Your story is quite strange.
Can you run SHOW GRANTS on both user@localhost and user@remoteIP and
see what they are showing ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr
Bonjour,
I have a problem with Mysql-3.23.39 and users access rights. It's
the second time I notice this problem since I installed .39 on two
of my servers. But yesterday, the bug was even more flagrant.
I had a user which had all rights on a database when connecting
may need to double quote the % sign.
trav
On Thu, 5 Jul 2001, Chris M wrote:
> I've got a question.
>
> In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
> about how you can do this:
>
> GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt";
>
> So I tried some
At 9:20 PM -0600 7/5/01, Chris M wrote:
>I've got a question.
>
>In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
>about how you can do this:
>
>GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt";
>
>So I tried something similar:
>
>mysql> GRANT SELECT ON *.* TO m
I've got a question.
In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
about how you can do this:
GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt";
So I tried something similar:
mysql> GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY "dirt";
ERROR 1064: You have
trying to login in as needs a
password.
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Jerry Davis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 9:15 AM
To: MYSQL
Subject: Access rights
1) How do I give access to other users in MySQL?
2) How do I give access to tables
1) How do I give access to other users in MySQL?
2) How do I give access to tables to other users?
3) How do I create another database and then give access to that database to
other users?
I can get into the test database as user x
but I can't get even get an access error when trying mysql wit
ubject: Setting access rights
Hi everyone,
I have problem with Database inteded for setting access rights.
The problem is that IP addresses set in table 'db' dont affect access rights.
With no problem I accessed database from IP 147.229.177.57.
Dumping data for thi
Hi everyone,
I have problem with Database inteded for setting access rights.
The problem is that IP addresses set in table 'db' dont affect access rights.
With no problem I accessed database from IP 147.229.177.57.
Dumping data for this database are as follows:
# DATABASE mysql
#
32 matches
Mail list logo