From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Wed, 28 April, 2010 9:55:38 PM
Subject: Re: My sql Security
Rip out the DB authentication part, and store those credentials in-code, in
some config file or the registry, or some remote mechanism like LDAP.
If your
y login Authentication screen; I request you guide me how can
> handle this.
>
> Thank you
>
> Vikram
>
> --
> *From:* Johan De Meersman
>
> *To:* Vikram A
> *Cc:* MY SQL Mailing list
> *Sent:* Wed, 28 April, 2010 2:10:45 PM
>
>
from the other GUI/connecting tools though they have given a access to db?
Thank you for the information.
Vikram
From: nwood
To: Vikram A
Cc: MY SQL Mailing list
Sent: Wed, 28 April, 2010 3:39:23 PM
Subject: Re: My sql Security
On Wed, 2010-04-28 at 13:58
On Wed, 2010-04-28 at 13:58 +0530, Vikram A wrote:
> Hi all,
> I have some security issues. I would like to have your suggestions/solutions.
>
> I have winserver2003 with mysql 5.1.45. We have client serve application that
> allows multi-login system with various people.
>
> I am getting user na
I'm afraid you can't discern between clients and applications on the MySQL
level. Your application authentication should be separate from the MySQL
one.
On Wed, Apr 28, 2010 at 10:28 AM, Vikram A wrote:
> Hi all,
> I have some security issues. I would like to have your
> suggestions/solutions.
dows vista? As per your information, th
>> emysql has to be installed once again another port; Is it possible to
>> install 2 setups in a same system?
>>
>> Thank you
>>
>> VIKRAM A
>>
>>
>> --
>> *From:* Thiyagh
0:08 PM, Vikram A wrote:
> I tried to install once again mysql at vista? but deducts the previous
> installation. and it is ask for the modify , repire and remove options
>
> You said that we can install any number of setups in a same system.
>
> Is there any other way to install
From: Thiyaghu CK
To: Vikram A
Sent: Sat, 6 February, 2010 3:05:25 PM
Subject: Re: MY SQL Slave Server
Hi Vikram,
Ya sure, slave can be in vista. Yes, you can install 2 or more setups in same
system but port has to be different, and if its linux platform change the sock
name
Hi Vikram,
So as my understanding you need to have a master slave setup in a single
machine(FEDORA 11).
1. Make the already running mysql instance as Master
2. Install a new mysql in the same machine in different port which will be
your slave
3. Replicate
4.You can also add more slave in same mac
Hi Alexander,
How do you compare MaxDB features against other DB products, for
example SQLServer?
Regards
FBR
"Schroeder, Alexander" <[EMAIL PROTECTED]>
03/02/2004 09:38 a.m.
To
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc
Subject
RE: My SQL
More information please ... what Operating System, where are the MySQL
binaries and data directories on your machine, did you create a my.ini, is
MySQL installed as a service
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 14, 2003 1:51 P
> -Original Message-
> From: Nathan Simms [mailto:[EMAIL PROTECTED]
> The problem is that I need my statement to search the
> product_name and
> description fields as well. However when I add them to my
> statement, it
> doesn't work???
> The statment below does not work:
>
> SELE
I am searching for a specific company name that gets passed to this page. I
tried adding the mysql statement:
SELECT product_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND
description LIKE '%FORM.query%' AND
company_name L
On Fri, 22 Aug 2003 23:28:18 +
"Nathan Simms" <[EMAIL PROTECTED]> wrote:
> Hi, I'm currently using the following mysql statement to perform a search.
> Right now it is only returning the results which are found in the
> description field. How do I modify this statement so that it is searching
"skjois" <[EMAIL PROTECTED]> wrote:
> I get this error
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> how can i get rid of this?
Easily. Start MySQL and get rid of the message. :-)
--
For technical support contracts, goto https://order.mysql.
On Sunday, April 6, 2003, at 10:28 AM, B. van Ouwerkerk wrote:
You don't explain your problem.
First problem is that after doing a clean install of
mysql-standard-4.0.12 and following the instructions
cd /usr/local/mysql
sudo ./bin/mysqld_safe
(Enter your password)
(Press CTRL+Z)
bg
You don't explain your problem. You don't even tell which versions you're
running.
If there is no mysql table then you didn't create it, or you trashed it. In
the manual you will find references to how to install MySQL on MAC OS X.
http://www.mysql.com/doc/en/Mac_OS_X_installation.html
IMHO you
You can't. The only reason you can get MySQL for OSX is because of it's
Unix underpinnings which made it possible to port MySQL to OSX. MySQL
would have to be completely rewritten to run under OS9.
If you want to use MySQL on a Mac, you need to have at least one OSX
box. You could then design a
>From: Miki Tan <[EMAIL PROTECTED]>
>
>I am Miki Tan from Gleneagles Medical Centre.
>I am interested in MySQL database development.
>
>1.Can I know with platform is suit for MYSQL ?
It works very nicely with MacOS X. The only time it ever goes down is when I install
an update.
SQL SQL SQL
On Mon, 25 Nov 2002, Miki Tan wrote:
> Hello,
>
> I am Miki Tan from Gleneagles Medical Centre.
> I am interested in MySQL database development.
>
> 1.Can I know with platform is suit for MYSQL ?
Hi, and welcome to the wonderful world of open-source database development!
See this for platform no
Thank you for your report.
Yes, I know about this leak in Windows version. It is due to it's
stack limitations.
Current developrment branch has this leask fixed already ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
> to format my ti
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
> to format my ti
You need the mm.mysql driver, which can be downloaded from
http://sourceforge.net/projects/mmmysql/
Alec Cawley
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
sha writes:
> hello sir
What an odd way to address a crowd. :-o
> i have a problem that is when i installed mysql
in my system it's driver was not loaded in my system.
from where can i get this and how can i use it i m to
use it for jdbc and my operating system is windows 2
000 prof.
If w
Hi.
On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column
to obtain an key to O
On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
> Eg:
> Insertion order into a table for a text field:
> bbb
>
> abaa
> aa
>
> Retrieval order:
>
Hi.
There may be some internal order, but according to the SQL
specification, you may not rely on it. The order of records of a query
without ORDER BY is undefined on purpose.
Bye,
Benjamin.
On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> I wonder to know if
try some more then..
try // or / or .. .
> Hi,
> I donot even get that with an additional backslash
> also.In my case it just ignores the backslash and goes
> ahead with the search .
> Regards,
> Ravi
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
> Mon, Jun 18, 2001 at 04:32:5
Hi,
I get the following based on my requirement:
This time it returned an empty set.See the
last.Sometimes it is ignoring the backslash
altogeather.
I want to search a string like "ah\bl" in "blah\blah".
Regards,
Ravi
mysql> use dbhub;
Database changed
mysql> CREATE TABLE slash_test ( foo VARCH
Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> >
> > Even after
On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
>
> Even after escaping mysql just seems to be ignoring it.
Odd. I'm seeing something other than what I first expected. Watch
this...
---snip---
mysql> CREATE TABLE slash_test ( foo VARCHAR(30) );
Query OK, 0 rows
It is not working even after escaping it.I am working
on WINNT4.0 and mysql 3.23
--Regards,
Ravi
--- Scott Baker <[EMAIL PROTECTED]> wrote: > It
depends on what you mean by pattern search? You
> probably have to escape
> the "\" character. If you put a "\" in front of a
> character it means th
Hi,
Even after escaping mysql just seems to be ignoring
it.
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> > Hi,
> >
> > Did mysql pattern search support a backslash
> character?
>
> Yes.
>
> Sin
It depends on what you mean by pattern search? You probably have to escape
the "\" character. If you put a "\" in front of a character it means this
next character is what I say it is not it's MySQL representation. This
would allow you to put a ";" or ")" in your query. Simply put "\\" to m
On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
>
> Did mysql pattern search support a backslash character?
Yes.
Since it is a special character, make sure it is properly escaped.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
De
Hi,
THe maximum number of table joins I ned is not more
than three.Most of the search criteria is based on
Unique or Primary keys and hence I did not opt for
indexing.I am using the default myISAM table types of
mysql and mysql C_API.
Previously someone suggested using C_API functions
over joins w
At 3:13 PM +0100 5/30/01, VVM Ravikumar Sarma Chengalvala wrote:
>Hi,
>I wonder to know whether declaring a column as BINARY
>will take the characters like \,' etc into binary form
>and stores it in the database?
>
>Then we may not need to specify the escape sequences..
You need to properly esca
Hi!
Try this:
INSERT INTO my_table (myTimeField) VALUES (CURTIME())
[also see] http://www.mysql.com/doc/D/a/Date_and_time_functions.html
-Original Message-
From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]]
Sent: den 29 maj 2001 15:07
To: [EMAIL PROTECTED]
Subje
Field | Type | Null | Key | Default | Extra
---+--+--+-+-+---
hora | time | YES | | |
insert into hora values (curtime())
- Original Message -
From: "VVM Ravikumar Sarma Chengalvala" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
On Thu, May 24, 2001 at 04:07:48PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> I would like to have answers/confirmation regarding
> the following:
> i)
> Primary and Unique key fields are autoindexed by
> mysql.
Yes.
> ii)
> Indexing on a single or multiple fields will create a
> overhead
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> 1.
> How much memory does mysql allocate by default to a
> database?Any default table wise memory limitations as
> well?
Its doesn't allocated very much by default ( < 10M ? ),
and there is no per table memory allocation.
> 2.
> Is mysql's memor
> 2.
> The following is the extract from mysql documentation:
> "
> In MySQL Version 3.23.7 and above, you can insert rows
> into MyISAM tables at the same time other threads are
> reading from the table. Note that currently this only
> works if there are no holes after deleted rows in the
> table
Hi ,
Infact I tried it out that way.There is a problem with
my_sql_real_escape_string() .I.e at the time of
linking it is giving an Unresolved External Symbol for
this function.For rest of the API functions it's OK.
I checked up with the .def file in the includes
directory and found that this func
Hi,
Instead of working with the strmov function use pointers to work on it, like I had to
Ex:
char myQuery[1024]="";
CurrentAddress = myQuery;
CurrentAddress+= mysql_real_escape_string( &MysqlStruct,CurrentAddress, string,
strlen(string) );
Best of Luck,
S.K. Singh.
- Original M
At 5:49 PM +0100 5/10/01, VVM Ravikumar Sarma Chengalvala wrote:
>Can some one let me know all possible ways to provide
>escape characters in MYSQL inserts.
>
>I am using C API.
If you're asking how to escape special characters:
http://www.mysql.com/doc/m/y/mysql_escape_string.html
http://www.my
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> How can I have an UNIQUE key in MYSQL which
> differentiates between case sensitive strings.i.e If I
> want to store "XYZ","XYz" and "xyz"
> differently.Currently mySQl is not accepting this type
> of strings and treating them as the same.
>
> Reg
Try mysql_real_query(). This function takes three parameters, the first two
are the same as mysql_query(). The third is the length of the query string.
Regards.
Alec
At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote:
>Hi,
>I am having a peculiar problem with C_API.How to
>execute a quer
On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> I am having a peculiar problem with C_API.How to
> execute a query string with its length more than 255
> characters using mysql_query() function.My sql query
> is
> more than 255 characters long and is getti
51 matches
Mail list logo
