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 alternative
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
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
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
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
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 may
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 published
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
]
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.
Regards,
Hendro
-Original Message-
From: Leo [mailto:[EMAIL PROTECTED]
Sent: Tuesday
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: [EMAIL
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
--
MySQL
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
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
Subject:
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]
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 also
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 *only* see
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 databases and all tables,
allthough
I've only given them access to one.
How can I
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
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@%
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
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
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:
select,
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(),
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 activities
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've
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 table, but I
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
passwd prompt **
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
30 matches
Mail list logo