char(16) or char(32) with PASSWORD() function or your own crypt ;-)
Hamid Mukhtar wrote:
>
> Hi,
> Is there any data type for storing passwords in tables so that they cannot
> be viewable by anyone.
>
> -
> Before post
Hi,
Is there any data type for storing passwords in tables so that they cannot
be viewable by anyone.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello.
Just installed on FreeBSD. No database created yet, just a straight install
I was surprised at the amount of memory the daemon is taking
25.7MB - Is that correct ?
-
Before posting, please check:
http://www.mysq
I would think that most current 2.4 distros, stable of course, should work just fine.
BTW- Congratulations (belated) , Jeremy on the Webby.
Denis Hammond
Systems Administrator
VolunteerMatch
Jeremy Zawodny wrote:
> On Sun, Jul 29, 2001 at 06:05:37AM +0200, Alexander Skwar wrote:
> > So sprach
On Sun, Jul 29, 2001 at 06:05:37AM +0200, Alexander Skwar wrote:
> So sprach »Jeremy Zawodny« am 2001-07-28 um 19:28:04 -0700 :
> > Have you looked at Debian unstable? It uses the newer 2.4 kernels
> > and, despite its name, it rather good.
>
> You're kidding, aren't you? You cannot honestly su
Hi!
I'm very new to MYSQL.
I'm trying to make a databases of my friend's personal data.
I divide the data into 2 related tables (relational database).
When I tried to get the data out from (both) tables - I don't find any major
problem. However, when I tried to insert data into both table.. I f
So sprach »Jeremy Zawodny« am 2001-07-28 um 19:28:04 -0700 :
> Have you looked at Debian unstable? It uses the newer 2.4 kernels
> and, despite its name, it rather good.
You're kidding, aren't you? You cannot honestly suggest Unstable for a
prodction server! Well, Testing is fine, but Unstable
So sprach »tj marlin« am 2001-07-28 um 13:44:03 -0700 :
> There are secure telnet packages. one for windows is SecureCRT. see
> www.vandyke.com
That's a contradiction in itself. Telnet never can be secure, as it
transmits all the data in clear text. It's very easy to sniff sensitive
data from
So sprach »James McLaughlin« am 2001-07-28 um 13:24:21 -0600 :
> PHPmyAdmin is a great program to use for working with a mySQL DB.
> http://www.phpwizard.net/projects/phpMyAdmin/
Or, for a more recent version of phpMyAdmin:
http://phpMyAdmin.sourceforge.net
PS: sql
Alexander Skwar
--
How to
On Fri, Jul 27, 2001 at 05:55:28PM -0300, Gatica, Mario Alberto wrote:
> Is there any performance difference between running a query on a
> compressed MyIsam Table rather than a normal MyIsam Table ?
Of course, but it's probably not significant on modern hardware. Try
a quick test and see.
Jer
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
> > I am currently trying to examine the benefits of continuing to
> > use MySQL over Oracle. I need to know what MySQL's features are
> > vs. those of Oracle.
>
> http://www.mysql.com/information/crash-me.php
>
> > Also I am looking fo
> So you're saying like this...?
>
> Albums
> --
> ID,Artist,Title,Label
>
> Tracks
> --
> Title,Length,TrackNumber,AlbumID
>
> Where there is one album table and one track table, and each
> track references back to the album that it is a member of?
> I'm liking that... It doesn't
On Sat, Jul 28, 2001 at 08:12:34PM -0600, Michael Blood wrote:
>
> I am creating a database server with mysql. I have an adaptec 2100s
> card which is not supported by debian 2.2 (my first choice in Linux
> OSs)
>
> The card seems to say that it is only supported by Red hat and SuSe Linuxes.
>
I am creating a database server with mysql.
I have an adaptec 2100s card which is not supported by debian 2.2 (my first
choice in Linux OSs)
The card seems to say that it is only supported by Red hat and SuSe Linuxes.
Any ideas on what would be the best OS to run a database server
My config
I'm posting to this general list because there doesn't seem to be any
list to report a spontaneous crash to.
Have tested MySQL 3.23.39-nt for some days by implementing a small
project. It has been running fine up to now when I after having dropped
a column from a table using MySQL GUI, tried to r
When you are designing a database and you are thinking about creating a
comma delimted list, this is a good sign that you need to rethink your
design. Bitfields are a good option, however if you ever need to add
elements to the bitfield (ie bitfield A can signify the presence of 4
elements, but no
On 28-Jul-2001 Ben Bleything wrote:
> Hello all!
>
> I have a question for all of you... I would very much appreciate your
> input.
>
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create wee
Ben Bleything wrote:
>
> Hello all!
>
> I have a question for all of you... I would very much appreciate your
> input.
>
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create weekly reports f
Can any please help with is?
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql' (111)
root 682 1 0 15:35 ?00:00:00 /bin/sh /usr/bin/safe_mysqld --d
mysql 730 682 0 15:35 ?00:00:00 /usr/libexec/mysqld --defaults-f
mysql 752 73
The rule of normaliztation is (usually) if you have data repeated in a table,
you need another table. So here's how *I* would do it.
A table for each: DJ's, Albums, Artists, Genres (a category table of sorts),
and Tracks. You might even want a table for record companies, so that's not
repeat
So you're saying like this...?
Albums
--
ID,Artist,Title,Label
Tracks
--
Title,Length,TrackNumber,AlbumID
Where there is one album table and one track table, and each track
references back to the album that it is a member of? I'm liking that...
It doesn't make it easy to dig through th
> My assumption:
> mysql> GRANT SELECT, INSERT, UPDATE ON client_db.*
> TO db_user@localhost IDENTIFIED BY 'password';
>
> Now this is where I get a bit confused. It's not clear to me where the
> client is connecting from. I assume they are connecting from localhost
> because everythi
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create weekly reports for the record labels.
[snip]
> First, to maintain a single table with every bit of track data there is
> (ie, title, artist,
Robert Roberts wrote:
>
> I am new to this list. I posted a perfectly honest question, but all I get
> back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked
> appua.com. The site is in Russian. I don't understand why I'm getting this.
> Perhaps someone can explain. In the meant
Hello all!
I have a question for all of you... I would very much appreciate your
input.
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly reports for the record labels.
I'm wrestling wit
I am new to this list. I posted a perfectly honest question, but all I get
back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked
appua.com. The site is in Russian. I don't understand why I'm getting this.
Perhaps someone can explain. In the meantime, here's my question -- again:
At 13:44 28-7-01 -0700, tj marlin wrote:
>There are secure telnet packages. one for windows is SecureCRT. see
>www.vandyke.com
Rather use PuTTY.. it's free!! and a very good SSH client I wonder how
many sysadmins still allow telnet..
Use your favorite searchengine to find PuTTY.. or find y
On Saturday 28 July 2001 02:44 pm, tj marlin wrote:
Telnet is NOT secure. The user name and password are passed to the server
through plaintext. Therefor anyone on or with access to your network
(meaninghyour ISP) can sniff and acquire this information with ease.
SecureCRT (which i proudly o
I am new to the list, and have only asked two questions. However, when I post I seem
to get a message back from [EMAIL PROTECTED] about not wanting me to spam. Am I doing
something wrong here? Does anyone else get this message as well?
Thanks,
SJS
You need to provide some more details about your task. What programming
language you want to use, and probably a sample from the file that matches a
repetitive subunit within the text. This information is needed since there
is a high chance that you need to exploit regular expression matching for
Has anyone done a db for a multi-level compensation structure? I'm talking
about a company that is MLM or a multi-level marketing network. Where
distributors sign up under other distributors and the "downline" can go down
many levels(but limited levels!). The important issue is how long would it
There are secure telnet packages. one for windows is SecureCRT. see
www.vandyke.com
for tips and pointers: basic telnet gives you a link to your server thru
your own pc. it is as if you were directly connected to your server.
At 01:24 PM 7/28/01 -0600, you wrote:
>On Saturday 28 July 2001 12:2
I do not know if this will help or not...
Why not use gnupg to create a public key, encrypt the root password using
the your keys, save or email the encrypted root password that you store in
your mysql maintence database. You can then query your database and take
that information and decrypted i
On Saturday 28 July 2001 12:23 pm, B. van Ouwerkerk wrote:
You should try to avoid using telnet to be honest, its not secure. Start
using ssh and do a google for ssh usage.
PHPmyAdmin is a great program to use for working with a mySQL DB.
http://www.phpwizard.net/projects/phpMyAdmin/
But hon
My MySQLGUI running on a Windows system is invariably much slower(typically
30 seconds) than a MSAccess database with tables linked with MyODBC to the
same Linux-hosted Mysql-database (typically less than 1 second) when
executing the same query over a telephone internet connection.
Why is that
At 18:06 28-7-01 +0200, Marco Bleeker wrote:
>I need to Telnet into my domain in order to run some MySQL utility like
>mysqldump (for backup). I am not experienced with Telnet. Any pointers?
>Any way around it (use mysqldump from PHP?)
Good reason to learn it :-)
You could try phpadmin (or was
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
first thing
On Wed, Jul 25, 2001 at 12:03:59PM +0400, Artem V. Ryabov wrote:
> Hello All,
>
> When I use "order by .. DESC" in query, time always more then in
> "order by .. ASC" case.
> Explain say "Using filesort",in "DESC" case query.
>
> Why???
Because in 3.23.xx, MySQL doesn't know how to walk the
On Sat, Jul 28, 2001 at 08:40:15AM -0700, Michael Collins wrote:
> At 11:08 PM -0700 7/27/01, Jeremy Zawodny wrote:
> > > I have a table that shows MUL in the key field column, what does
> >> that indicate?
> >
> >That means it's a non-unique key.
>
> Thank you, but what does "MUL" stand for? "
Hi!
I'm not subscribed to the list, so please CC: [EMAIL PROTECTED]
Question:
-
Can mysqld --skip-grant-tables --bootstrap ... be run on a *live* system
(with a regular mysqld server running) or can this cause data corruption.
Info:
-
We are working on a Linux server project aimed
Hello,
I was wondering if anyone could give any advice on how to go about parsing a
plain text file into a mysql database. I have a class Roster table that I
need to parse a text file into. I already have the uploading part of the
file done. Now I just need to add some code to parse the file
PHP upgrade http://www.php.net/support.php
MySQL upgrade http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html
Cheers
M;)
-Original Message-
From: Kris Blackwood [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 28, 2001 10:44 AM
To: [EMAIL PROTECTED]
Subject: PHP4 and MySql.
Hi,
I am
On 28-Jul-2001 Philip Mak wrote:
> I have a table called "stats" with:
> user varchar(40) not null primary key,
> count mediumint not null.
>
> I want to do something like this:
>
> UPDATE stats SET count=count+1 WHERE user='$user';
>
> But if there is no row in the "stats" table having user='
Hi,
I am currently running PHP3 and would like to upgrade
to PHP4 and lastest version of MySql.
I am kinda new at this was wondering if somone could
guide me in the right direction.
Do I need to do a complete install of both?
Kris
__
Do You Yaho
I need to Telnet into my domain in order to run some MySQL utility like
mysqldump (for backup). I am not experienced with Telnet. Any pointers? Any
way around it (use mysqldump from PHP?)
Thanks, Marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
| ww
At 11:08 PM -0700 7/27/01, Jeremy Zawodny wrote:
> > I have a table that shows MUL in the key field column, what does
>> that indicate?
>
>That means it's a non-unique key.
Thank you, but what does "MUL" stand for? "Multiple" keys?
I suppose it is a key since I created an index on that field.
I have a table called "stats" with:
user varchar(40) not null primary key,
count mediumint not null.
I want to do something like this:
UPDATE stats SET count=count+1 WHERE user='$user';
But if there is no row in the "stats" table having user='$user', that
statement will not create the row.
The
Thanks for responding, but the full path is not the answer.
I have tried every conceivable full path (see original message) and it does
not help. In fact, the only thing that has ever worked was using no path
info and putting the file in the root of the C: drive on my local machine.
But for some
Dave Fogle writes:
> Thanks for reading this - I have searched all the MySQL info I can find as
> well as the web at large, but nobody seems to have offered a real answer to
> the following problem, which many have had, though possibly only with Win32
> client machines accessing UNIX servers:
>
>
Thanks for reading this - I have searched all the MySQL info I can find as
well as the web at large, but nobody seems to have offered a real answer to
the following problem, which many have had, though possibly only with Win32
client machines accessing UNIX servers:
The problem arises when trying
Van wrote:
[== snip, snip ==]
> Anyone else see the irony? Small wonder Open Source hasn't been lucrative.
> We're solving all the problems of the money makers at our own expense. Time we
> should look at how open we want our own model to be to clients who choose models
> of lesser openness. I
[EMAIL PROTECTED] writes:
> >Description:
>I'm compiling with GNU make and tar, and SunPro C++ V6 r2
>
>This compiler is now called Forte C++, but it is SunPro.
>
>I did miss the Solaris section in the docs. I believe I followed
> them to the letter this time. I did the followi
I have received 30+ of those emails. It seems 90% of my contact list is dumb
enough to open strange attachments. Go figure
- Original Message -
From: "Duncan Hill" <[EMAIL PROTECTED]>
To: "Steve Brazill" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 5:04 PM
Subjec
GoFind.RO writes:
> When a try to fix a .MYI file , myisamchk dumps core. You can download the
> file from http://gofind.ro/dbs.MYI
> I fixed a lot of other files and it worked perfect, but this one
> I have MySQL-3.23.40-1 installed from original RPM , running on Linux
> Mandrake 8.0 on a
Brad Morris writes:
> I'm perplexed.
>
> My company develops a browser-based application that uses the mySQL 'C' API
> to talk to the MySQL backend.
>
> I'm currently trying to find a solution to a problem my company is having
> with migrating from MySQL v.3.22 to v.3.23. Here are the details:
David Ayliffe writes:
> pc-xx-xx-190-118-du:~/mysql++-1.7.9/examples # g++ -I../sqlplusint/
> -I/usr/local/include/mysql -c simple1.cc -L../lib
> ../lib/libmysqlclient.a -lsqlplus
> g++: ../lib/libmysqlclient.a: linker input file unused since linking not
> done
> g++: -lsqlplus: linker input file
Bruce Ferrell writes:
> I'm replying to the list because I got so many of these back:
>
>
>
> Ya know gang... some days it just doesn't pay to get outta bed.
>
> Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
>
> Sorry and to the guy who replied with no spam
I am going to violate a principle and burn up some bandwith here
to say samething that most people probably feel about this post.
BRAVO VAN, for summarizing this situation cogently, and fairly.
With this kind of measured observation, the statement that Microsoft
software sucks does not embody a f
tj marlin wrote:
>
> This virus is becoming wide spread. It appears to use a machine's address
> book and mail itself to the members of the address book. i've received mail
> with the virus from a number of people, in addition to receiving it from
> this list.
>
And, I have a bunch of stranger'
I have a stock of Box sets, which contain a MySQL manual together with a
distribution CD that includes the following:
1. Binary for: Linux, Solaris, SGI Irix, AIX 4,x DEC Unix 4,x Tru64 Unix,
SunOS 4,x SCO, Hpux,PPC Win32, FreeBSD+BSDI+NetBSD
2. Contribution programs
3. Documentation
4. Examples
If you had read the installation instructions, you would have seen
statements that looked like this...
cd /usr/local/mysql
./bin/mysql_install_db
Make sure that the "var" directory that is created grants access to the
'user' that MySQL is running as... (otherwise I'm sure we'll be getti
Hi!
On Jul 27, Peter Szekszardi wrote:
> Hi,
>
> I have recompiled mysql using the hungarian character set, reindexed all
> the tables,...
> I have strange problem now:
Ok, could you create a test case for that ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /
> I am inserting several fields into a table, however there's an 'id' (id integer not
>null auto_increment) column that I use as the primary key.
>
> the problem lies in the fact that I want to get the 'id' that was generated from
>this insertion. However the data I insert has no unique value ap
63 matches
Mail list logo
