Hi All,
We are about to embark on a project that requires data encryption - mainly
to stop sensitive information being viewed accidentally (ie viewing tables
directly through odbc connections or standard mysql clients). The server
(solaris) will not be publicly accessible. Mysql has a variety of
e
Hi
I'm using RedHat 8.0 and MySQL 3.23.52. I've also downloaded the MySQL Control Center
(latest). On the Linux mashine everything works just fine, but when I try to connect
to MySQLserver from Win2k using alpha version of MySQL Control Center I get "ERROR
2013: Lost connection to MySQL server
Hi!
We are using mysql, version 4.0.4 beta on windows 2000 Server.
I tried to put data und index on different drives, usind the DATA and
INDEX directory option of the "create table" statement.
But both was created in the default data directory.
Is there anybody, who already used it successfully?
By
When you say "port" are you asking to export the access DB to mysql? If
so, Intelligent Converters makes one and you can also do it with EMS
MySQL manager.
If you wanting to view the mysql data in access; you can do this using
myodbc and open it using external data using the ODBC source.
-Or
Hello everyone
I was wondering if there are any tools that would allow me to port a
access database to mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear Sir:
i am a user of mysql gui,version
mysqlgui-win32-static-1.7.5-2. My pc is Petium 4 1.4G,
on which most program run very fast. but when i use
mysql gui, i find it run very slowly although i can
get the result.
I wonder how can i make it run faster. thank you for
your helping.
My OS: WI
I reconfigured and recompiled MySQL 3.23.53 that is supports now conversion
between Windows-1250 and ISO-8859-2 charsets.
If I do 'set character set cp1250_latin2' in a session, then everything goes
all right BUT only in insert/update/select statements.
If I do the same set and use "LOAD DATA INFI
--- Forwarded message follows ---
From: Mail Delivery System <>
To: Self
Subject:Mail Delivery Failure.
Date sent: Thu, 14 Nov 2002 06:50:33
Delivery has failed on the enclosed message for the following
reasons reported ei
Michael, Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:21 PM
Subject: Re: mysqlhotcopy point-in-time recovery
> On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote:
> > Jeremy
> At 23:23 -0500 11/12/02, <[EMAIL PROTECTED]> wrote:
>> The MySQL documentation (4.6.1) says:
>> You can change the character set with the --default-character-set option
>> when you start the server. The character sets available depend on the
>> --with-charset=charset and --with-extra-charsets=
Hi,
If this is a FAQ, I haven't been able to find it. I am a newbie to MySQL,
but I've followed the directions carefully and I get this whenever I start
mysqld:
# bin/safe_mysqld --user=mysql &
[1] 24487
zaphod:/usr/local/mysql[15:02]# Starting mysqld daemon with databases from
/var/lib/
Chris Walcott wrote:
How do I LOAD a text file into a table that has a Primary Key defined?
I drop the Primary Key (and Timestamp) when I use 'load data infile'.
Below is my VB code which I use in Access to import stuff into MySQL.
Maybe someone will find it useful.
The point is that you h
I'd pick up the text file and search/replace all end of line character(s)
with a end of line"00 "comma combination so it reads
> 00,Abe,Lincoln,8347
on each line and try your first method. If that fails, I would drop the ID
field off the table, then do the import with original file, then atlter the
How do I LOAD a text file into a table that has a Primary Key defined?
I have the following table defined:
mysql> describe phoneList;
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+--
if you can affect closure without artificial
constructs, then it probably belongs in a single
database. if closure can't be affected in the
logical design, then you probably need multiple
databases.
if you don't understand the concept of a
relational database closure, refer to
http://www.c
MySQL folks,
I am having a problem with replication. When I create a new database on
the master, the CREATE DATABASE command is not shipped to the slave.
Subsequent table creation and table updates on the new database on the
master are replicated on the slave, but since the new database was not
cr
Hi Guys,
I am trying to comile a c++ program with mysql++ but I got an error message:
In file included from /usr/include/sqlplus/coldata1.hh:10,
from /usr/include/sqlplus/sqlplus.hh:12,
from createtable.cc:3,
/usr/include/sqlplus/null1.hh:4:19: ostream: No su
Hi,
I am newbie to MYSQL and ODBC
I have to update more than 2 tables simultanously
currently my application uses ADOBC connection object.
How can turn off the autocommit option and set manaul commit.
what places I need to change inorder to work manual commit
Thanks in Advance for your time
Dev
Hi
It's not a MySQL issue, it's a web server configuration problem. Check
you php.ini file and unquote in the section:
;Windows Extensions
the line accordingly with the DB connexion you're using. MySQL is set by
default.
Also try the function odbc_fetch_into()
-Mensaje original--
At 23:23 -0500 11/12/02, <[EMAIL PROTECTED]> wrote:
The MySQL documentation (4.6.1) says:
You can change the character set with the --default-character-set option
when you start the server. The character sets available depend on the
--with-charset=charset and --with-extra-charsets= l
Hi,
I am trying to comile a c++ program but I got an error message as below:
sqlplus.hh: No such file or directory
I have mysql server and client 3.23... on rh 7.2 and I have installed binary
RPM for SuSE 8.* built by gcc 3.2
<../Downloads/mysql++/mysql++-1.7.9gcc3.2-2.i386.rpm>
by: rpm -ivh "my
Shakeel,
- Original Message -
From: "Shakeel Sorathia" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:39 PM
Subject: InnoDB: Error: tablespace size stored in header
> Hi, we're using Innodb here and I just upped the number of datafiles
> that
Where can I get a "tuning guide" for MySQL (MyISAM and InnoDB)...
memory-wise and son on?
At 11:11 13/11/02 -0800, you wrote:
On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote:
>
> Can any of you point me to documentation or have a quick summary of
> how beefy to make a mysql server.
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running Red
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
At 13:47 2002-11-13 -0500, Rick Root wrote:
[root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.41-1
MySQL-server conflicts with mysql-server-3.23.41-1
[root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm
error: fa
If you ran into any problems it would probably
be RAM. RAM is cheap so if you have trouble...just
pop a couple of 512MB chips in it.
~KB
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com]
Sent: Wednesday, November 13, 2002 11:12 AM
To: Devore, Jacob
Cc: '[EMAIL PROTECTE
I have a windows 2000 adv server that is running mysql and php in other to
interact with couple of other Microsoft Access database.
However, I have a challenge with the function "odbc_fetch_array( )" which is
returning a "endefined function error" when used with the ODBC connection.
I have used
On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote:
> Jeremy Zawodny wrote:
>
> >Well, it handles ISAM, MyISAM, and BDB (last I checked). So what
> >should it be called? mysql_isam_myisam_bdb_hotcopy?
> >
> >
>
> Heheh, point taken. It seems simply unfortunate that the progra
On Wed, Nov 13, 2002 at 05:03:38PM -0200, Silmara wrote:
> I'm working with MySQL-Innodb and I have one table with primary key composed
> by the 5 first fields, and I want to change this removing the primary keys
> attributes and add one new field in the first position as primary key and
> auto_inc
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running Red
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
You might need to use rpm -e to uninstall previous version first.
Check the documentation.
~Kelly W. Black
-Original Message-
From: Rick Root [mailto:rroot@;wakeinternet.com]
Sent: Wednesday, November 13, 2002 10:47 AM
To: mysql
Subject: Upgrading MySQL from 3.23.41 to 3.23.53a
I woul
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita@;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the modul
Hello.
I have a problem with mysqld 3.23.49 .
My program consists of a father process and n children.
The children do a UPDATE at a certain time and the father might do a
SELECT at the 'same time'.
I suspect strongly that this is the problem. Any ways the father process
hangs at random situations
[EMAIL PROTECTED] wrote:
Hi all, i'm planning on using servlets for an application I am
building What I need to know is if there are any thread safe JDBC
drivers?
MySQL Connector/J is thread-safe, but even though the JDBC spec states
that the driver itself must be thread-safe, most of th
It does except my hosts file has localhost.localdomain switched around
from what you specified. Mine is:
127.0.0.1 web01.nxtek.net web01 localhost.localdomain localhost
Any other ideas anyone? I wish the rpm did all this crap. heh
-Original Message-
From: Black, Kelly W [PCS] [mailto:kbla
On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote:
>
> Can any of you point me to documentation or have a quick summary of
> how beefy to make a mysql server. Basically we probably won't have
> more than 50 connections at one time and we will be pushing packets
> of 2Mb at times. I'm
Hi, we're using Innodb here and I just upped the number of datafiles
that innodb was using. When I did a show table status I noticed that I
didn't get all the space that I had added. When I looked at the error
log, I got recieved the following error.
InnoDB: Error: tablespace size stored in h
Sorry I made a mistake as Paul pointed out.
I meant
GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
If you use the "localhost" substitution for the fully qualified domain name
then be sure your /etc/hosts file has a line at the top like
127.0.0.1 localdomain.localhost loc
I'm working with MySQL-Innodb and I have one table with primary key composed
by the 5 first fields, and I want to change this removing the primary keys
attributes and add one new field in the first position as primary key and
auto_increment. How can I do this?
best regards,
Sil
-
It doesn't appear this part is valid sql, query
DATA_DIRECTORY="/tmp";
~K Black
-Original Message-
From: Yuyi Guo [mailto:yuyi@;fnal.gov]
Sent: Wednesday, November 13, 2002 9:21 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: create table w/ data/index directory
Hi,
I am usin
On 13 Nov 2002 18:31:15 -
[EMAIL PROTECTED] wrote:
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> To confirm that you would like
>
>[EMAIL PROTECTED]
>
> removed from the mysql mailing list, please send an empty reply
> to this address:
>
>
Hi,
You can make your own authentification system.A table which can have a
binary char/varchar field for encrypted password(effect similar like
password from mysql.user) and another char for ASCII password.
If you not use "grant" statement for adding new user, you can use the MySQL
authentification
Hi,
Today I had a crash on my production server running Max-3.23.53a
It has the following specifications
MySQL-Max3.23.53a
RedHat 7.3
Kernel 2.4.18-SMP
Glibc-2.2.5-42
2GB of memory
When I resolv my stack_dump I get the following. Can anyone make something
useful out of this? I
I would like to upgrade MySQL to the latest production release
(3.23.53a) from my current 3.23.41
I have the following packages installed already:
mysql-devel-3.23.41-1
mysqlclient9-3.23.22-6
mysql-3.23.41-1
mysql-server-3.23.41-1
What do I need to do in order to upgrade to the newest version?
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul@;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
At 11:45 -0
I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I
did it for both. I'm still getting this:
[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Usin
Hi all,
I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.
I could find only the module DBD::mysqlPP for pure Perl.
I don't understand what pure perl means but I've seen that this module
acce
Hello.
I have a problem with mysqld 3.23.49 .
My program consists of a father process and n children.
The children do a UPDATE at a certain time and the father might do a
SELECT at the 'same time'.
I suspect strongly that this is the problem. Any ways the father process
hangs at random situations
Daya,
Wednesday, November 13, 2002, 7:51:53 AM, you wrote:
DKD> Can naybody tell me how do i ignore special character while insering in
DKD> mysql database. For example while i m inserting string 'dk\bd\r' it takes \b
DKD> and \r as diffenrent character, although i can ignore it with one more
DKD>
Thanks for the reply.
I'm not clear on the solution?
--- Original Message ---
From: "Cooke, Francis" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: Order issue with MySQL
>> --
>> From:[EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
>>
>> Hello All,
>>
>> Using MySQL for sq
Ben,
create a column in the user table, that holds a flag called "mustChangePassword" (or
whatever you want to name it). Then write your PHP code that way, that a login of a
user who must change his password will be redirected to the "change password page" and
store the new password and reset t
At 23:27 -0800 11/12/02, Ben C. wrote:
I am using the MySQL password() function for the my passwords on the user
names. How do I decrypt the password in PHP to send it in an e-mail. I am
making a forgot your password page and want to have the user enter their
e-mail and have the password sent to
At 11:21 -0600 11/13/02, Yuyi Guo wrote:
Hi,
I am using Mysql version: 3.23.52 on Red Hat Linux.
The option is DATA DIRECTORY, not DATA_DIRECTORY, but in any case it was
introduced in 4.0.0. Your version doesn't support it.
I tried to create a table as below and got error. Could some one
p
I am a little new to MySQL and PHP. How do I make the password a temporary password.
So when they login the first time they need to reset the password?
Thanks for you help in advance.
Ben
>
> From: "Merlin, The Mage" <[EMAIL PROTECTED]>
> Date: 2002/11/13 Wed AM 04:20:20 EST
> To: "Ben C." <
That's right, I should have checked before clicking on Send ;)
gerald_clark wrote:
> That should not be DESC.
> That will give the max value.
>
> Joseph Bueno wrote:
>
> > Erwin Ulreich wrote:
> >
> >
> >
> >> I want to code the following in one statement:
> >>
> >> select min(field1) from table1
Hi,
I am using Mysql version: 3.23.52 on Red Hat Linux. I tried to create a
table as below and got error. Could some one point me what I did wrong?
Or the DATA DIRECTORY defination does not really exist?
Thanks, Yuyi Guo
mysql> create table testtable2 (col1 varchar(10) NOT NULL, col2
varchar(
Hi,
perhaps try :
ORDER BY SUBSTRING_INDEX(your_field, '-', 1) asc,SUBSTRING_INDEX(your_field,
'-', 2) asc,SUBSTRING_INDEX(your_field, '-', 3) asc;
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:38 PM
Subject
Hi,
I currently have my replication setup with 3 machines
as such:
A > B > C
Machine A just died, so B is now my master. However, I
want to re-adjust my setup so it looks like this:
B > A > C
So what I did was stop C and copy everything over to
A. At this point, either A or C should be able to
> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
>
> Hello All,
>
> Using MySQL for sql...webpage forms:
>
> I am trying to order the following:
>
> 1-03-0A0019-03-0D004;
...
> when I added 11-02-0B001, etc. it came after "1-03-
> 0D004, then continued to rest
Erwin Ulreich wrote:
> I want to code the following in one statement:
>
> select min(field1) from table1;
> $res=result of the query
> select * from table1 where field1=$res;
>
> does anyone know?
>
select * from table1 order by field1 desc limit 1
--
The MySQL have SPOOL where can I stores query results in a file?
How can I do this?
How can I show my Indexes, Primary keys and Foreign Keys?
best regards,
Sil
-
Before posting, please check:
http://www.mysql.com/manual.php
The -p means you are going to enter the CURRENT password.
Since you don't have one yet, either leave off the -p, or
hit the enter key at the passowrd prompt.
P. Fawcett wrote:
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't set root & user pass
Hello All,
Using MySQL for sql...webpage forms:
I am trying to order the following:
1-03-0A0019-03-0D004;
this works fine using simple "order by asc".
when I added 11-02-0B001, etc. it came after "1-03-
0D004, then continued to rest of order.
how do I fix this so that 11-xx-xxx comes afte
Ben C. wrote:
I am using the MySQL password() function for the my passwords on the user
names. How do I decrypt the password in PHP to send it in an e-mail. I am
Short answer: You don't.
Long answer: search the archives for this mailing list; it was asked
about a week ago and I gave a long
tx - i knew the diff between prod/& 'having fun' & will stick
w/production. just wasn't sure if there were verion conflicts w/the php
& apache, or it was just user (ie. me) error in config's
per below response - that would explain why mysql gets installed 1st.
i've heard/read? to stick w/all sourc
>Description:
mysqlhotcopy ignores --host -h option
>How-To-Repeat:
call mysqlhotcopy with a host differs from localhost
>Fix:
Add "host|h=s" to GetOptions
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis:
>Severity: non-critical
>Pri
pp
p
Look like you need a 'p' :-)
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett@;bard.edu]
Sent: 13 November 2002 16:28
To: MySQL Mailinglist
Subject: setting passwd?
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't
I want to code the following in one statement:
select min(field1) from table1;
$res=result of the query
select * from table1 where field1=$res;
does anyone know?
-
Before posting, please check:
http://www.mysql.com/manual.php
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't set root & user passwd? simple syntax
error?
[root@a bin]# ./mysqladmin -u root -p password pp
Enter password:& i enter p again
./mysqladmin: connect to server at 'localhost' failed
3.23.55 Production
4.2.2 is ALPHA
4.0.4 is BETA
So if you are runing a production server go for 3.*
If you can risk it go for 4.0.4 (should be ok)
and if you want to have some fun 4.2.2
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett@;bard.edu]
Sent: 13 November 2002 16:05
To: [
what mysql version is recommended for running w/apache 1.3.26 & php
4.2.2?
i'm having trouble getting mysql config'd w/these & wonder if i should
avoid/lean to any particular versions?
-
Before posting, please check:
http://ww
Search for "aliases" in manual.html.
PB
-
- Original Message -
From: "Phillip Rhodes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 12, 2002 8:59 PM
Subject: support table synonyms?
>
> I can not find anywhere that says that mysql supports table name synonyms
For speed multiple or single database makes no difference.
For SQL I would stick with one if all the data is related.
Index any thing you are going to select on. So if you have a user database
you would index name and password not there age and job title.
Simon
- Original Message -
From:
* TimeWalker
> I've been trying to work out a complicated query to select and
> sum multiple columns in one select using a condition and multi
> column group by
>
>
> What I expected to get was ONE row with the columns summed .
>
> this query returns 5 rows
>
> SELECT sum(`AllTheWeb`),sum(
- Original Message -
From: "William Martell" <[EMAIL PROTECTED]>
To: "MySQL Main List" <[EMAIL PROTECTED]>
Sent: Monday, November 11, 2002 2:02 PM
Subject: SCHEMA, ARCHITECTURE ???
> Hello All,
>
> How do I determine the best architecture for my MySQL database?
>
> Do I create multiple d
Mike,
thank you very much for a repeatable bug report!
This revealed an embarrasing bug in InnoDB SELECTs: if you selected with the
full value of a primary key, and the row which matched to it was
delete-marked, then InnoDB could in some cases return the NEXT row.
Since purge cleans off delete-m
Thank you for the response. It looks like that worked! I am going to try it
on the webpage now. I will let everybody know if this works.
Thanks
Rick
PS. to everyone else I want to say thanks. I have run the ones that you have
sent but always came up with an error. If you want me to send you the e
I've been trying to work out a complicated query to select and
sum multiple columns in one select using a condition and multi column group by
What I expected to get was ONE row with the columns summed .
this query returns 5 rows
SELECT sum(`AllTheWeb`),sum(`AltaVista`),sum(`AOL`),sum(`Ask`),
Hi,
Is there a way to compare between a mysql process ID showed in top or ps
with a process ID from mysqladmin processlist ?
I'm asking this because we operate a mysql machine used for webhosting and
it has many users and many databases. If users do crazy stuff that result in
high usage of resou
I recently installed mysql 3.23.53 on Windows NT.
I'm no longer able to run 'winmysqladmin.exe'. The following message is
displayed:
winmysqladmin.exe - Entry Point Not Found
The procedure entry point CreateToolhelp32Snapshot could not be
located in the dynamic link library KER
* [EMAIL PROTECTED]
> Having just walked into a job a few months back, one of the tasks I've
> been asked to accomplish is to counting records inside a DB based on a
> field. The database in questions holds realtor listings. There are fields
> for Company Name and Agent Name on each listing. What
Background:
MySQL++ ( libsqlplus ) is a pretty nice official C++ styled mysql client
library wrapper of libmysqlclient. It offers STL-style C++ interface and is
designed with an effort of generic programming style. It should be a really
excellent choise if only it had not a MEMORY LEAK problem.
>Description:
I use a little subset of mysql++ capabilities
- Connection
- Query ( only Query::store )
- Result
Memory leak I discovered is located somewhere in Result::operator= and is
available only after update;
Proof of concept code is supplied.
It leaks 1 Mb of memor
I need to move a whole bunch of web sites from one server to another.
This means moving cold fusion, MySQL, qmail, etc.. fun stuff.
What's the best way to move *ALL* of the MySQL databases on my system?
Do I basically just shut down the database, tar up the /var/lib/mysql
directory and move it t
On Tue, 12 Nov 2002, John Chang wrote:
> Is there a good or bad reason to create the config file in the MySQL folder?
IMHO, usually no. But if you have several differently configured server
instances, it might make things more logical.
> On production servers which logs do you turn on?
Error lo
Having just walked into a job a few months back, one of the tasks I've
been asked to accomplish is to counting records inside a DB based on a
field. The database in questions holds realtor listings. There are fields
for Company Name and Agent Name on each listing. What I need to do is sort
reco
* raj
> However, I wish to use this as a security tool. I.e. one in which I (as
> the mysql admin) can do a grant like:
>
> "all queries on a specific table from user "apache" must only return
> 1 record"
>
> This would be like forcing a limit of 1 (using the technique below).
I don't think GRANT
When MYSQL is being heavily used on a windows cpu, In Task Manager does the
memory & cpu load increase show the use for mysqld or another process like
Explorer?
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello!
mysql Ver 11.18 Distrib 3.23.53, for portbld-freebsd4.7 (i386)
I have a problem with dumping data into databases.
I dump the database with mysqldump into a SQL-File.
So, i delete the database. Now i want to redump the SQL-File into database.
SQL tells me an error. The Problem is MySQL doe
Try using mysql_free_result each time after fetching the rows.
SB
- Original Message -
From: "Ganbold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:27 PM
Subject: Help! problem using MySQL C API
> Hi,
>
> I'm having trouble writing dial-up user billing
If you know the primary keys of the two tables, it may be done as follows:
select count(distinct t1.pk1) + count(distinct t2.pk2) from t1,t2;
where - pk1 is the primary key column name of table t1 and
pk2 is the primary key column name of table t2.
SB
- Original Message -
From: "Rick Bara
Greets Folks,
I have been wanting to get into data driven sites for the longest time, and
I can do some immediate level work in them using perl, but my understanding
is still not comprehensive enough for whatever it is I want to do
(subconsciously).
I sense there is some need to pursue databas
Hi,
I'm having trouble writing dial-up user billing software in C using MySQL C
API.
Program suppose to send query to mysql server and retrieve records and
process those.
It sends query for each class_id for every day and get records from
ACCOUNTING table.
While retrieving records it adds user
Hi Ben,
As far as I know the algorithm used for the decrypting is a one-way hash function,
thus there is no way of decrypting it.
You may consider to reset the password and mail the user the new one instead of
mailing the old password.
The second solution is to store the password a second tim
Hello dear Mysql
http://gobrutal.com
dedicated to the beauty of Young Girls. Undoubtedly, this site is the best of its
kind.
We bring you only tasteful high quality fotos & videos of young girls.
Every frame honors purity and innocence of youth involved in sexual acts...
http://gobrutal.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Ben,
From the MySQL man online @
http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 :
PASSWORD() encryption is non-reversible.
To create a forgot your password page, the best method is to generate a net
password a
Hi!
We are using mysql, version 4.0.4 beta on windows 2000 Server.
I packed a table with 100 million rows, using myisampack.
Now queries don't use the index of this table.
It's not possible for me, to work with table scan.
So, what can i do?
Kai
-
All,
I've been having problems with a pretty simple series of SQL statements run
against some InnoDB tables returning the wrong results - temporarily!
Basically, I have one "middle" table that maps a "role" to an "operation"
(many-to-many), and I have separate role and operation tables that conta
1 - 100 of 101 matches
Mail list logo
