Hello,
My System is Linux Red Hat 6.2 and my MySQL is 3.23.41 ( *.tar.gz ,
sources package )...
So, can you help me to set the security of the Database System ?
The following compile and installation steps :
./configure \
--with-charset=big5
--with-extra-charsets=complex
make
make install
So,
Chapter 4 in the manual is a good place to start!
http://www.mysql.com/doc/M/y/MySQL_Database_Administration.html
-Ursprungligt meddelande-
Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Skickat: den 21 november 2001 09:55
Till: [EMAIL PROTECTED]
Amne: Security of MySQL
Hello,
My
after editing the tables below , i'm still not able to access the
Bisimis Database below
with the user behrens, just getting the errormessage below.
I've tried it with any combination of user/db/host but can't see the
supposed logic error i've made,i'm stuck,anyone there to help me?
thanks
Hi there.
I'm getting stuck on what seems only too simple to me:
CREATE TABLE Waverley.MemberPrice
(
PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
Price FLOAT(5,2) NOT NULL,
ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1,
CreatedDate DATE NOT NULL DEFAULT NOW(),
Jim Lucas wrote:
just wondering, when you start the database replicating, the bin files start
counting
at .000
host-bin.001
host-bin.002
host-bin.003
...
host-bin.999
what happens when you reach .999?
does it start over at .001 and over-write you initial files, or does it
Hi.
I'm ought to install QNX on my workstation.
I know that there are binaries and compilable
sources available.
But what about MySQL and PHP? An alternative
for MySQL would be pgSQL (bin and src available
too), but PHP seems to be lost in the world
of realtime operating systems for good.
Can
No, that is not legal. From the manual:
Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as
NOW() or CURRENT_DATE.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
-Ursprungligt meddelande-
Hi!
Ken == Ken Kinder [EMAIL PROTECTED] writes:
cut
Ken I would like to know if anyone has some advice on encrypting credit cards
Ken myself, as it's something I'm going to be needing to look into for my own
Ken purposes.
We are working on a solution to this which will be available in
Hi.
How do I get the query execution time from Perl/DBD? MySQL client returns
this in the console window. Is this value available through the Perl DBD
interface?
Thanks.
Gordan
-
Before posting, please check:
Hi,
Has anybody had experience of trying to synchronise an access 2000 db with a
mysql db? If so could you enlighten me as to where I can get further
information/drivers to enable me to do this.
TIA
Regards
Dean
-
Before
Description:
I have a table 'spoken_text' with a field 'start_time'.
When I do an INSERT (from within 'mysql') with a
fractional part in the seconds field, SOMETIMES
this inserted values is corrupted.
How-To-Repeat:
tpdmmr% mysql -u vip -p vip
The obvious way to do this would be to get the time before and after the
execution and then make a simple diff (after - before) I guess that is how
the mysql client does it (butI'm not sure)
I do not think that mysql itself provides this information..
how to get the time in Perl/DBD I do not
Hi!
I forwarded the email to Monty if he has time to look at index usage.
The speedup .43 - .44 may be due to better optimization of SQL queries, or
due to the table dumps and imports you made.
The way to defragment InnoDB tables, or tables in any database, is from time
to time to dump and
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote:
The obvious way to do this would be to get the time before and after the
execution and then make a simple diff (after - before) I guess that is how
the mysql client does it (butI'm not sure)
I do not think that mysql itself provides
Hi All,
I'm considering making a huge table, by that I mean approx. 26 millions
records which will be static data, no updates, or deletes, etc. will be
performed on this table, only select statements.
The schema on the table will be as follows.. The address fields will be 56
characters long and
Right, It seems to be good to be tried but your server is down I thing.
--
Cyrille Bollu - Software Development Engineer
AWTCE - Navigation Department
Tel. +32 2 389 25 14
Fax. +32 2 389 12 13
mailto:[EMAIL PROTECTED]
I haven't read through any of the MySQL
Hello,
I'm always with my access to mysql port.
I noticve that access can dispaly a â but it s like a a.
So I make this query to select some specials row from my database :
select ort from localite_ortsnamen
where ort REGEXP
^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$=0;
Hi!
On Nov 20, Karl J. Stubsjoen wrote:
Hello,
I am trying to perform the following delete command:
delete from my_table where match(keywords,title,description)
against('this_word')
When I perform a similar select and count with the above query, I come up
with 47 records found.
On Wed, 21 Nov 2001, Pafo wrote:
i still cant get pass this problem, i have now uninstalled PWS and still i cant
access
why why why why? http://www.pafo.net/mysql4.gif
i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal
firewall and
i am connected thru a
On Wednesday 21 November 2001 03:01, James O'Brien wrote:
I have been trying to perform a join with several tables and I am having no
joy.
error messages would increase the understanding of exactly what joy
you aren't having ;-)
Can some one send me a query (just a select * is fine) for
On Wednesday 21 November 2001 10:10, behrens wrote:
after editing the tables below , i'm still not able to access the
Bisimis Database below
with the user behrens, just getting the errormessage below.
I've tried it with any combination of user/db/host but can't see the
supposed logic error
Use myODBC to use an ODBC connection. If you are using a hosting
provider on a Unix box, more than likely this will not work
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: dean browett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Hi,
A v. basic question from a mySql newbie:
I want to update a table based on the contents of another table. The SQL I
am trying to execute is:
update servers set servers.responsecount=servers.responsecount+1 where
servers.gameid = lastsnapshot.gameid;
ie: Increment a responsecount for rows
Hi!
Sandeep == Sandeep Murthy [EMAIL PROTECTED] writes:
Sandeep Have been spammed too by NuSphere earlier on.. so junked my earlier mail id
Sandeep and switched to the present one...
Sandeep let all the subscribers carry a vote to hv this spammer banned from this
Sandeep list...
Sandeep
Hi dear mysql-users,
Just to inform you that this solution still works (today the 21th november
2001).
Just note that the address has changed to http://216.184.67.245/libz.a
Regards,
Cyrille
mailto:[EMAIL PROTECTED]
Hello, I'm always with my access to mysql port.
I noticve that access can dispaly a â but it s like a a.
So I make this query to select some specials row from my database :
select ort from localite_ortsnamen
where ort REGEXP
^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$=0;
I'd
Ian Barwick wrote:
Have you flushed the privileges after changing the tables?
FLUSH PRIVILEGES
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
yes i did countless times, i'm
On Wed, 21 Nov 2001, Pafo wrote:
am still getting the same message http://www.pafo.net/mysql5.gif
Try without the password. As below, mysql -u root.
On Wed, 21 Nov 2001, Pafo wrote:
i still cant get pass this problem, i have now uninstalled PWS and still i cant
access
why why
It seems at least one of your username and/or password is not as you
might think. You should find the my.ini file, which is either should be in
C:\Windows for M$ Windows'98, and change your username-password info. After
relaoding mysql, it should function.
Regards ? ferhat ?
Just recently started seriously studying the infernal trio of Apache,
MySQL PHP and got off to a decent start, but for reasons unknown can no
longer get MySQL to start up from the DOS prompt.
I keep getting a Can't initialize InnoDB as innodb_data_file_path is not
set message when I enter
behrens wrote:
Ian Barwick wrote:
Have you flushed the privileges after changing the tables?
FLUSH PRIVILEGES
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
Wooohooo! that is the first bug i ever found!
Do I get any points : )
Karl
www.excelbus.com
..opportunity knocking..
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 6:33 AM
To: Karl J. Stubsjoen
Cc: MySql list
Subject: Re:
I've now had an extended dig around this mailing list's archive, and it I
conclude mySql can not perform this type of update directly. Instead I
should create a temp table, select into the temp table and then use that to
do a REPLACE INTO command.
Can someone confirm my conclusion is correct?
I have downloaded MySql binary for Solaris 2.8 (PC) 3.23.39 from your
web. After I installed, I found out that the file 'mysql_install_db'
under scripts directory doesn't contain anything. The size of this file
is zero. So basically, I couldn't initialize the user table in mysql
database and get
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
The way to defragment InnoDB tables, or tables in any database, is from time
to time to dump and reimport them. That can give a significant performance
boost.
That is actually not entirely true. For MyISAM tables, one simply needs
to run
Wait for 4.1, it will have multi-table updates in it. Until then,
you'll have to use two separate queries.
Steve
On Wed, 2001-11-21 at 07:28, Charles Allen wrote:
Hi,
A v. basic question from a mySql newbie:
I want to update a table based on the contents of another table. The SQL I
am
All,
I'm having the same problem as Jose.
SCO 5.0.5, gcc 2.95.3, Pthreads 3.5 (skunkware's).
Perl was compiled using gcc. Msql-Mysql-modules-1.2219 is
what I'm trying to install, but can't.
Make finds my libgcc.a, and
Hi!
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
The way to defragment InnoDB tables, or tables in any database, is from time
to time to dump and reimport them. That can give a significant performance
boost.
That is actually not entirely true. For MyISAM tables, one simply needs
to
Hi!
If I have a process inserting into an innodb table in 200 insert chunks.
i.e. it commits after every 200 inserts, must another process, which wants
to delete data from this table, wait for the next commit on the insert end?
If not is there any reason why my process is doing this.
Do you
when you run mysqld, use:
/path/to/one/mysqld --bind-address=10.0.0.10
/path/to/two/mysqld --bind-address=10.0.0.11
Guillaume Monfort wrote:
Hello there,
i would run two distinct mysql servers on the same
computer. i know it's possible using 2 differents ports
but it's not what i want.
Thanks for taking the time to clarify the situation. It appears that
my response did not however convince the judge or jury on this manner
and I've been bannished from the list.
Rather interesting development.
Britt...
-Original Message-
From: Michael A. Peters [mailto:[EMAIL
Hi there
I need help :-)) If anybody could be so kind and help me...
I have 3 tables:
OldMembers
Memebers
Data
In Data there is a field Member_ID. Now in this field all members bigger than
100.000 are old ones and must be taken from the OldMembers table (both tables
are not using same data so
-- Forwarded message --
Date: 21 Nov 2001 18:17:22 -
To: Boyd Lynn Gerber [EMAIL PROTECTED]
Subject: Re: Re: Can't Compile DBD::mysql
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
Hello!
How do I get the size of a blob?
I want to do something like this:
SELECT * FROM blob_table WHERE size(blob_column) 1024;
Best regards
Sven
--
---
ANDURAS AG - solutions for the NET
OldMembers
Memebers
Data
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very
Description:
/usr/local/mysql/bin
# cd ..
# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very fast joins.
Hm, thank you for
Hi Group,
I am using a database and want to index it for better
performance. The datatypes for the coloums i am
indexing(multicolumn indexing) are:
varchar and timestamp
I came to know that changing the datatype from varchar to
char effects the performane a lot. I would like to know,
has any
Hello all,
I have a question that might be better suited to the PHP community, but
I thought that it was also relevant to the MySQL community (and I'm
already on this mailing list!! :-)
I am compiling PHP 4.0.6 as a dynamic module (apxs) for Apache 1.3.22
on my Darwin 1.4.1 system (Mac OS X
If I use a FLUSH TABLES command, what will happen to others that might be in
the middle of using a table?
I have a PHP application running on PHP 4.0.3 that doesn't seem to close
tables properly, and I am constantly having trouble with the mySQL server
crashing on me.
I shut down the server,
I am passing an SQL statement through to Mysql, in certain circumstances
(not very often), the information within the statement is the same as what
is in the database, therefore 0 records are affected. This is great from a
speed perspective, but I want to know that 0 records were affected
I'm new to the list, and I cannot find out whether this question has been
asked before (I'm sure it is)
I have a table called 'paragraph' and one called images:
paragraph: id ; text ; author ;
images: url; subscript;
I want my PHP to insert a IMG tag in a specified place in the text
Towards the end of running the end of the configure script (./configure
--prefix=/usr/local/mysql - and yes I know I can optimise better than
this), I get:
creating ./config.status
creating Makefile
sed: file conftest.s1 line 6: Unterminated `s' command
creating os/Makefile
sed: file
Hello all,
I have just notice that the new Mysql3.23.44.rpm is different.
I download the rpm installed it
(rpm -ivh Mysql )
installed fine, started the mysql deamon but when i tried to set a
passwd for root i could not find mysqladmin
it tells me that its located
Hi!
On Nov 21, Mike Hunt wrote:
All we want is for something like
SELECT * FROM book WHERE MATCH(author) AGAINST
('stephen') AND MATCH(author) AGAINST ('king') LIMIT
100 /* these queries are ALWAYS limited like this */,
a pretty normal kind of query, to return in an
acceptable fast
I am going to have a table called mail_queue, that is going to store the
member id, the mailing id, and the date. Each time a new mailing is setup
(usually daily), another 100,000 rows (one for each member) will be added to
the table.
When a member reads the mailing, that row will be removed
Thanks for the reply.
Jim
- Original Message -
From: Rafal Jank [EMAIL PROTECTED]
To: Jim Lucas [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:25 AM
Subject: Re: Database Replication problem
Jim Lucas wrote:
just wondering, when you start the database
Why does the MacOS X build of MySQL 3.23 include a manual.html that contains install
instructions for only Linux and Windows? I'm stuck trying to figure out how to
install this thing. MacOS has no groupadd command (due to the existence of the
NetInfo system), so the manual install
I have been trying to load the textual contents of a file from my hard drive
space into a field (Description) of my mySQL table (Software) using the
follwing query. The query runs succfessfully, however, none of the contents
are loaded into the field, in fact, the Description field is not
i'm using mysql 3.23.43 on Windows 98 platform
running on apache server 1.3.22 with php4
Sometimes (most often) this pc crashes (windows miracles) and if i was using
mysql, i mean if i was logged in and moving data from my webpage, or if the
winmysqladmin.exe was running, then after reboot, the
I have been trying to load the textual contents of a file from my
hard drive
space into a field (Description) of my mySQL table (Software) using the
follwing query. The query runs succfessfully
How do you know that it's successful? What success/error codes
(if any) are returned?
cut
Does anyone know whether mysql supports parallel processing? I searched the
documentation on mysql.com, but didn't find it mentioned
thanks
AOD
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
UPDATE Software SET Description =
LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
WHERE ID = 9
You have to make sure that not only can mysql read the file, but it also has
permissions to the directories that the files are in. Typically your home
directory on your
Hello. I am running a MySQL server (3.23.43) on WinME, and another
server (same version) on libc6 Linux. The server on WinME is a
development server, or rather has been until now, and the Linux one is
my production server. At this time the Linux one is completely empty
with the exception of the
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book [EMAIL PROTECTED] wrote:
UPDATE Software SET Description =
LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
WHERE ID = 9
You have to make sure that not only can mysql read the file, but it also has
permissions to
Hi.
I had the same problem awhile back.
What i did was just copy the db files to the linux server
provided the mysql versions are exactly the same and
the db structures are the same it works.
Otherwise mysqldump and read it into the new db:)
//Uffe
Witness wrote:
Hello. I am running a
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
I have been trying to load the textual contents of a file from my
hard drive
RH7.2
When I run 1.7.5 either static or semi static, I get
Can't connect to local MySQL server through socket (111)
Host name is localhost (120.0.0.1 doesn't work either).
I do have access rights - running as root.
--
Glenn English
[EMAIL PROTECTED]
Thank you all for your suggestions. I used the /tmp directory on my ISP
which has permissions to all and it work.
Thanks,
Sharaaz
- Original Message -
From: Sharaaz Khan [EMAIL PROTECTED]
To: Carsten H. Pedersen [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001
Monty, is this like a product you're selling? I would like more information,
although I haven't gotten to this yet in my security sweep.
On Wednesday 21 November 2001 06:27 am, Michael Widenius wrote:
Hi!
Ken == Ken Kinder [EMAIL PROTECTED] writes:
cut
Ken I would like to know if anyone
I tried following the directions that came with the book mysql/php database
applications. I am told that after installing mysql, one checks to make sure
the installation was correct by invoking the mysql daemon
(c:\mysql\binmysqld). That did nothing there is a piucture in the book that
shows
I hope I'm not being really stupid, but this does not seem to work:
mysql -h localhost -u xxx -p
I get the command line usage error. It appears I can't use any other option
if I use the -h. This works fine
mysql -u xxx -p
I'm running mysql version 3.23.43-nt
Glenn
Hi,
From previous message (I don't run linux), I believe that linux ps lists all
threads, and mysqld does create a thread for each connection.
Regards
Quentin
-Original Message-
From: Bennett Haselton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 22 November 2001 4:15 p.m.
To: [EMAIL
Do you mean processes instead of threads?
(ps lists each *process* separately, along with its process ID, but doesn't
list separate threads within each process. If mysqld handles each new
connection by calling fork(), then I think fork() creates a new process,
not a new thread.)
I've set up replication with a master and two slaves, all running
3.23.43, and it works like a charm. Except for...
When the master goes down, the slave tries to reconnect after 60
seconds, but just once.
That shouldn't be.
I have the same problem here with the same version!
I
Dear All
You all are working on Database for Long time. In your opinion Which one is
best 1. MySql or 2. Oracle
Mamun
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi
it is possible
select * from table where col1 = now and col2=now
where col1 and col2 are date type
thnaks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear All
Any one have example Banking software written in PERL or PHP with MySql
Database. if you have one mail me or provide me the URL of such software.
Thanking you
Mamun Murtaza Sheriff
SDNP Bangladesh
-
Before
(PHP-DB folks, ignore this top question - unless you want to answer)
Which type of DB/Table provides table locking while a process is
altering data? I don't care for locking while using SELECTs, but I do
need locking when something's being INSERTed or UPDATEd, so I won't get
two
79 matches
Mail list logo