From: Mitchell Wright [EMAIL PROTECTED]
Is phpmyadmin secure?
I believe in the default install, it sends cleartext passwords. I use it on a trusted
LAN only, so I don't care, but you should probably buttress it's login with a
.htaccess and password.
--
SQL SQL SQL SQL SQL SQL SQL SQL
Hi,
I came across a strange problem in MySQL. Some of the tables are getting
corrupted. The most common error messages which I encountered are : Can't
open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table
handler.
I rectified it by shutting down the MySQL Server and using
I looked in mysql.h and saw
#ifdef USE_OLD_FUNCTIONS
..
mysql_connect(..)
etc.
#endif
, shouldn't it work then - even if they are
deprecated? Well, I'll try with mysql_real_connect.
Thanks.
/nikolajg
--- Ed Carp [EMAIL PROTECTED] wrote:
Iv'e been using gcc 2.96-10 to compile a database
On Thu, Oct 17, 2002 at 08:50:43PM +0200, Corin Langosch wrote:
the table has about 12.000 rows total but the query should return
a max of about 100. mysql should split the query into two queries
and merge the results.
may be this could be done by joining the same table two times
and query
In my mysql.db file, I have some lines like:
%.private | somedb | someuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y
So, I have an internal domain called private, those hosts are in an
internal DNS, and can be reverse resolved. The only way I can manage to
connect to somedb as someuser is to
In the last episode (Oct 25), Jeff Mathis said:
I'll agree to this somewhat:
(1) always bind your variables. whatever code you are using to do your
inserts, the fewer prepared statements you can make the better.
for example:
insert into TableName (col1, col2, col2, col4) values (?,?,?,?)
Description:
Under some pretty specific conditions, adding a LIMIT clause to a query
will cause incorrect results.
How-To-Repeat:
This bug is NOT present in 4.0.3.
CREATE TABLE `history` (
`id_pic` int(11) unsigned NOT NULL auto_increment,
`id_cam` smallint(11) unsigned NOT NULL default
sql,query
At 15:50 -0600 10/25/02, Jeff Mathis wrote:
Paul DuBois wrote:
(2) drop all indexes on your table(s). rebuild them after loading (this
alone can give orders of magnitude improvement)
For ISAM or MyISAM, that works. It has no effect for InnoDB.
Do you actually observe a
At 21:03 -0700 10/25/02, Andre Kirchner wrote:
Hi there,
I would like to know, if it's possible in the mysql to
use two tables as if they were one and have an index
that would use columns of these two tables?
Possibly. Read about MERGE tables in the MySQL manual and see
if the constraints
Hi,
Can anyoe suggest tutorial which is simple to understand
programming in c or c++ for odbc connections with mysql?
Bye.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi, I've got a client that I'm trying to convince to store the file path in
the database rather than the file itself into the database. Is there any
statistical data to show how much of a hit you take doing it as a BLOB vs. a
filepath?
sql,query
Last try, if this doesn't go through, screw it.
On Sun, 2002-10-27 at 21:31, [EMAIL PROTECTED] wrote:
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
one of the following words in your message:
Can someone please tell me what is wrong with this function? I can't for
the life of me see an error. But, for some reason I keep getting the
following error:
PARSE ERROR: parse error, unexpected $ in
d:\web.root\xx_db\inc\functions1.inc on line 28
function is:
function dtb_qry_tbl_dsp($qry,
corrupted. The most common error messages which I encountered are : Can't
open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table
handler.
I rectified it by shutting down the MySQL Server and using myisamchk
with the options -r and sometimes -o.
145 = Table was marked as
Another issue that is easy to overlook is your indexing. If you have a lot of
indexing and keep increasing the database, expect to see a significant
slowdown during inserts into a well populated db, compared to an empty one.
Since you were trying on local machine first, and networked later, it
Try again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com]
Sent: Sunday, October 27, 2002 9:17 PM
To: John Meyer
Subject: Re: RE: plz help...tables getting corrupted...
Your message cannot be posted because it appears to be either spam or
simply off topic to
Hi
If this is the full code you are missing the final } to close the function
I find it helps to comment the closing brackets
HTH
Peter
function dtb_qry_tbl_dsp($qry, $qry1, $qry2)
{
$result = mysql_query($qry);
$result1 = mysql_query($qry1);
$result2 = mysql_query($qry2);
$i = 0;
Apologies in advance: I have not been able to find any sort of overview
information on how MySQL operates internally. I am trying to understand
the philosophy behind the table handler mechanism, and what state is
managed above and below that interface.
I am slowly making my way through the
I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM
files. Everything installed just fine and dandy except when I try to
run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how to
protect that file, but where does it come from?
Is there a way to take a mysql database and import it into access
retaining all the rules and relationships setup within the mysql
databse?
---
Aaron Axelsen
AIM: AAAK2
Email: [EMAIL PROTECTED]
URL: www.amadmax.com
It said, Insert disk #3, but only two will fit!
One picture is worth 128K words.
Pada Mon, 28 Oct 2002 00:12:14 -0500
Dennis Herndon [EMAIL PROTECTED] menulis:
I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM
files. Everything installed just fine and dandy except when I try to
run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how to
How to stop the mySQL service instead of right click the traffic light and
stop it ?
is there any exe can stop the mySQL service ?
i tried the mySQLShutDown.exe, but it didn't actually stop the service.
i want to stop the mySQL service so that the mysqld-nt.exe wouldn't hold my
database,
which
mysqladmin shutdown
On Mon, 28 Oct 2002, Alice Tan wrote:
How to stop the mySQL service instead of right click the traffic light and
stop it ?
is there any exe can stop the mySQL service ?
i tried the mySQLShutDown.exe, but it didn't actually stop the service.
i want to stop the mySQL
Try a touch /var/lib/mysql/mysql.sock
Although it is a special file it may just work this way. Also make
the permissions to chmod 777 mysql.sock and chown mysql.mysql
mysql.sock
Bye.
On Mon, 28 Oct 2002, Dennis Herndon wrote:
I just upgraded to Linux-Mandrake 9.0 and installed mysql
On Thu, Oct 24, 2002 at 12:14:44PM +0530, Akash wrote:
Hi,
I have prepared a RING Architecture in MySQL using three MySQL servers.
I name these MySQL servers as A, B and C.
My configuration is like this :
A is the Master to B, B is the Master to C, and C is the Master to A.
Hi all
How do I access a remote MySQL server (on LINUX platform), from a windows
application.
What drivers I need to download and from where?
How do I set permissions on the mysql server to let be accessed by the
remote windows machine.
Thanks alot
Aman
On Mon, 28 Oct 2002, aman mysql wrote:
Hi all
How do I access a remote MySQL server (on LINUX platform), from a windows
application.
What drivers I need to download and from where?
Hi!
You don't need any special drivers. Just the MySQL command-line client will
do the job. It can be
run in the DOS, i got this error ..
am i doing wrongly ?
C:\mysql\binmysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
- Original Message -
From: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
On Mon, 28 Oct 2002, Alice Tan wrote:
run in the DOS, i got this error ..
am i doing wrongly ?
C:\mysql\binmysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
Hi,
mysqladmin -u root -p shutdown
And
29 matches
Mail list logo