perror will tell you
Error code 69: Srmount error
This looks pretty much like a system error to me. Ask your ISP.
[EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48:
Hello,
I seem to have corrupted mySQL deep down inside. I can not create any tables in any
new
I know this isn't a PHP mailing list, but maybe someone out there can help.
This is my first mysql/php project, and I can't seem to get this call to
mysql to work. I have other queries working, but it seems as though any
time I try to make a call to one of my auto_increment IDs, either PHP
Hi,
I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql server
as root and trying to use a sample database from Paul Dubois book MySql, I ' ve got
the error 13, can't create directory/file ./samp_db/president.xxx.
The thing is I'm using an example DB, any help ?
Hi,
I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.I want to use
connection pooling in my application.Kindly advice connection pooling package which is
suitable for the above application.
Thanking You,
Gaurav Tuli
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 13:09
Subject: php call to mysql
Modify your code as given below and see. It should work.
DT
I know this isn't a PHP mailing list, but maybe someone out there can
help.
This is my
Try going to www.freshmeat.net and searching for PoolMan. It's a Java
library for pooling connections to MySQL. I haven't messed around with
it but I saw it when trying to learn Java.
Hope this helps,
Jamie
-Original Message-
From: gaurav [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Hello,
I have this error (2008 : MySQL client run out of memory) performing
a request in a PHP script.
However that request works perfectly under phpMyAdmin !
I tried to do a lot of mysql_free_result() in my script (because there are a
lot of requests) but I doesn't work and I think It is
Is there ne way of populating the mysql db with the data from the sql server db with
out doing exports like a copy or something?
Hi Michael,
Michael Widenius wrote:
Between the different configure attemtns, did you do 'rm config.cache'?
If not, then there is a big change that the old content of
config.cache from the first build could have affected the later
builds.
I got an email from Timothy Smith yesterday
Halo,
I'm trying to install MySQL on a RedHat 7.0 (RPM). When I run
mysql_install_db, I get the message that the grant tables has been created.
I can fint it in /var/lib/mysql. Then when I run safe_mysqld --user=mysql
I get a error Can't find file 'host.frm' but the are in this path.
If I can
If it is a memory problem, try for example
ini_set(memory_limit, 16M);
in your script. Otherwise, it may be a loop that keeps allocating
memory until it crahes. It this is the case, you won't get it
through allocating more memory.
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42:
Hi,
I'm a bit stuck at the moment with a select query. I have 2 tables a
contact table and an events table. They are joined together by contact
id.
The data is stored in the events table like this:
eventid link id contact id
1 1 1 *
- Original Message -
From: shiuwaitai [EMAIL PROTECTED]
To: SDiZ Cheng [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 1:08 PM
Subject: RE:Re: Localization..
Hi,
try to use varchar or varchar binary instead.
they work fine in my application for searching
Then It is not a memory problem for ini_set() didn't work.
It always crashes at the same point.
Mysql doc says :
ERROR 2008: MySQL client ran out of memory
note that the error refers to the MySQL client mysql. The reason for this
error is simply that the client does not have enough memory to
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 14:20:04:
Then It is not a memory problem for ini_set() didn't work.
It always crashes at the same point.
Mysql doc says :
ERROR 2008: MySQL client ran out of memory
note that the error refers to the MySQL client mysql. The reason for
Hello,
I tried with unbuffered queries and It doesn't solve the problem at all
I have an weird error performing select id from categories where name =
'Hifi'.
The error is now : '0 : ' (nothing).
There's an error but it is not defined ?!?
Note that only the crashing query is
No. The data has to be moved from MSSQL to MySQL some way, and that will be
either an export or a copy. AFAIK, there is no way for the two RDBMS's to
communicate directly with each other ... you need some sort of intermediary.
And before any data can be moved, the table schema must be created on
Harro Verkouter writes:
Hi Michael,
Ok. So I gave it another try. I untarred the source distro into a new
directory and ran the configure command above (only different prefix).
Made absolutely no difference whatsoever: still a gazillion+-1 errors
:). Below I have a snapshot of the kind of
As far as I know, there'll be no other solution than recovering from
backup.
For the old data, that is quite alright -- what I'm trying to figure out now
is how to selectively restore information out of my (very large) binary
database transaction log file. (Anyone have tools to this effect???)
Jeff Tanner writes:
I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL
server for Sun Solaris i386?
Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386?
Thanks
Jeff Tanner
Viathan
Seattle, WA
Hi!
Either build it from source or download
What you are trying to perform is doable with InnoDB table handler.
Unlike BDB, InnoDB has multi-versioning and consistent reads.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime
Looks to me like a permissions problem. If you were manipulating the
MYSQL files as root or if you copied or moved them, this could happen.
Look at the permissions on a working machine and match those on this
machine. The permissions need to allow changes, but too permissive
permissions will
1. Please explain the above in detail.
It depends on the type of table you're using. If you're using a table type
that only supports table-level locking, then each transaction is isolated by
being suspended until the previous transaction is done. This is slower
if you do a lot of longer
I would like to dump all sql transactions from a binary transaction log
for a specific table after a specific timestamp. I can run mysqlbinlog
and delete all the queries up to the point of the correct timestamp, then
try to filter out the lines for other databases and tables, but a more
From: Joel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 3:01 AM
Subject: Date calculations with php and mysql
How do I find the elapsed time on a timestamp field?
SELECT NOW() - field AS elapsed FROM table?
Alex
--
Alex Page, IT Department, Solid State Logic
The small problem in mysql is it does not check if parameter is
correct in configure script - this produced the problem...
Peter mailto:[EMAIL PROTECTED]
Yes, I don't know of any clear way of handling this with
autoconf. Basically, if your option starts with
I have been told it is possible to embed MySQL in an application such that
the user never knows a database is running underneath the app. Where can I
find more information about doing this?
--
Shawn P. Garbett [EMAIL PROTECTED]
See http://www.garbett.org/public-key for my PGP key
Description:
I'm new to MySQL, and am porting an application from msql. Apologies
in advance for blatant ignorance on my part.
Apparantly the code that increments the counter on whether
a table has been modified is broken. myisamchk reports that:
Hello
Is there a way to encrypt database data and to let only one user decrypt
when server and client runs on the same machine? I am aware of the fact
that this is not fool proof scecurity as the decryption happens in the
memory and not hard to steal..but i guess its for a short time and would
You could be more specific:
Try specifying your programming language and operating system at least.
- Original Message -
From: Shawn P. Garbett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 2:43 PM
Subject: Embedding MySQL in an application
I have been told
Hi,
Thanks for the feedback on my earlier problem. I have come up with a
query:
SELECT *, count(contact_id) AS theCount
FROM eventlog
LEFT JOIN contacts ON contacts._id = eventlog.contact_id
WHERE TYPE = 'CLICK' AND link_id IN (1,2)
GROUP BY contact_id
HAVING theCount = 2
Thing is it takes
Documentation for any programming language that supports / has an interface
to / uses MySQL.
Try PHP (www.php.net), Perl (http://www-cgi.cs.cmu.edu/cgi-bin/perl-man), or
one of the many others.
Regards,
Sebastiaan J.A. Kamp
- Original Message -
From: Shawn P. Garbett [EMAIL PROTECTED]
I have been told it is possible to embed MySQL in an application such that
the user never knows a database is running underneath the app. Where can I
find more information about doing this?
That's simple - as you write the application, keep the user interface and
database totally seperate.
perl script
At 08:50 AM 8/9/01 -0400, Michael T. Babcock wrote:
I would like to dump all sql transactions from a binary transaction log
for a specific table after a specific timestamp. I can run mysqlbinlog
and delete all the queries up to the point of the correct timestamp, then
try to filter
Hello,
I have a mysql db that contains a table to track visitors, Visitor
information is stored at the beginning of each page. The problem that I am
having is that a few days ago the pages just stopped loading and I had to
dump, drop and recreate the table with nothing in it to get the site
From: sachin shetty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 2:56 PM
Subject: Encrypt Database data
Is there a way to encrypt database data and to let only one user decrypt
when server and client runs on the same machine? I am aware of the fact
that this is
Dear Jean-Luc,
check this part of the manual:
http://www.mysql.com/doc/m/y/mysql_install_db.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382
Dear Shawn,
try PHP (www.php.net).
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Shawn
Dear Carl,
What I want to-do is create a select statement that lets me select all
the contacts from the contacts table that have followed link 1 and
link
2. I'm finding this hard without subselects.
Maybe I miss out on something, but I would do it like this:
SELECT * FROM contact INNER JOIN
From: Shawn P. Garbett [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 3:07 PM
Subject: Fwd: Re: Embedding MySQL in an application
The real point is, that a user can take the product out of shrink rap,
install it, run the program and never fiddle one iota with installation of
MySQL or even
Is there a way to put the results of a SELECT into a table without going
through an export file? For example, something like
SELECT * FROM table_1 WHERE condition INTO table_2
Eldon Ziegler
ProAtion Systems
[EMAIL PROTECTED]
http://www.proation.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Freakin' Spam filter!!!
- -- Forwarded Message --
Subject: Re: Fwd: Re: Embedding MySQL in an application
Date: 9 Aug 2001 14:07:44 -
From: [EMAIL PROTECTED]
To: Shawn P. Garbett [EMAIL PROTECTED]
Your message cannot be
Normally the size can be 2G, 4G or more...
You can check the maximum table size for a table with the myisamchk -dv
table_name or table_file if It doesn't work.
You should have run myisamchk or mysqlcheck (whick worked better for me)
to check your table.
Le jeu, 09 aoû 2001, vous avez écrit :
I have 3 tables that have all fieds the same (name, length, indexes...)
The only difference is that data is stored by year(1999 in table1999, 2000 in
table2000, 2001 in table2001)
I don't want to merge them because each contains about 15,000,000 records and the
index would'nt fit into
I've been reapplying transactions to my aforementioned screwed up database.
It seems however, that the binary transaction log doesn't quite work
properly
with user variables (with MySQL 3.23.38). I have this entry from the log:
insert into Projects (ParentID, Name, LongDesc) values (@customer,
I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris
(Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine.
Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not
compatible for Sun Solaris (x86)?
Mr. Smith, after building on a Sun Solaris x86 machine,
You need to download the MySQL-4.0 source and compile for
embedded-server. This is a library that you link your programs to.
It is used for small devices, like what we are doing here.
I haven't found any docs on it yet, but the header files give plenty or
explaination.
Hope that helped
Brian
PhpMyAdmin writes : 3.23.40-log
Why -log, don't know ?...
Le jeu, 09 aoû 2001, vous avez écrit :
What version of Mysql is it?
-Opprinnelig melding-
Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]]
Sendt: 9. august 2001 19:45
Til: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Emne:
Hi,
I have a select statement and want to add a Percent sign to the output of one
expression. Do I have to use Concat-function or is there another way (for only one
character)?
Best Regards
Bernhard
p.S. Since this is no spam I include the words database, MySQL, query and table
Alright, but what if I do not have a ld.so.conf file? Do I just create one
in /etc/?
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 8:26 AM
To: Adam Douglas
Cc: Mysql@Lists. Mysql. Com (E-mail)
Subject: Re: Bad path to
Thank you all for your help!!!
The problem was set_time_limit(0);
Thank YOU ALL!
-Original Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 4:20 PM
To: Jason Radley
Cc: [EMAIL PROTECTED]
Subject: Re: mysql-php mailing list
Jason Radley
Ok but I've have chmod 777 on a couple of tables and I still receive table
in read only message. Plus I was under the understanding that you only need
say 700 because the mysql daemon it self would be modifying the files
directly and not the client using MySQL.
-Original Message-
From:
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown
linkage type in dependency graph
1 fatal error
Ideas?
Thanks
Jeff Tanner
Seattle, WA
-
Before posting, please check:
http://www.mysql.com/manual.php
Is there a way to put the results of a SELECT into a table without going
through an export file? For example, something like
SELECT * FROM table_1 WHERE condition INTO table_2
You can CREATE a table with the new data:
CREATE table_2 SELECT * from table_1
You can also INSERT or
On 2001 Aug 09, Jeff Tanner [EMAIL PROTECTED] wrote:
I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris
(Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine.
Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not
compatible for Sun Solaris (x86)?
Is there a way to have SELECT return sets for rows that were grouped
together? So if I had a table like:
Table:
ID DATA
1a
1b
2X
2Y
310
320
I want to do something like this:
SELECT MAKE_SET(-1,DATA) as LIST
FROM Table
Is the freebsd-elf mysql binary available at mysql.com compatible with
BSD/OS (bsdi) 4.1? If not, is there a place to download this
binary...or am I stuck with building it myself?
Thanks,
David
-
Before posting, please
So how can I log all the queries. Can I define a log (not binary log) file
in my.cnf using for instance log=filename in the mysqld section ?
Do I have to disable log-binary to use normal log ?
This is my startup:
/usr/bin/safe_mysqld \
--log=/var/log/mysql/query_log
Hi
i think this isnt a purely mysql specific question but surely related. I
have a stick bit set on the /tmp directory(Solaris) where the socket file
resides.But there is no protection on the file because ppl apart from the
owner of the file can delete the file..
Sachin
Hi there,
I am trying to optimise MySQL for use on a machine with:
Linux 2.4.7-ac9 (only kernel to work with the disk controller)
Dual Pentium III 1000 MHz
4096 MB memory
RAID-1 Mirror over two 76GB 7200 RPM UDMA disks
Reiserfs partition for MySQL
As a reference point, I am running
That means the server does not have permission to read the file.
James E. Hicks III wrote:
What exactly does this error mean?
mysqlimport: Error: Can't get stat of '/home/jameshicks/NONSTOCK' (Errcode: 13),
when using table: NONSTOCK
James
mysql
We are looking for a solution to backing up a remote database, without using
mysqldump, and replication seemed to offer the solution required.
I set up the master/slave configurations on both the master and the slave
exactly the way it was shown in the MySQL documentation (4.10.3 How To Set
Up
Hi,
Has anybody tried to concert a UNIFY database into a mySQL database? Has anybody even
heard of UNIFY? GRIN
Tim
[EMAIL PROTECTED] wrote:
Description:
I'm new to MySQL, and am porting an application from msql. Apologies
in advance for blatant ignorance on my part.
Apparantly the code that increments the counter on whether
a table has been modified is broken.
Philip,
InnoDB does not give an exact number of rows
to the query analyzer. A problem is that
in a multiversioned database different transactions
will see a different number of rows in the table,
and a single count of rows cannot be kept.
It is an eternal problem in query optimization.
Errors
I was wondering if there's a way to condense results given by a query.
What I'm looking at is a situation where the following query will give
me a number of rows with all but 1 column the same. I'd like to
concatenate that one column (with a user specified string) so that I
don't have to break
Hello,
I run the install of mysql on RedHat 7.0 via RPM
successfully. But when I try /usr/bin/safe_mysqld
--user=mysql or with whatever other option, I've the
message:
Starting mysql daemon with databases from
/var/lib/mysql 010809 20;59:28 mysqld ended
and when I try mysql -u root or another
I installed MySQL 3.23.40 perfectly without
ploblems... but I installed MySQL for database to PHP
4.0.6 with Apache 1.3.20... but when I compile Apache,
this error ocours:
=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=22
-I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main
I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among
others
when i do the following query with myphpadmin
update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where
requstID = 2;
i get:
You have an error in your SQL syntax near '\hot
Thanks Schajee,
Did you let Access make an SQL-script to build your tables ?
You could then use such scripts in mySQL to produce a copy of the
database.
And what would you be using for the import of the data ?
cheers,
bart
-Oorspronkelijk bericht-
Van: Schajee Achmad
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
Dmitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm still testing out MySQL and I'm trying to find the my.cnf file referred
to at
http://www.mysql.com/doc/O/p/Option_files.html
The page says to look in:
/etc/my.cnf
DATADIR/my.cnf
defaults-extra-file (The file specified with --defaults-extra-file=# )
~/.my.cnf
but none of these files
At 06:04 PM 8/8/2001 -0500, Paul DuBois wrote:
At 2:50 PM -0700 8/8/01, Bennett Haselton wrote:
The first page of the MySQL tutorial at:
http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
says that when you connect to the MySQL server, it authenticates you
based on a username and
Hi,
I use the windows binary distribution from www.mysql.com (version 3.23.40).
When I try to use the function mysql_real_escape_string, the linker complains
about not finding it...
Solution is easy :-) Add the symbol to libmysql.def and recompile...
Cheers
Oliver
--
DELETE FROM tablename;
where tablename is the name of the table.
-Bennett
At 05:23 PM 8/9/2001 -0400, Dmitry Kashlev wrote:
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
Dmitry
In the last episode (Aug 09), Dmitry Kashlev said:
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
TRUNCATE TABLE tablename
or
DELETE * FROM tablename
--
Dan Nelson
[EMAIL PROTECTED]
You might want to look into what your ulimit settings are for the process
starting mysql... usually this can be done with 'ulimit -a' but check your
shells man page for more info. You could have a memory limit set for the
process and mysql is not able to use the amount of memory you specify.
http://www.mysql.com/doc/U/s/User_names.html
says:
MySQL encrypts passwords using a different algorithm than the one used
during the Unix login process. See the descriptions of the PASSWORD() and
ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note
that even if the
I installed MySQL 3.23.40 perfectly without
ploblems... but I installed MySQL for database to PHP
4.0.6 with Apache 1.3.20... but when I compile Apache,
this error ocours:
=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=22
-I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main
Run a query like this ...
USE database;
DELETE FROM tblname;
Gerald Jensen
- Original Message -
From: Dmitry Kashlev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 4:23 PM
Subject: how to erase all data in database (table)
How can I erase all data except for
Excuse Me,
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux?
I try to follow the instructions mentioned in manual.txt but it didn't work.
Can you help me and tell my how to install it via RPM?
I gave the same password to user root and user bhaselto, using the
statements:
UPDATE user SET Password=PASSWORD('') WHERE user='root';
UPDATE user SET Password=PASSWORD('') WHERE user='bhaselto';
(using the real password instead of '', of course). The 'user'
table
We are moving away from windows all together in the office I work for, one of
our major programs that we use here is ACT2 DB. Can someone point me in the
right direction of converting a ACT2 DB to MySQL.
ANy help is greatly appreciated.
Kat
Kat:
This can be a little tricky ... the version of ACT! you have is pretty old.
ACT! is ... TTBOMK ... based on FoxPro. Unfortunately, it doesn't support
ODBC, so it doesn't connect to other DB servers.
The only way I have been able to port the data from ACT! is to use the
built-in export data
After succesfully upgrading to .39b things seemed to be running
great... However the past few days I have been having some problems with
queries not completing. This only seems to occur during higher loads and I
am not sure where to begin debuging. I was hoping someone has some ideas...
Here is
I've compiled MySQL 3.23.39 with Gemini support. The compile was error
free although the 'make test' skipped the Gemini tests for some reason. In
the mysqld.err log from the test directory I see this message:
00:18:15 MSGS_DIR tag failed -1
The source package for mysqlgui Makefile references an
object 'edfile' which is not included in the source package
(at Aug 9, 2001). When I try to compile without that object,
I get a missing function error.
Can anyone suggest where I can find this mysterious edfile?
Thanks.
Bo Green
We are moving away from windows all together in the office I work for, one
of
our major programs that we use here is ACT2 DB. Can someone point me in
the
right direction of converting a ACT2 DB to MySQL.
If it's any help, I recently used the following method to successfully
convert an ACT2
I have just downloaded mysql-3.23.39-pc-solaris2.8-i386 and I am going
through my first installation however I don't get far as one of the first
steps is to run the script mysql_install_db however the size of this file is
zero bytes!
I have seen the messages about Sun's tar not working
On Wednesday, August 8, 2001, at 07:32 AM, Sinisa Milivojevic wrote:
You are using the right compiler.
What you should check are symlinks to dynamic and static versions of
libstdc++.
They should point out to the stdc++ that came with gcc 2.95.2.
If that does not help, add a full path
On Thu, Aug 09, 2001 at 11:07:13PM -0400, Paul wrote:
I've compiled MySQL 3.23.39 with Gemini support. The compile was error
free although the 'make test' skipped the Gemini tests for some reason. In
the mysqld.err log from the test directory I see this message:
Is there any way -- using either MySQL directly, or (ideally) using the DBI
perl module -- to get a list of fields from a (possibly empty) table? (If
the table is nonempty, you can just use a perl function to get the first
record, and then apply keys() to the returned reference to get the
update cdrequest set albumfill = hot shots II, releasedatefill
= 20010708 where requstID = 2;
i get:
You have an error in your SQL syntax near '\hot shots II\,
releasedatefill = 20010708 where requstID = 2' at line 1
I can't see any reason for the error.
Your web based interface is
I'm still testing out MySQL and I'm trying to find the my.cnf
file referred to at
http://www.mysql.com/doc/O/p/Option_files.html
...
but none of these files seem to exist on my machine.
...
MySQL came pre-installed on that machine. Is it possible (or, indeed,
normal) that the MySQL
How is that possible? Even if you do know someone's scrambled password,
when you connect to the MySQL server pretending to be that user, it will
ask you for their non-scrambled password. After you type it in,
the server will scramble it and check that the scrambled value matches
the
Is there any way -- using either MySQL directly, or (ideally)
using the DBI perl module -- to get a list of fields from a
(possibly empty) table? (If the table is nonempty, you can
just use a perl function to get the first record, and then
apply keys() to the returned reference to get the
http://www.mysql.com/doc/U/s/User_names.html
says:
MySQL encrypts passwords using a different algorithm than the one used
during the Unix login process. See the descriptions of the PASSWORD() and
ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note
that even if the
97 matches
Mail list logo