> I got a request from a client for the rights to kill his queries if
> something goes wrong. Long story short, he doesn't want to have to phone.
>
> I see via the MySQL documentation, that the client would need PROCESS and
> SUPER privileges. Im not happy with that.
>
> Would know of an alternat
you can use GRANT statement to create and grant privs for a mysql db so users
can access specific host DB servers @'server.domain' specific DB on specific Db
Servers 'custom'@'server.domain'specific tables on specific DB customer.*
specific privs
(Select_priv,Insert_priv,Update_priv,Delete_priv
Thanks everyone for the replies. The problem revolved around '%' vs
'localhost'. To me, it seems logical that '%' would include localhost..not
really true. So, I have it figured out.
thanks,
Keith
- Original Message -
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
To: "mysql"
Sent:
Keith,
Is it possible you have a second entry for [EMAIL PROTECTED] which
doesn't require a password?
- michael dykman
On 9/26/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Everyone,
>
> So I have never seen this before. I set up a database yesterday. I added a
> user today in the normal m
Just to make things REALLY messy... try setting the default character
set of a 4.1 server to utf8, and then importing your data from 4.0...
your mysql usernames are in real trouble now, because utf8 considers
itself to be multi byte and takes more space, cutting down on the 16
characters by
On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote:
> Is there any reason why I shouldn't increase the size of the allowable
> user names in mysql to var(32) instead of the default var(16) ???
>
> Couldn't really find much on it, but wanted to ask if anyone knows of
> any troubles this m
On Wed, Apr 28, 2004 at 02:51:50PM -0400, Mihail Manolov wrote:
> Does anybody knows if User Conference' presentations were published
> somewhere on the web? I was told that it will be done shortly after
> the conference, and it is more than a week after the conference
> end...
They will be publis
TECTED]>
To: "'Leo'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 4:17 PM
Subject: RE: MySQL user in Indonesia
> I am working to port our database to mysql now. I work in PT. ADETEX.
> Sorry for my english.
>
> Re
I am working to port our database to mysql now. I work in PT. ADETEX.
Sorry for my english.
Regards,
Hendro
-Original Message-
From: Leo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 1:25 PM
To: [EMAIL PROTECTED]
Subject: MySQL user in Indonesia
Hi All,
im sorry if this m
My company use it :)
PT. Tempo Inti Media Tbk
For experience sharing, contact me in private.
I believe there're alot of company here using MySQL.
Just take a look around.
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Leo" <[EMAIL PROTECTED]>
To: <
Greetings every body
I'm developing a web application using JSP ,Mysql and jrun application
server.i need the code of user authentication in jsp.Can any one supply the
same Your help would be appreciated
Regards
Aby
Technical Services
Abhinav Chaturvedi
TransAction Solutions Pty Ltd
PO
SELECT user
FROM mysql.user;
- Original Message -
From: "Binay" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 3:25 PM
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
--
MySQ
Binay wrote:
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
use mysql;
select User from user;
Ivan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Binay,
Use the mysql client to open the "mysql" database. For example, enter the
following at the "mysql>" prompt:
use mysql
Then type:
select * from user;
Bob
-Original Message-
From: Binay [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 12:26 AM
To: mysql users
Subje
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
>
> I *had* the anonymous user, but I deleted it since I couldn't find the use
> for it. But I figured out what the problem was. I was
> using --safe-show-database, but it didn't seem to work.
>
> My error was that I gave users privileges. I
m: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 2:32 PM
Subject: Re: MySQL user privileges
> "H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
> >
> > All my MySQL users have access to all databa
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
>
> All my MySQL users have access to all databases and all tables, allthough
> I've only given them access to one.
>
> How can I correct this?
Do you have entry for anonymous user in the table 'user'?
>
> Is it possible to have them *onl
On Thursday 12 December 2002 10:03, Ryan McDougall wrote:
> Alright I have tried to do the grant like the following:
>
> GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
> ON "user%".* TO user@% IDENTIFIED BY "password";
>
> GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
> ON user%.* TO user@
Alright I have tried to do the grant like the following:
GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
ON "user%".* TO user@% IDENTIFIED BY "password";
GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
ON user%.* TO user@% IDENTIFIED BY "password";
With no luck I keep getting an error me
At 9:25 -0800 12/8/02, Ryan McDougall wrote:
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creati
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creative as he wants... allow him to create
ANY data
Dear Ryan,
have a look at the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
With the exception of Paul's book on MySQL, you probably won't find a better
explanation of the MySQL privilege system.
> PLEASE I'M GOING
At 21:39 -0800 12/7/02, Ryan McDougall wrote:
Hey everyone,
Ok if I issue this command:
mysql> grant select,insert,update,delete,create,drop
-> on *.* to someusr@"%" identified by 'passwrd';
I already know that this statement creates the user someusr w/
password=passwrd
and it can connect from
>I Have a question relating to setting up users for our customers on a shared
>server environment. I can not find this answer in the documentation so I am
>trying here.
>
>Is it standard practice to give the user of the database (site owner) one
>set of permissions which I figure should be:
>
>se
sajiddalvi,
Sunday, July 07, 2002, 8:04:02 PM, you wrote:
s> Is there a way to check which my sql user (who has logged into the database)
s> has inserted a row in a table?
s> I could add a "logged_in_user" column but that seems redundant.
Take a look at functions: USER(), SYSTEM_USER(), SESSION_
Pada Sun, 7 Jul 2002 13:04:02 -0400
"sajiddalvi" <[EMAIL PROTECTED]> menulis :
> Is there a way to check which my sql user (who has logged into the database)
> has inserted a row in a table?
> I could add a "logged_in_user" column but that seems redundant.
you can set your mysqld to log all acti
Hi.
On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote:
> From: Ari Kahn <[EMAIL PROTECTED]>
>
>
> > However, whatever method I try mysql tell me that the user table
> > is read only.
>
> It sounds to me like "root" doesn't have sufficient permissions
> granted to write to that
From: Ari Kahn <[EMAIL PROTECTED]>
> However, whatever method I try mysql tell me that the user table
> is read only.
It sounds to me like "root" doesn't have sufficient permissions granted to write to
that table, but I could be wrong. There's something in the docs about accessing after
you'v
anyone know howto get mysql to allow multiple connections to a user? i'm trying to get
a db working also using php4 but when someone is searching the db someone else can't
query it. (it's http://virtuozo.hn.org/wp/ )
Kind Regards
kris Amy
The default is that you are logged as your unix uid. If you want to log
into mysql, you need to specify that on the command line.
-Original Message-
From: M Srinivas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 1:54 AM
To: [EMAIL PROTECTED]
Subject: MySql User ID
Hi,
>The username used if not specified in the mysql command, is your *nix
>username, so for instance, if I'm logged in as benji and type:
>
>mysql -p
> **
>
>The mysql username is also benji.
I would NOT consider it a good idea to use the same username for a shell
account and a mysql account..
can't you just try logging in using different logins?
why not login as "root", and make a new account?
if you can access the mysql database, look at the user table ... ?
siggy
- Original Message -
From: "Tim Thorburn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2
On Tue, Apr 10, 2001 at 02:32:30AM -0500, Tim Thorburn wrote:
> Hello,
>
> After playing around for a few days in between real work, I got my new
> linux box up and running with RedHat 7.0 and MySQL 3.23.33 (the version the
> hosting company we use supports). My problem is that I know what pas
Tim,
The username used if not specified in the mysql command, is your *nix
username, so for instance, if I'm logged in as benji and type:
mysql -p
**
The mysql username is also benji.
HTH
Ben
- Original Message -
From: "Tim Thorburn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
34 matches
Mail list logo
