Hi,
If I understood your message right, the answer is no. The only place
passwords are stored is the mysql database, so they're physically located
in the mysql.MYD file. They're encrypted there, too.
Iikka
**
* Iikka Meriläinen *
* E
On Sun, 11 Aug 2002 [EMAIL PROTECTED] wrote:
> I have just started using mysql for a database project and I wonder that one
> function is missing. I am using myphpadmin as utility. It is possible to
> write a comment to each table, but it is not possible to write a comment to each
> field. Why not
is there a password file accessable from root for mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
>Description:
Mysql crashed
>How-To-Repeat:
Don't know how to reproduce - server running a busy site with multiple
concurrent clients. Impossible to tell which caused the crash, but I'll gather more
evidence (try --log) and follow up if I can find anything specific.
>Fix:
In the last episode (Aug 12), duo fu said:
> I have just created a small web site with php/mysql. I do a query
> into one of my tables whose ".MYI=338K " and ".MYD=7.6M". I could
> only retrieve some part of the data and then the browser just died
> there. My query is " select * from Forces". The
Hi, friends:
I have just created a small web site with php/mysql. I do a query into one
of my tables whose ".MYI=338K " and ".MYD=7.6M". I could only retrieve some
part of the data and then the browser just died there.
My query is " select * from Forces". The primary key is combination of
seve
Hi, friends:
I have just created a small web site with php/mysql. I do a query into one
of my tables whose ".MYI=338K " and ".MYD=7.6M". I could only retrieve some
part of the data and then the browser just died there.
My query is " select * from Forces". The primary key is combination of
seve
In the last episode (Aug 12), Ville Mattila said:
> Hello folks,
>
> I'd need to re-install MySQL server on my RH 7.3 box. As I installed the
> server from RPMs, I tried to update MySQL with rpm and -Uvh options. Results
> were like this:
>
> [root@pilotmedia root]# rpm -Uvh MySQL-3.23.51-1.i386
Hello folks,
I'd need to re-install MySQL server on my RH 7.3 box. As I installed the
server from RPMs, I tried to update MySQL with rpm and -Uvh options. Results
were like this:
[root@pilotmedia root]# rpm -Uvh MySQL-3.23.51-1.i386.rpm
Preparing...###
I have a query I'm trying to construct on a table which contains a title and
date of records. I want to sort the query so that records are listed by
title with the newest dates first--keeping the records with identical titles
together and order by date within the title groups.
For example:
T
At 8/11/2002, you wrote:
>I believe that what you called "intermediate table" books are calling
>"table map", or something with the word "map" in it.
Hi Lloyd,
Books are nice to have (you can lie down to a sofa or sit in the loo with a
book), and what I started with (SAMS Teach Yourseft MySQL
on 8/11/02 2:47 PM, Pekka Saarinen, typed:
> At 8/11/2002, you wrote:
>> MySQL queries.. tables... design.
>>
>> http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
>>
>> There you will see a rough draft of what I am trying to do.
>>
>> Perhaps you will see some places that I will need to use a
I've never used a MySQL database before to create a dynamic website. I've
done it loads of times with Access and ASP but now I need some help on
developing firstly the database in a windows environment. Then I'll use PHP
to access the database but on a Linux or Unix server? Anyone out there know
o
Hello Dave,
Phew... what a situation! ;-)
You can always run mysql_install_db script on *NIX, but it clears your
existing permissions. On Windows you can do an xcopy for your mysql
database from the distribution package, but that doesn't save your
permissions, either.
First, though, make sure t
I seem to have lost the "mysql" database tables.
I have other databases that work.
what is the best way to add the right tables to mysql
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
At 8/11/2002, you wrote:
>MySQL queries.. tables... design.
>
>http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
>
>There you will see a rough draft of what I am trying to do.
>
>Perhaps you will see some places that I will need to use a table_map?
>
>Or you can advise me of how to arrange my keys
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Mike Hall" <[EMAIL PROTECTED]>
Cc: "Michael Collins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, August 11, 2002 7:05 PM
Subject: Re: [OT] assigning new passwords (was: Need reversible encryption
as string)
Hi.
I drag this a bit to off-topic here, but the answer below brings up a
question which bothered me for some time...
On Sun 2002-08-11 at 17:30:46 +0100, [EMAIL PROTECTED] wrote:
> An easier (and more secure) way, surely, is to use one-way encryption... and
> if a user forgets his/her password,
At 19:51 +0200 8/11/02, Benjamin Pflugmann wrote:
>Hi.
>
>On Sun 2002-08-11 at 12:07:47 -0500, [EMAIL PROTECTED] wrote:
>> At 9:25 -0700 8/11/02, Michael Collins wrote:
>[...]
>> >SELECT * FROM MYDB
>> >WHERE EmailAddress=$EmailEntered AND
>> >DECODE(LoginPassword,'MySalt')=$PasswordEntered
>>
Hi.
On Sun 2002-08-11 at 12:07:47 -0500, [EMAIL PROTECTED] wrote:
> At 9:25 -0700 8/11/02, Michael Collins wrote:
[...]
> >SELECT * FROM MYDB
> >WHERE EmailAddress=$EmailEntered AND
> >DECODE(LoginPassword,'MySalt')=$PasswordEntered
>
> If you write the query like that, yes, it will use a compl
At 12:07 PM -0500 8/11/02, Paul DuBois wrote:
>If you write the query like that, yes, it will use a complete scan.
>But you could also use
>
>... AND LoginPassword = ENCODE($PasswordEntered,'MySalt')
>
>which doesn't perform a calculation on the LoginPassword column and thus
>can use an index. Th
At 9:25 -0700 8/11/02, Michael Collins wrote:
>I want to securely store a value that is used as a password to log
>someone into a Web application. I also want to be able to allow the
>user to search for their email address and have their password sent
>back to them (in readable form). Encrypt,
At 9:54 AM -0700 8/11/02, Mike Wexler wrote:
>>I would think that using the SQL shown would require a table scan,
>>meaning that each and every record in the visitors table must be
>>examined, the LoginPassword decoded and compared. There is also no
>>way to index this field. I do not think thi
An easier (and more secure) way, surely, is to use one-way encryption... and
if a user forgets his/her password, replace it with a random alphanumeric
string and mail that to them instead with instructions to change it to one
of their own choosing as soon as possible.
Mike
- Original Messag
I want to securely store a value that is used as a password to log
someone into a Web application. I also want to be able to allow the
user to search for their email address and have their password sent
back to them (in readable form). Encrypt, MD5, and Password are
non-reversible and thus wi
Also, see what errors you are getting in mysql .err file
Regards,
Bhavin.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, August 11, 2002 3:30 AM
Subject: Re: Mysql Problem Query
> did you also install the databases that are part of the
>Description:
"NET" is defined on line 135 in myslq_com.h. When I include
mysql.h (for embedded mysql) I cannot compile a program which also includes
netwm_def.h, which defines a completely different "NET".
>How-To-Repeat:
Try to compile something that includes thes
Hi,
I'm sometimes experiencing in my application the "commands out of sync; You
can't run this command now" error.
According to the MySQL manuel, it means :
This can happen, for example, if you are using mysql_use_result() and try to
execute a new query before you have called mysql_free_result().
did you also install the databases that are part of the mysql installation?
-Ll
on 8/11/02 5:59 AM, Anish Mathew, typed:
> my sqlserver is not running
>
> when i issue the command " mysql"
>
> the response i got was " cant connect to local mysql
> server through socket /var/lib/mysql.sock (
From
Anish MAthew
India
Dear sir
i am using Linux 7.2 as my OS and having mysql version
3.36.
i am a novice learner of mysql though i am familiar
with Oracle and sybase. when i got to no the GNU
publice license and open
source technology i thought of learning mysql.
but i hav
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
Or you can advise me of how to arrange my keys, or otherwise develop this
db?
I
Hi mysql users, mysql developers!
I have just started using mysql for a database project and I wonder that one
function is missing. I am using myphpadmin as utility. It is possible to
write a comment to each table, but it is not possible to write a comment to each
field. Why not? I think this wou
32 matches
Mail list logo
