MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have a table of information on roughly 150 users. Recently, I have
added a forum (
Dave wrote:
[snip]
The current members tables uses the default PASSWORD encryption built
into MySQL. Although my current MySQL version is 4.1.3, I believe this
is the same password encryption that was used in MySQL 3.2. The user
data was created in an earlier version of MySQL, and later
It did change between MySQL 3.2 and 4.1. You need the old-passwords
configuration directive, it is in the MySQL manual at dev.mysql.com.
Thank you. I believe the old-passwords configuration has already been
set by my web host.
You can't decrypt the password fields. That's the point of
Dave wrote:
[snip]
I believe I will need to use the new password hashing algorithm, because
using the old one would require me to reconfigure the PHP code for the
forum, which would be a level of complexity beyond my capabilities.
So I now understand that I can not decrypt the passwords
No, because that would require MySQL to 'see' the plain text version
of the password. For MySQL to do that, the proces would look something
like:
PASSWORD()ed password --- plain text --- MD5ed password
The first link in that chain is mathematically impossible (even if you
never saw the
Schalk Neethling wrote:
You guys should subscribe to the Planet MySQL RSS feed. The entire issue
was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
Maybe the MySQL AB staff could take the trouble of answering posts
about this issue on this list? Maybe the
We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4
as a slave.
Replication seems to work extremely well, except in the following
circumstance.
On the master server, running a query similar to:
insert into zmast.leagueinfo
(countieslist, defaultleaguecode, leaguename
Hello.
There is no statement which is able to change the collation
and character set information in all tables at once. For single
table use an ALTER TABLE statement. See:
http://dev.mysql.com/doc/mysql/en/alter-table.html
Dave [EMAIL PROTECTED] wrote:
MySQL General List,
Hello.
However, this does not seem to replicate to the slave, and no error shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs? See:
http://dev.mysql.com/doc/mysql/en/slave-logs.html
Hello.
Do you have filesystem quotas enabled on your system?
Bgs [EMAIL PROTECTED] wrote:
Hi all,
We have a problem with our mysql 4.1.11 system. It has been working well
since the installation, we only have one problem. In the case of certain
selects, it always stop
Hi,
There are no quotas at all. The server has been up since march. This is
the first time we had this problem, but now it is consistent...
I run the query and after a few seconds, with about 8-10kB written on
the disk, I get the abort.
Bye
Bgs
Gleb Paharenko wrote:
Hello.
Do you
Hello.
Are you sure that the logging isn't enabled in a different way.
For possible ways to enable logs see:
http://dev.mysql.com/doc/mysql/en/program-options.html
I think I must have had my head screwed on the wrong way round
when I was looking at the log file. I've deleted it now, but
I
Hello
Thank you so much. I Just increase the size of some buffers:
# The MySQL server
[mysqld]
default-character-set = cp1251
port= 3306
socket = /x/xx.sock
basedir = /x
datadir = /x/x
log-error = /x/error.log
log-slow-queries = /x/slow.log
We see that error when we go above the memory limits of a 32 bit
operating system. When we run a 64 bit binary on our 64 bit hardware
we can allocate more memory and it fires up fine.
I'm a Mac guy so your string of letters and numbers describing your
hardware and MySQL version don't mean
Hello.
host when I have hostnames in the 'user' table. It will only
work with ip addresses. (This is where I came in originally).
Are you sure that you're running MySQL without --skip-name-resolve? See:
http://dev.mysql.com/doc/mysql/en/dns.html
I think I must have had my
Hello.
What operating system do you use? `su` to mysql user (I think
the less ugly method should exists) and check if you able to create
big files.
Bgs [EMAIL PROTECTED] wrote:
Hi,
There are no quotas at all. The server has been up since march. This is
the first time we
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for some years now and never really did any
advance stuff in it. I mainly do updates, deletes, and selects. My
selects aren't even that complex as I don't have a very good
understanding of the join syntax and exactly
The DuBois book is a good start: http://www.kitebird.com/mysql-book/
-Original Message-
From: Jay Paulson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 06, 2005 10:56 AM
To: mysql@lists.mysql.com
Subject: Newbie needs info!
Hi everyone,
Long time reader, first time
On Tue, 6 Sep 2005 10:58:28 -0500, John Trammell
[EMAIL PROTECTED] said:
The DuBois book is a good start: http://www.kitebird.com/mysql-book/
This might be too basic but it's really clear:
http://www.w3schools.com/sql/default.asp
-Original Message-
From: Jay Paulson
Hello All,
I am downloading and installing the Installer package (Mac OS X v10.3)
from the mysql site.
I am installing on a OSX 10.4 machine, at the end of the install I get an
error message saying
The application MYODBCConfig quit unexpedically after it was reopened, max
OSX and other
Is there a way to rename an index without droping it?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7
Jason,
The only way that I can think to do this is the change its status as
a primary key field...
Once you do that, you can rename the field, and then reinitiate it as
a primary keyfield.
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
- Original Message -
However, this does not seem to replicate to the slave, and no error
shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs?
The hint was what I needed, Gleb. Spasibo. It turns out that the
I do not want to change any details about a field.
I only want to rename an index. The index is not involved in a PRIMARY
key, albeit the index in question is a UNIQUE key.
On Tue, 6 Sep 2005, m i l e s wrote:
Jason,
The only way that I can think to do this is the change its status as a
Jay
There's a short list of SQL relational tutorials at
http://www.artfulsoftware.com/dbresources.html, and of a few MySQL
resources at http://www.artfulsoftware.com/mysqlinfo.html.
PB
Jay Paulson wrote:
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin process
You can log on to your mysql server and run:
show full processlist;
That should give you what you are looking for.
-m
On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing
Thanks Michael,
but it now seems that on prepared selects, the values are still place
holders, whilst on prepared inserts they are substituted in.
Does anyone know how to address this issue?
Hi,
Given two dates, can Mysql calculate and return all the dates that occur
between them?
Thanks for your advice.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 20:47 +0100 9/6/05, Shaun wrote:
Hi,
Given two dates, can Mysql calculate and return all the dates that occur
between them?
No.
Given two dates, MySQL can determine which of a set of already-existing
dates stored in a table occur between them and return those.
--
Paul DuBois, MySQL
Shaun [EMAIL PROTECTED] wrote on 09/06/2005 03:47:25 PM:
Hi,
Given two dates, can Mysql calculate and return all the dates that occur
between them?
Thanks for your advice.
Given any two dates, MySQL can tell if a third date is within that range.
That's easy.
To actually return
there is an unique key index 'pathref_2 (pathref,version)' on this table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I can rewrite the query, but for reasons out of my control I have to
design a query which takes single value for a
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never seen this syntax used in a where
On Tue, 6 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never
Here's the situation. I have a table of about 900 million rows, consisting
of a bigint and an int in each row. There's an index on the bigint. The
table is referenced in a SELECT in other DB operations roughly 15 or 20
times per day.
We're under tight deadlines and some operations on the
INNODB I assume?
Replicated environment?
What version of mysql?
See KILL in the SQL manual.. if you do a show processlist you can get the
pid and you might be able to kill it.
I believe that it's safe to do a KILL on an DELETE but any decision you make
her is your own...
That's a LOT of
Thanks for the questions, hopefully this will help: InnoDB, yes. It's
version 4.1.11, not replicated.
I am familiar with KILL. It is definitely something I CAN do, but not
necessarily something I SHOULD do at this point in time. Usually when you
kill a process while it's running, it will roll
hi all.
i've installed MySQL database server 4.1.14 under linux platform
After setting up the server successfully, i envoked mysqladmin, but
what i got is an error: can't connect to local MySQL server through
socket '/tmp/mysql.sock'(111)
is there anyone who ever run into similar problem and how
Hi,
i've got the same kind of problem but not in a dump, in a restore. I
tried to restore it in a MyIsam type table but i have the same error.
Could other server variables interfer in this ? For example, i see
that my long_query_time is set to '10' ...
--
Christophe Charron
PROLOGIQ
7 bis Rue
i recall i've managed to set up a connection to MySQL server using
account root with the password item blank in Kdevelop. when i
invoke mysqlaccess -uroot -p, it returned a prompt for password, i
just hit return, but failed this time. mysqladmin -uroot got the same
suituation with the error 111.
/usr/local/mysql--
On 9/7/05, Gu Lei [EMAIL PROTECTED] wrote:
王静 写道:
hi all.
i've installed MySQL database server 4.1.14 under linux platform
After setting up the server successfully, i envoked mysqladmin, but
what i got is an error: can't connect to local MySQL server through
socket
41 matches
Mail list logo