Hi,
Could someone give me some advice on the best way to store sensitive
information like credit card numbers on our mySQL database. Of course we
would be using SSL encryption for all transactions.
Thanks
Neil
_
Stay in touch with
Has anyone successfully installed "mysql-max-4.0.12" on OS X?
I've been trying for three days to set the root password and nothing I
try seems to work. I'm a total unix newbie but I did go out and buy a
Unix book and think I have enough of a feel for it to follow printed
directions. It seems to
Paul DuBois wrote:
At 16:23 -0500 4/4/03, <[EMAIL PROTECTED]> wrote:
Now when i put data into the table i can't have all blanks which is
right. When i put data into the field that allows nulls the not null
one gets '' as its data and goes on. I though NULL and '' were the
same thing. Am i n
Try the following
cd /usr/local/mysql
./bin/mysqld_safe
and see if that starts up the server.
If it doesn't, check to make sure you don't have a proxy set in your
internet configurations.
Todd
On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote:
I have installed mysql on Mac OS X.
Hi,
I am trying to select unique raws from my table, but I
can not find a correct SELECT syntax. My table has 6
columns: ID,first,last,address,ZIP,born. I can have
multiple same names in last column and first, but
there is a unique ID. I can have same addresses for
different last names.
I need to s
I'm using placeholders like this: (using Perl)
$stmt .= "," if $stmt;
$stmt .= $f->{t_name} . " = ?";
my $temp_value_holder = $f->{value};
$temp_value_holder =~ s/\,/\;/g;
push (@placeholder, $temp_value_holder);
The reason I'm using a temp value then switching the commas with ; is
On 05-Apr-2003 Chris Fowler wrote:
> Hello All,
>
> I'm trying to determine some marketing statistics using 3 tables
> (sales_opp_source, sales_opp, contract). I want to show ALL of the
> sales_opp_source records and show how many accepted contracts there
> have been for each of those sales_op
Hello,
I have a problem. I have two tables one with the
long sentences(TABLE 1) and one with the words in that
sentences(TABLE 2).
what i need to do is query the TABLE 2 by giving a
part of the word ---WILD CARD MATCHING-and get the
complete words which contains this part.
Then Use thi
At 12:00 -0500 4/5/03, Peter Gumbrell wrote:
I have installed mysql on Mac OS X. when I attempt to access it
either through a php page or through Terminal, I receive this
message;
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
mysqld isn't running.
You can check to see if
On 05-Apr-2003 Justin French wrote:
> Hi all,
>
> I'm currently logging page requests with the following table:
>
> CREATE TABLE counters_hits (
> pid tinyint(3) unsigned NOT NULL default '0',
> stamp varchar(30) NOT NULL default ''
> ) TYPE=MyISAM;
>
> In other words, for ever page hit on
I have installed mysql on Mac OS X. when I attempt to access it either
through a php page or through Terminal, I receive this message;
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
I have just switched to a Mac and am unfamiliar with many aspects of
unix. I read something
It should be enough to place the .jar file in the jre/lib/ext folder
(Binside your Java installation folder. If you don't want to do that, you
(Bcould modify your CLASSPATH environment variable to include wherever
(Byou decide to place the .jar.
(B
(BTodd
(B
(BOn Saturday, April 5, 2003,
In your "user" table in the mysql database, remove all the lines that allow
logins from other hosts.
mysql> use mysql
mysql> delete from user where host <> "localhost;
mysql> flush privileges;
-ms
-Original Message-
From: Mel [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 05, 2003 9:3
I'm running MySQL 4.0.12-standard on Mac OS X (10.2.4), for local use
only. As no-one else needs access to the database, I'm trying to make
it as secure as possible... so far I've added skip-name-resolve,
skip-networking and safe-user-create into my.cnf. I've also seen
bind-ip=127.0.0.1 mention
At 16:23 -0500 4/4/03, <[EMAIL PROTECTED]> wrote:
Hi everyone,
When creating a table I have a autonumber primary key, a
varchar(30) field that is not null and another field that not null
is not selected. Here is the table creation command i used.
CREATE TABLE `TableName` (`ID` INT (3) UNSI
Hi everyone,
When creating a table I have a autonumber primary key, a varchar(30) field that
is not null and another field that not null is not selected. Here is the table
creation command i used.
CREATE TABLE `TableName` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
`name`
Hsu
Where did you acquire mysql-connector-java-3.0.6-stable.zip ?
Martin
- Original Message -
From: "®}¸S¬F" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 05, 2003 7:05 AM
Subject: About JDBC
Sorry~
I have a problem about JDBC now, I use mySQL as my database an
Hello All,
I'm trying to determine some marketing statistics using 3 tables
(sales_opp_source, sales_opp, contract). I want to show ALL of the
sales_opp_source records and show how many accepted contracts there
have been for each of those sales_opp_source's (including the ones that
would be 0)
Sorry~
I have a problem about JDBC now, I use mySQL as my database and tomcat as my
server I downloaded the JDBC driver (mysql-connector-java-3.0.6-stable.zip) and
unziped it, but now I don't how to use it? How to let my jsp pages connect to my
database Would u tell me how to do??
On 04-Apr-2003 [EMAIL PROTECTED] wrote:
> Hi there,
>
> I have some experience with SQL, but I'm drawing a blank on this one. I
> have a table with these fields:
>
> Location
> Unit
> StartDate
> StopDate
>
> I want to construct a SELECT statement to get to a report that looks
> something like
MySQLCC crashed with me on redhat 7.3... Always at the same time. When I
choose a data type for my first column in my first new table.
Brian McCain wrote:
MySQLCC is pretty popular, and it's probably the easiest to set up.
http://www.mysql.com/products/mysqlcc/index.html
I like MySQLTool though.
21 matches
Mail list logo
