Hi Matthew,
On 16/07/2013 21:21, Matthew Ward wrote:
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The first time I run
- Original Message -
> From: "Singer Wang"
>
> 2) use a init-connect to log logins but that doesn't work for users
> with super privileges as Keith mentioned below (thanks Keith for actually
> trying to help!)
That is indeed quite the nifty trick. Thanks, Keith :-)
> 3) Write your own p
My bad actually, the MySQL Enterprise Audit is available in MySQL 5.5
S
On Fri, Oct 5, 2012 at 2:14 AM, Singer Wang wrote:
> Mellow greetings,
>
> Enhance your calm. Lets get our facts straight and not go off our
> rockers. MySQL 5.6 Enterprise edition will be able to do this natively (
> https
Mellow greetings,
Enhance your calm. Lets get our facts straight and not go off our
rockers. MySQL 5.6 Enterprise edition will be able to do this natively (
https://blogs.oracle.com/MySQL/entry/new_in_mysql_enterprise_edition), but
otherwise you cannot do it natively. This does not mean
its imposs
One small correction. Init-connect doesn't require a restart of MySQL. I
was thinking of init-file. So that's even better.
On Thursday, October 4, 2012, Keith Murphy wrote:
> My friend Dave Holoboff wrote this up some time ago:
>
>
> http://mysqlhints.blogspot.com/2011/01/how-to-log-user-conne
My friend Dave Holoboff wrote this up some time ago:
http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html
You know you people sound like children.
Really unprofessional.
Go ahead --- call me names. i left middle school almost 30 years ago. It
won't bother me.
Can w
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
>> Sent: Thursday, October 04, 2012 3:51 PM
>> To: Reindl Harald
>> Cc: mysql@lists.mysql.com
>> Subject: Re: user last activity and log in
>>
>> Hi,
>>
>> 2012/10/4 Reindl Harald
>>
>>
Nanni [mailto:claudio.na...@gmail.com]
> Sent: Thursday, October 04, 2012 3:51 PM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: user last activity and log in
>
> Hi,
>
> 2012/10/4 Reindl Harald
>
> >
> >
> > Am 04.10.2012 17:28, schrieb Aastha:
&
Hi,
2012/10/4 Reindl Harald
>
>
> Am 04.10.2012 17:28, schrieb Aastha:
> > I want to find the last time the given list of users logged in.
> > Is there any mysql table from where i can retrieve the data or any
> > specific sql
>
> no - because this would mean a WRITE QUERY in the mysql-database
Am 04.10.2012 23:12, schrieb Johan De Meersman:
> - Original Message -
>> From: "Reindl Harald" rei...@thelounge.net>
>>
>> it does not matter what kind of users
>
> I'm happy for you that you still have all the answers anyone could ever want,
> Harald.
not all but the one to the topic
- Original Message -
> From: "Reindl Harald" rei...@thelounge.net>
>
> it does not matter what kind of users
I'm happy for you that you still have all the answers anyone could ever want,
Harald. Regardless of having any background knowledge on the circumstance of
the question, even. You
it does not matter what kind of users
usually each application has it's own datanase and it's
own user, the application makes the connection and
can at this point log whatever you want
using the "general query log" can only be a bad joke
you will log EVERY query and not only logins
again: it is
Yes, i meant DB users.
On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman wrote:
>
> - Original Message -
> > From: "Reindl Harald"
> >
> > this makes pretty no sense and is NOT the job of a RDBMS
> > implement it in your application / db-abstraction-layer
>
> I notice no specification o
- Original Message -
> From: "Reindl Harald"
>
> this makes pretty no sense and is NOT the job of a RDBMS
> implement it in your application / db-abstraction-layer
I notice no specification of what kind of users, so I'm assuming DB users.
There *is* such a thing: you can find it in the
It is possible in MySQL 5.6
S
On Thu, Oct 4, 2012 at 11:30 AM, List Man wrote:
> There is no such thing. Your application has to deal with such info.
>
> LS
>
>
> On Oct 4, 2012, at 11:28 AM, Aastha wrote:
>
> > Hello,
> >
> > I want to find the last time the given list of users logged in.
>
Am 04.10.2012 17:28, schrieb Aastha:
> I want to find the last time the given list of users logged in.
> Is there any mysql table from where i can retrieve the data or any
> specific sql
no - because this would mean a WRITE QUERY in the mysql-database
for every connection - having a web-applicat
There is no such thing. Your application has to deal with such info.
LS
On Oct 4, 2012, at 11:28 AM, Aastha wrote:
> Hello,
>
> I want to find the last time the given list of users logged in.
> Is there any mysql table from where i can retrieve the data or anyt
> specific sql
>
>
> Aastha G
friends, i figure that i had to give password in quotes. i was then able to
login. thank you all for your help and time.
From: Rajeev Prasad
To: Rick James ; mysql list
Sent: Monday, September 24, 2012 4:11 PM
Subject: Re: user not able to login from
sql>
I am looging in from the same server.
From: Rick James
To: Rajeev Prasad ; mysql list
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost
That says that your password in not correct. You have not go
ase`.* TO
'myuser'@'localhost' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
From: Ben Mildren
To: Rajeev Prasad
Cc: mysql list
Sent: Monday, Sep
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localhost IDENTFIED BY '.
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad wrote:
> i have given select/insert/update/delete rights to a user on a specific
> database, from localhost. when i try to login to mysql using the uid, i get
> error:
>
>
>
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?
If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';
> -Original Me
Hi Aastha,
I think that you can develop a Plugin to do it.
Recently, I post a plugin that allow authenticate users through LDAP Server
(
http://nafiux.com/blog/2012/08/16/mysql-ldap-authentication-plugin-clear-password-client-plugin/
).
More info about MySQL Authentication Plugins:
http://dev.my
Thank you Dan. Great find !! That was the answer. group_concat was
truncating my results and it caused my prepared sql to error out. I change
the server variable dynamically whenever the 1260 warning is issued to
accommodate larger and larger strings for the group by operation and it
works well.
Th
In the last episode (Oct 16), Kailash R said:
> Nice input Dan. Let me run some checks. My query is as follows:
>
> select group_concat(Field1), field2, field3 from table1 group by field2,
> field3 into str;
> @sql = concat("select blah ... where field1 in ' ,str);
> prepare stmt from @sql;
> exe
Nice input Dan. Let me run some checks. My query is as follows:
select group_concat(Field1), field2, field3 from table1 group by field2,
field3 into str;
@sql = concat("select blah ... where field1 in ' ,str);
prepare stmt from @sql;
execute stmt;
deallocate prepare stmt;
So when the count(*) for
In the last episode (Oct 15), Kailash R said:
> I was wondering if there is a way to increase the size of user defined
> variables ? I am not able to attribute a type to them and when I assign
> @sql = 'a_text _field' , 'a_text_field' gets truncated if it exceeds the
> size of @sql. This is not w
Darn, oh well.
Thanks for the quick response.
--- On Tue, 7/28/09, Gavin Towey wrote:
From: Gavin Towey
Subject: RE: User Defined Types
To: "delux256-my...@yahoo.com" ,
"mysql@lists.mysql.com"
Date: Tuesday, July 28, 2009, 2:39 PM
Nope
-Original Message-
F
Nope
-Original Message-
From: Jeff Lanzarotta [mailto:delux256-my...@yahoo.com]
Sent: Tuesday, July 28, 2009 11:37 AM
To: mysql@lists.mysql.com
Subject: User Defined Types
Hello,
I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.
This may have been discussed before but I
It didn't occured unless you manually changed your user's privilege.
On Wed, Oct 22, 2008 at 11:05 PM, kalin m <[EMAIL PROTECTED]> wrote:
>
> hi all...
>
> i had a weired thing happened
>
> is it possible for a user privileges to expire?!
>
> suddenly today an application stopped working and
Hi Saravanan,
Thanks, once I added this to the my.cnf in the mysqld section it worked!
Regards,
Mark
saravanan-5 wrote:
>
> Use my.cnf to point the data directory and the user details.
>
> [mysqld]
> user=mysql50
> datadir=/home/mysql50
>
>
> Saravanan
>
>
> --- On Mon, 4/28/08, M
Use my.cnf to point the data directory and the user details.
[mysqld]
user=mysql50
datadir=/home/mysql50
Saravanan
--- On Mon, 4/28/08, Mark-E <[EMAIL PROTECTED]> wrote:
> From: Mark-E <[EMAIL PROTECTED]>
> Subject: User Issue
> To: mysql@lists.mysql.com
> Date: Monday, April 28, 2008, 12:05
The primary key sounds like the right one. You don't need an
additional one for userid alone, as the primary key will serve to
accelerate those queries as well.
- michael dykman
On Sun, Mar 2, 2008 at 9:30 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> Whoops, finished my thought too early. I was
Whoops, finished my thought too early. I was going to append, should
we also have UserId, PreferenceId be the PRIMARY KEY? Then possibly a
secondary index on UserId in case I ever want to get all preferences
for a user?
On Sun, Mar 2, 2008 at 6:18 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> But i
But if you're using a varchar for the purposes of getting a list, you
might as well store it in a more compact format like int or SET. The
only benefit (which shouldn't be ignored) is that you have a
human-readable string to parse, right?
It seems like most people ended up with a normalized forma
I think that I'd set up a varchar column and store a tab separated
list in it.
Then parse it upon retrieval.
Curtis
Dan Buettner wrote:
> Waynn, I've used
both schemes 1 and 2 as you describe, and in my
> experience
> 2 is the best way to go. It's easy to scale up as you add users
and
>
1. Blobs suck. I suggest a serialized array or JSON instead of a BLOB.
2. I have used this before and would love to know what the design
pattern is called. This patterns works well, though I would not be
surprised to see it called an anti-pattern. Adding fields make the
normalized table grow very q
Waynn, I've used both schemes 1 and 2 as you describe, and in my experience
2 is the best way to go. It's easy to scale up as you add users and
settings, and it's easy to make changes if the meaning of settings should
change (i.e. you need to do a backend change to people's settings).
#1 is harde
solidzh wrote:
2007/8/21, Jay Pipes <[EMAIL PROTECTED]>:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT
2007/8/21, Jay Pipes <[EMAIL PROTECTED]>:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everytime a new DB is added. Is there a way to do this?
>
> GRANT S
Grant the necessary privileges to each database individually and leave out
> 'mysql'.
>
> Unfortunately, you cannot grant privileges to all databases and revoke
> privileges from one schema ('mysql' in this instance)
> You must enumerate the databases you specifica
a ('mysql' in this instance)
You must enumerate the databases you specifically want to grant the user
privileges to.
GUARD THE mysql SCHEMA WITH YOUR LIFE, PLEASE
- Original Message -
From: "Jay Pipes" <[EMAIL PROTECTED]>
To: "Terry" <[EMAIL PROT
ave out
'mysql'.
Unfortunately, you cannot grant privileges to all databases and revoke
privileges from one schema ('mysql' in this instance)
You must enumerate the databases you specifically want to grant the user
privileges to.
GUARD THE mysql SCHEMA WITH YOUR LIFE, PLEASE
Yep.
Terry wrote:
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions every
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everyti
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname'
IDE
How were you manipulating the permissions?
I find that the stock query works fine:
GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'%' ;
GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'localhost';
although you may want to play around with allowable networks to connect from.
More typic
Hi Scott,
Scott Haneda wrote:
Is it possible to use user variables in an update statement, I can find only
scant docs on it, but they do not pertain to what I am trying to do.
Given this select:
SELECT user_id, order_status, quantity_chosen, month_price, each_price,
sales_tax, sales_tax_rate,
I think it was Baron's toolkit I was thinking of...
the command mysql-show-grants seems to do the trick.
Thanks,
Keith
- Original Message -
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, June 27, 2007 4:11:54 PM (GMT-0500) America/New_York
Subject: u
Richard Cooper a écrit :
> Hi,
>
> I have a MySql database running on version 5.0.27 which every few days
> for no reason I can fathom stops letting me log in.
>
> mysql -u username dbname -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'username'@'localhost'
> (usi
>
> database test itself has Grants that it shows itself to everyone.
>
How should I verify that?
Thanks,
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bing Du schrieb:
Hello,
I don't understand why user 'test1user' can see database 'test' as well.
I think user 'test1user' should only be able to see database 'test1'.
What did I do wrong here? I'd appreciate any help. Thanks.
As root:
mysql> show databases;
+---+
| Database
Why not also put a wildcard for 192.168.% ? That's what we've done.
-Sheeri
On 2/17/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
> >>> did u start mysql with --skip-name-resolve ???
> >>> Kishore Jalleda
>
> Kim Christensen wrote:
> > On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
> >> Nope.
>
>>> did u start mysql with --skip-name-resolve ???
>>> Kishore Jalleda
Kim Christensen wrote:
> On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
>> Nope.
>
> Well, have you tried it? Did it solve your problem?
Sorry, I misunderstood. I thought Kishore was saying that if I had
starte
On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
> Nope.
Well, have you tried it? Did it solve your problem?
--
Kim Christensen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
> Nope.
Well, have you tried it? Did it solve your problem?
--
Kim Christensen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nope.
_
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:32 PM
To: Ryan Stille
Cc: mysql@lists.mysql.com
Subject: Re: User is rejected because of IP, but hostname is
allowed
did u start
did u start mysql with --skip-name-resolve ???
Kishore Jalleda
On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote:
>
> I am trying to connect to my MySQL 4.x server from a new machine. I am
> getting this error:
>
> Got error: 1045: Access denied for user 'user'@'192.168.2.56' (using
> password:
OK, I spoke a little too soon. Users can no longer list all
databases, which is great. Unfortunately, they also can't list their
own, resulting in errors when they log into phpMyAdmin:
SQL-query: SHOW DATABASES ;
MySQL said: #1045 - Access denied for user:
'[EMAIL PROTECTED]' (Using passwor
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again!
-Bill
On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote:
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid here, bu
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid here, but I'm
having trouble figuring it out. I had a disk go bad on a MySQL server
this past weekend. I did a clean system install (FreeBSD 5.4) on a new
disk, installed the MySQL 3.23 port, and restored the my
Hello.
Use mysqlmanager. MySQL Instance Manager is included in MySQL
distributions from version 5.0.3, and can be used in place of the
mysqld_safe script to start and stop the MySQL Server, even from a
remote host. See:
http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html
mel
mel list_php wrote:
Hi,
This may be a strange question, but I was wondering if it is possible
to have a user starting/stopping the mysql server who wouldn't have
access to the data.
To explain: I want to set up a server as user "Groupinstaller" for
example. This is a virtual user to allow ot
Colin Shreffler wrote:
After installing MySQL on OS X, there don't appear to be any user accounts
created by default.
Does anyone know what user account to use or if there is a convention that I
should use when creating an Admin account?
Cheers
-c
After installation, you need to run mysql_ins
Miguel Cardenas wrote:
Hello list
I have a doubt... Do I need to set a password to a user for each host the user
has permission to connect from?
To mysql, a user is '[EMAIL PROTECTED]'. That is, [EMAIL PROTECTED] and [EMAIL PROTECTED] are
two different users from mysql's point of view. You
If some users can add data, then I think that is problem that the clients,
you should check headers response in your php.ini, the flag charset-type
should have a value that your clients support. I've had that king of
problems, when I use header() function in php.
:: ISC Edwin Cruz Garcia ::
IT Fac
Hello.
If you want to have a complete understanding of how MySQL access
privilege system works, read this chapter of the manual:
http://dev.mysql.com/doc/mysql/en/privilege-system.html
James <[EMAIL PROTECTED]> wrote:
> I had set up the following
>
> I have a MYSQL server running
James wrote:
I had set up the following
I have a MYSQL server running on let's say 123.xx.xx.xx
User: user1
Host: 111.xx.xx.xx
and gave that user the appropriate priveleges.
How exactly? Did you use GRANT? Something like
GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY 'user1_pa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leigh wrote:
> Gleb Paharenko wrote:
>
>> Hello.
>>
>> There was a question about exceptions recently. The answer might be
>> helpful:
>> http://lists.mysql.com/mysql/188048
>>
>>
>>
>> Leigh <[EMAIL PROTECTED]> wrote:
>>
>>> Hi All,
>>>
>>> I'm cur
Hello.
For a pity I'm not a JDBC expert.
>
> Hi,
>
> Thanks for that bit of info. This may be a stupid question, but how
> exactly does setting the variable @err help me with my current
> situation? Will this allow me to generate a JDBC Exception or is it
> something I'll need
Gleb Paharenko wrote:
Hello.
There was a question about exceptions recently. The answer might be
helpful:
http://lists.mysql.com/mysql/188048
Leigh <[EMAIL PROTECTED]> wrote:
Hi All,
I'm currently working on porting a database form Informix 9.2 to MySQL 5
in order to determine the suitab
Hello.
There was a question about exceptions recently. The answer might be
helpful:
http://lists.mysql.com/mysql/188048
Leigh <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I'm currently working on porting a database form Informix 9.2 to MySQL 5
> in order to determine the suitability
Aiby <[EMAIL PROTECTED]> wrote on 07/18/2005 11:15:26 AM:
> Does it posible to set a user previlage to table wise!! Rather then a
Whole
> Database.
>
> --
> Aiby
Yes! You can even determine permissions for specific columns, if you
really want to.
Details here: http://dev.mysql.com/doc/mysql
so contunue here http://dev.mysql.com/doc/mysql/en/news-5-0-x.html
mathias
Selon almo geeth <[EMAIL PROTECTED]>:
> hai .
>
> send me the details of database server feature comparison between 4.0
> and 5.0 beta version .if we upgrade our server form 4.0 to 5.0 or 4.1 what
> are all the chang
"Alan Scott" <[EMAIL PROTECTED]> wrote on 05/20/2005 03:47:55 PM:
> MySQL Server v4.1.x
>
>
>
> Is there a table in any instance of mysql that I write some queries and
> insert/update statement against for moving databases between systems?
>
>
>
> Any assistance would be appreciated.
>
You
"Ed Reed" <[EMAIL PROTECTED]> wrote on 04/25/2005 02:33:23 AM:
> Does anyone else have any ideas about this topic?
>
> Thanks
>
> >>>Ed Reed <[EMAIL PROTECTED]> 04/23/05 1:29 pm >>>
> Thanks for the reply,
>
> I realize that user variables disappear when the connection closes
> but I don't un
Does anyone else have any ideas about this topic?
Thanks
>>>Ed Reed <[EMAIL PROTECTED]> 04/23/05 1:29 pm >>>
Thanks for the reply,
I realize that user variables disappear when the connection closes but I don't
understand why what I'm trying to accomplish can't be done. Doesn't it make
since
Thanks for the reply,
I realize that user variables disappear when the connection closes but I don't
understand why what I'm trying to accomplish can't be done. Doesn't it make
since that if you can load a single file with multiple SQL commands and have
that work succesfully then you should be
At 22:04 -0700 4/22/05, Ed Reed wrote:
Thanks for the reply,
So is there anyway to use User Variables with a single connection.
All my apps are in VB6 and VBA. They all take a query, open a
connection, run query, fill array from query results, close
connection and pass back the array. Because of
Ed Reed wrote:
Thanks for the reply,
So is there anyway to use User Variables with a single connection. All my apps
are in VB6 and VBA. They all take a query, open a connection, run query, fill
array from query results, close connection and pass back the array. Because of
backward compatibility
Thanks for the reply,
So is there anyway to use User Variables with a single connection. All my apps
are in VB6 and VBA. They all take a query, open a connection, run query, fill
array from query results, close connection and pass back the array. Because of
backward compatibility there's no way
Ed Reed wrote:
If I run the following in MySQLFront v3.1
Set @A='Test';
Select @A;
I get back same result
+--+
| @A |
+--+
| Test |
+--+
If I run the same query in MySQL Query Browser v1.1.6 I get this,
ErrNo 1060, You have an error in your SQL syntax; check the manual that
correspo
Hello.
Analyzing the General Query Log could give such kind of information.
See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Dilshad Ali <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there a way to determine when was the last time a MySQL user
> attempted to connect to the MySQL D
Hello.
GRANT OPTION for adding user, and UPDATE on the mysql database to set
the passwords for them.
See:
http://dev.mysql.com/doc/mysql/en/grant.html
http://dev.mysql.com/doc/mysql/en/set-password.html
"Peter PeterDresden" <[EMAIL PROTECTED]> wrote:
> ...to that user, that he
Hi,
after granting privileges did you executed flush privileges command. if not
execute below command and then check
mysql> flush privileges;
thanks
Anil
-Original Message-
From: sam [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 9:09 AM
To: mysql@lists.mysql.com
Subject: U
That syntax only works in 4.1.2 and up, however. Prior versions only take a
string for the user, not a function call or variable. In that case, you can
find out who you are with
SELECT CURRENT_USER();
+-+
| CURRENT_USER() |
+-+
| [EMAIL PROTECTED] |
Hello.
SHOW GRANTS FOR CURRENT_USER();
Law Poop <[EMAIL PROTECTED]> wrote:
> Can a user see their own permissions for a database?
>
> I'm working on a PHP project that will hopefully automagically
> generate forms based on a user's permissions. Do I have to create a
> seperate account
Hi,
Set the value as
SET @SoftwareID:=7;
Now, use
WHERE
s.softwareID = @SoftwareID at the end of your query.
Thanks,
Narasimha
-Original Message-
From: Erich Beyrent [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 8:30 PM
To: [EMAIL PROTECTED]
S
[snip]
This does not work. It appears that the user variable is not picked up
in
the WHERE clause - the query works fine if I have:
[/snip]
You have a fundamental lack of understanding of user variables. A quick
read of http://dev.mysql.com/doc/mysql/en/Variables.html will reveal
"User variables
Howe
Cc: [EMAIL PROTECTED]
Subject: Re: user defined table constraint
You need to use a UNIQUE index:
ALTER TABLE ADD UNIQUE user_id_primary (user_id, is_primary);
I can't find a specific section about UNIQUE indexes in the mysql
docs, but I'm sure it's there and I'm pret
[EMAIL PROTECTED] wrote:
Hi,
How to call a user defined function. I am using C as the programming language. I write a small function in C. Created .dll. Then how to run it from mysql pompt?. How to call or use it?. will any one of you help me in this.
Thanks,
Narasimha
I don't clearly
Excuse me for top-posting but Outlook Express won't put revision bars in
front of your original remarks and I'm too lazy to type them all in myself
;-)
Anyway, if you define one of your columns, such as user_id as a primary key,
you can be sure that there will never be two rows with the same user_
That depends, can the user have more than 2 records? as in only 1 "yes"
record and 1 "no" record? If that were the case you could create a unique
index on (user_id, is_primary). However, I suspect that is not the case.
If I remember my M$ $QL correctly, User Constraints are evaluated during
INS
At 4:01 +0200 10/8/04, Przemyslaw Popielarski wrote:
Paul DuBois <[EMAIL PROTECTED]> wrote:
SELECT
@a:=FIRMLEGALZIPCODE
FROM tCustomers
WHERE @a REGEXP "[0-9]"
-> Empty set (0.03 sec)
You're expecting the value to be selected first so that you then can
test it with the WHERE clause later.
Paul DuBois <[EMAIL PROTECTED]> wrote:
>> SELECT
>>@a:=FIRMLEGALZIPCODE
>> FROM tCustomers
>> WHERE @a REGEXP "[0-9]"
>> -> Empty set (0.03 sec)
>
> You're expecting the value to be selected first so that you then can
> test it with the WHERE clause later.
Of course you're right. Thanks. Accor
At 3:47 +0200 10/8/04, Przemyslaw Popielarski wrote:
Paul DuBois <[EMAIL PROTECTED]> wrote:
User variables do not work with REGEXP under MySQL 4.0.21 & 4.1.5.
Is this a bug or a feature?
It's difficult to provide an answer to this because you're providing
no information about what "do not work"
Paul DuBois <[EMAIL PROTECTED]> wrote:
>> User variables do not work with REGEXP under MySQL 4.0.21 & 4.1.5.
>> Is this a bug or a feature?
>
> It's difficult to provide an answer to this because you're providing
> no information about what "do not work" means. Can you be more
> specific?
Sure.
At 3:12 +0200 10/8/04, Przemyslaw Popielarski wrote:
User variables do not work with REGEXP under MySQL 4.0.21 & 4.1.5.
Is this a bug or a feature?
It's difficult to provide an answer to this because you're providing
no information about what "do not work" means. Can you be more specific?
mysql> s
Brandon,
You'll have to create a user for the PHP script.
example:
In the above code you'll have to create a user for the
PHP script (mysql_user and msyql_password) and make
sure that it has the proper permissions. At minimum I
would think SELECT, INSERT, UPDATE and DELETE, for
that user with
1 - 100 of 198 matches
Mail list logo
