[snip]
From: Jonas Larsson [EMAIL PROTECTED]
But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why
isn't that implemented? Then it would be easy to transfer the hash...
Yes it definitly would be nice and would have been easier to impliment than
the current Password()
Hi all,
Can anyone point me to a good Macromedia Ultradev Extension for live
connection to MySQL?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I have recently started using mysql and php. I have created sample databases that are
working well. My problem came when I started using PHP. My php scripts are being
executed, the pronlem comes when I use the function mysql_connect to connect to any of
my databases. It returns the folowing
On Mon, Sep 17, 2001 at 01:02:50AM -0700, francis jeffrey wrote:
I have recently started using mysql and php. I have created sample
databases that are working well. My problem came when I started
using PHP. My php scripts are being executed, the pronlem comes when
I use the function
But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX?
Why
isn't that implemented? Then it would be easy to transfer the hash...
Yes it definitly would be nice and would have been easier to impliment than
the current Password() implimentation (just call crypt()!!). I found
Hi,
I've put here this my problem, but without an answer.
If I (admin1) have all privileges with grant option on database 'db1' and
no privileges in 'mysql', why this does not work
mysql grant all privileges on db1.* to aaa@localhost identified by 'aaa';
ERROR 1044: Access denied for user:
Hello people,
mysqldump not dumps MERGEd tables structure
it writes TYPE=MERGE and then UNION() with empty parenthesis
so this dump can not be used.
--
Best regards,
Pedro mailto:[EMAIL PROTECTED]
I want to import tables from MS-Access to My-SQL.
Please help me out
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I do it by setting up a MyODBC databsource which points to my MySQL database
and then export each MS-Access table to that ODBC datasource. It works fine
except that it does not do primary key and index definitions (as far as I
have been able to tell) and things like setting auto_increment on for
Hi!
On Sep 13, Doug Poland wrote:
One question per line, please !
Problems is knowning how many columns can be indexed in a table.
max 16 columns per index.
max 32 indexes per table.
so 16*32=512 columns can be indexed in a table, which is less then
max 3398 columns per table.
Is that
Hi!
On Sep 15, [EMAIL PROTECTED] wrote:
Hi list,
I have a question that hopefully someone can help me with.
We have a mysql database which contains 3000 records, and these records need
to be searched.
The table has 4 fields which need to be searched, so we created a full text
Hi group
Access has a datatype (I don't remember the name) which is a kind of boleaen; it
represents Yes/No, true or false. When I try to translate that creating a table in
MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y
then...(ASP). Do I use ENUM right? I have
Ann Myhre wrote:
Hi group
Access has a datatype (I don't remember the name) which is a kind of boleaen; it
represents Yes/No, true or false. When I try to translate that creating a table in
MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y
then...(ASP). Do I use ENUM
This is something that has me stumped..
I have a table as follows
EndAEndB
A B
A C
B C
C D
A E
D E
Imagine this as a table that describes potential links across a phone
network. Now supposing I wish to connect from point A to point
[reaction on joe kaiplings message]
hello Joe,
I'm trying to contact you but my emails to you our bounced each time. Please
give me a valid email address so I can answer your questions in the email you
sent me 10-9.
regards
Rick van Dijk
Datanamic
http://www.datanamic.com
Joe Kaiping schreef:
[EMAIL PROTECTED] writes:
If I (admin1) have all privileges with grant option on database 'db1' and
no privileges in 'mysql', why this does not work
mysql grant all privileges on db1.* to aaa@localhost identified by 'aaa';
ERROR 1044: Access denied for user: 'admin1@localhost' to
Chris Thorpe writes:
My question is how do I query the database to return a valid route(s)
supplying only a start and end point.
ie SELECT !!route!! WHERE start=A and end=D,
Personally I don't see how this is possible without code, hence why I am
querying the brains of the world!!!
I am running MYSQL 3.23.36 on windows NT. I am not
able to connect to the server through a C program
using mysql_real_connect() from another computer. The
other computer is running on Windows 98. My
permissions are alright and I am able to connect to
the server interactively through the
As root:
chown -R mysql /usr/local/mysql
Fernando da Motta Hildebrand wrote:
I can´t start Mysql (I use Slack and compiled mysql). I´ve
followed all instructions in INSTALL text, and i´ve got this in the .err
file:
010914 16:19:02 mysqld started
010914 16:19:02
At 8:27 AM + 9/17/01, Jonas Larsson wrote:
But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why
isn't that implemented? Then it would be easy to transfer the hash...
Yes it definitly would be nice and would have been easier to impliment than
the current Password()
I just upgraded to latest mysql. there was an error when starting the demon
or using the client about not finding the socket file.
i found it in /tmp/mysql.sock and moved it to the directory where it was
looking for it. /var/lib/mysql/mysql.sock
now i get :
ERROR 2002: Can't connect to local
2. Is it possible to let the users by them self change their
password? Then they could change it to their UNIX-password. As far
as I know only the MySQL admin can change the users passwords. :(
Yes, that's possible. The user connects and issues this command:
SET PASSWORD = PASSWORD('new
when installing with rpm i get:
Number of processes running now: 2
mysqld process hanging, pid 30887 - killed
mysqld process hanging, pid 30886 - killed
010917 16:04:06 mysqld restarted
/usr/bin/safe_mysqld: line 273: 30916 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD
$defaults
Hi Bob!
I use Caldera Linux and have a 4 machine LAN.
The Lan includes 3 Linux and 1 WinNT install.
Now, no matter what I do safe_Mysqld continues to start
version: 3.22.32-log ..
This is more of a *nix question than a mysql question but whatever. :) I
use redhat but the concepts are the
Description:
Can't delete from incredibly fat table. When I attempt to delete from table rCamDom in
my database, I get an error: ERROR 1030: Got error 22 from table handler. This table
is *huge*, biggest one in my database, other deletes work fine.
The table entries begin on Jan 1, 2001. When I
SELL YOUR PRODUCTS AND MAKE
'BIG MONEY' $$$ WITH OUR EMAIL ADDRESSES
1) Let's say you... Sell a $24.95 PRODUCT or SERVICE.
2) Let's say you... Broadcast Email FREE to 500,000 PEOPLE DAILY.
3) Let's say you... Receive JUST 1 ORDER for EVERY 2,500 EMAILS.
CALCULATION OF YOUR EARNINGS BASED ON
Mike wrote:
In working with some non profit groups I need to be able to send a complete
program that is installed and ran fairly easy.
To me MySQL is easy in most cases but to someone not familiar with it it can
be a daughtening task. Is there a way to send a setup program using MySQL?
Most
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (0.92) of MySQL Manager --
A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version
Hi Siva,
Were you trying to install from the soure code downloaded from
mysql.com? Or are you using the ports collection (ie
/usr/ports/databases/mysql ) to install? Because if you are
installing fron the download you need to remember to use gmake not
BSDi make.
Ken
- Original Message -
It certainly does seem that 3.23.40+ take considerably more resources to do
the exact same thing, than MySQL 3.22.xx
Is this correct?
On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote:
So what your saying is MySQL is supposed to fork a new processes for
every
On Monday 17 September 2001 08:59, powlow wrote:
when installing with rpm i get:
Number of processes running now: 2
mysqld process hanging, pid 30887 - killed
mysqld process hanging, pid 30886 - killed
010917 16:04:06 mysqld restarted
/usr/bin/safe_mysqld: line 273: 30916 Segmentation
Ok... this is getting out of hand. Is it just me or are we getting a posting
every week on this?
Please keep these postings to majour releases (1.0, 2.0, etc)... at most.
Post your minor releases to your own mailing list.
This is a relevant product but we do not want to pollute the list.
No problems here, Possibly mailing list issues?
Peter Harvey wrote:
Ok... this is getting out of hand. Is it just me or are we getting a posting
every week on this?
Please keep these postings to majour releases (1.0, 2.0, etc)... at most.
Post your minor releases to your own mailing
On Mon, Sep 17, 2001 at 10:03:29AM -0700, Michael McConnell wrote:
It certainly does seem that 3.23.40+ take considerably more
resources to do the exact same thing, than MySQL 3.22.xx
If that's the case, it's worth tracking down so that it can be fixed.
Is this correct?
I hope not.
Jeremy
I can run safe_mysqld as user MySQL to start the mysql daemon.
However, when I try to use safe_mysqld as user root, I get the
message, Can't change to run as user 'MySQL'. Any hints much
appreciated. Thanks in advance.
-
Hello Chris!
I can run safe_mysqld as user MySQL to start the mysql daemon.
However, when I try to use safe_mysqld as user root, I get the
message, Can't change to run as user 'MySQL'. Any hints much
appreciated. Thanks in advance.
From rc.local:
su - mysql -c
Can someone tell me how to reset a column's auto_increment starting point
back to 0 in mysql ?
Thanks
Paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello root!
Description:
Can't delete from incredibly fat table.
Synopsis: unable to delete table data, running out of disk space for it!
Well, that pretty much wraps it up, doesn't it? This is a hardware
problem, not a software problem.
The software must read the old table and create
Dear Sirs,
I have a database with a lot of information. Can I copy that information to
another server??? It's because I'm gonna change of hosting company!!! (I use
PHP and Perl)
Thanking in advance,
Nuno Lopes
P.S.: When you reply to the list, reply to me too, Thanks!
Can someone tell me how to reset a column's auto_increment starting point
back to 0 in mysql ?
Thanks
Paul
According to Paul DuBois on page 169 of MySQL by New Riders (which you
should buy):
ALTER TABLE t
DROP i,
ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY
Jay
Dear Sirs,
I have a database with a lot of information. Can I copy that
information to
another server??? It's because I'm gonna change of hosting
company!!! (I use
PHP and Perl)
Thanking in advance,
Nuno Lopes
MySQLDump is what you need, and is quite well documented (many examples
I have a table with about 3.5 million records with a fulltext index on text
field of about 90 characters.
This has name and address data I'm trying to match against a dirty input
string. I've recompiled
with the following changed in ft_static.c.
ft_min_word_len=2 /* I want to find words like
At 3:15 PM -0400 9/17/01, Jay Fesco wrote:
Can someone tell me how to reset a column's auto_increment starting point
back to 0 in mysql ?
Thanks
Paul
According to Paul DuBois on page 169 of MySQL by New Riders (which you
should buy):
ALTER TABLE t
DROP i,
ADD i INT
I need to convert from Mysql to access for testing reasons.
when I do the Mysql dump it either gives me the query code or it saves a
file with .sql extension.
how do I get this information into access?
I wish I could but can not connect direcly to the mysql server cause of the
way the hoster
Hi!
Dana == Dana Powers [EMAIL PROTECTED] writes:
Dana Certainly I understand how the deadlock can occur, but the question is why
Dana is this acceptable behaviour? Is the application developer expected to
Dana handle this case? If so, how? and shouldnt this be included in the manual
Dana
Troy,
Have you considered MyODBC? Access works well with linked ODBC tables. Then, within
Access, you can copy the linked table into an Access table.
Hope this helps!
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
Troy Montour [EMAIL
Thanks for the reply! I can understand the situation with muti statement
transactions, but I'm not using transactions ( at least from my
perspective ); Im only issuing single 'atomic' statements. It would make
much more sense if mysql internally detected the deadlock, released the
locks and tried
Hi!
On Sep 17, Boris Cownie wrote:
select count(*) from table match field against ('word1')
select count(*) from table match field against ('word2')
select count(*) from table match field against ('word2')
... etc ..
The bad news is even these are slow if the word is common WHY ?
The
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the
I need to insert a phone number into a table. I would do this with the
insert command except I think that it would create duplicate entries even
though they are exactly the same is there a way that I can have it not enter
the data if it exists already
TIA
Armando
At 5:34 PM -0700 9/17/01, Armando Cerna wrote:
I need to insert a phone number into a table. I would do this with the
insert command except I think that it would create duplicate entries even
though they are exactly the same is there a way that I can have it not enter
the data if it exists
I understand everything you said except primary key do i need one I have seen
it before in some fields but have no clue what it is... thanks btw =)
Armando
On Monday 17 September 2001 05:44 pm, you wrote:
At 5:34 PM -0700 9/17/01, Armando Cerna wrote:
I need to insert a phone number into a
At 5:54 PM -0700 9/17/01, Armando Cerna wrote:
I understand everything you said except primary key do i need one I have seen
it before in some fields but have no clue what it is... thanks btw =)
All the more reason to consult the manual! :-)
Armando
On Monday 17 September 2001 05:44 pm, you
I was running a mySQL server under slackware for a while, it was
interacting with php on an apache webserver, and everything worked fine.
There were a few times where I would mess linux up and need to re-install,
in which case I would move my database files to my windows partition,
re-install
I must be a moron but I can't seem to figure out what I need to do to get
mysql to work on RH, on Mandrake it just worked straight away.
I read and followed the instructions in the INSTALL-BINARY (inspite of the
fact that the way red hat installed mysql does not even closely resemble the
Here's what I'm doing. Appently something is going wrong but I am missing
exactly what.
Any suggestions?
Martin
mysql INSERT INTO user (Host,User,Password)
VALUES('%','chimbis',PASSWORD('pompeji'));
Query OK, 1 row affected (0.00 sec)
mysql GRANT USAGE ON *.* TO chimbis@% IDENTIFIED BY
Hi, Heikki.
Thanks for the info.
I understand your first explanation, I'll try.
You can probably circumvent the problem by
adding an extra VARCHAR column where you put
the first 255 characters of the blob column.
Would you please inform me more externation of second.
Can you give me an
7 days are now over
dear God take the souls of the inocent in thy hands.
there is only one question to be answered
Who was the man in the back ground ???
Who payed the for the atak of terrorism ???
the one to put the mony for killers, who was it ???.
The one will now have to pay with somthing
7 days are now over
dear God take the souls of the inocent in thy hands.
there is only one question to be answered
Who was the man in the back ground ???
Who payed the for the atak of terrorism ???
the one to put the mony for killers, who was it ???.
The one will now have to pay with somthing
Hi
I am new to My SQL and have just installed it on a Win 98 machine. can you
recommend any good front end tool to generate reports ? At present the
interface available for both input and output is phpAdmin. Also how does one
import data from excel; is it possible ?
ans
Hi,
Does MySql support Synchronous or asynchronous I/O or
both?
What do they mean when they ask me if
- copy Db is supported by mysql?
- version db is supported by mysql?
- Sync/Async write strategies?
Currently I have been asked to evaluate mysql against
TimesTen. Is there such an comparision
Some people like to use MS Access as a frontend using MyODBC to 'link
tables'. If you have access, you'll need to install myodbc ( available in
the downloads section of www.mysql.com ), configure a datasource connection
with a valid username + password etc, and then in access:
File - Get
It appears that your change to debian was also a change from the current
3.23 mysql version to the old 3.22 version ( major releases ). The old
version, 3.22, does not support MyISAM tables, so you'll need to upgrade to
the new version. Debian stable, aka potato, uses 3.22, but both woody + sid
(
The error logs seem to indicate that the pid file you've specified is not
writable and that the system database tables are not installed properly.
1. make sure that you ran mysql_install_db. If you did, make sure that you
didnt change the my.cnf datadir setting without moving your system files
65 matches
Mail list logo