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 into
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 *one
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 the
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 ( "Simp
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 database of users for my web site, in which all the text
data that is inserted a
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/
The argument is given that this is all about helping out the SCO users.
A counter argument is that by doing so
something along the lines of:
mysql> select * from where = lock in share mode
On Sep 5, 2005, at 4:01 PM, Rich wrote:
Hi there.
I am looking for the syntax to lock individual records in an InnoDB
table.
I can't seem to find anything outside of locking full tables.
Rich Allen
A kidn
Hi there.
I am looking for the syntax to lock individual records in an InnoDB table.
I can't seem to find anything outside of locking full tables.
Any urls out there?
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
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/
Rich Allen wrote:
On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote:
This is the part that gets me:
As part of the agreement, the com
On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote:
This is the part that gets me:
As part of the agreement, the companies will work together on a
range of joint marketing, sales, training, business development
and support programs that will benefit customers throughout the
Americas, Euro
Mirza wrote:
I would like someone from MySQL AB to clarify issue with SCO asap. I
wouldn't like to use technologies for my business that later could be
used against me (in legal sense). Does MySQL AB understand that it
helps funding their legal cases against us (GPL users) ? If someone
feel
Here is the official link:
http://www.sco.com/products/openserver6/mysql.html
SCO states that they will distribute MySQL with a commercial license.
According to this they do not plan to stick with GPL...
Bye
Bgs
[EMAIL PROTECTED] wrote:
__
Mirza <[EMAIL PROTECTED]> wrote
On Mon, Sep 05, 2005 at 11:00:43AM -0700, Karam Chand wrote:
> First all it is not recommended at all to dump and
> import user information.
Why not? They are just entries in a database, like any other. How
would you propose I move a large batch of users to another database
server?
> Secondly
On Mon, Sep 05, 2005 at 12:41:50PM +0300, Gleb Paharenko wrote:
> Hello.
>
> Have you run 'FLUSH PRIVILEGES'?
Doh! I got everything else find, but forgot something stupid.
Murphy's law, I suppose.
Thanks for the prompt!
Ross
--
MySQL General Mailing List
For list archives: http://lists.mysql
I have been using SQLyog's ODBC Import tool for quite
some time now.
http://www.webyog.com
Karam
--- "Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
>
> Look at http://www.ispirer.com
>
> It is free and very good tool to do it. I did it
> from Oracle to MySQL, but
> you can do it from Mysql to ora
Hello,
First all it is not recommended at all to dump and
import user information.
Secondly the user authentication system has changed
between 4.0 and 4.1 so old passwords from 4.0 wont
work. Its given in the docs.
Thirdly, MySQL does not store the actual password in
its database. It always kee
To test the char vs byte index I created a unique bcol(2), on a tiny text
utf8 field.
I then preceded to insert the numbers 00..99 in Chinese whose hex values
are below. Since we are using utf8 vs ucs2 they are going to be 3 bytes
per char, totaling 6 bytes per numbers.
If the index is ind
>
> Hello.
>
> I don't know. You may want to hack MySQL source (it seems not
> too hard to change the dbug/dbug.c file). As an alternative you can
> make a feature request at:
> http://bugs.mysql.com
>
Done. Thank you.
>
> In my opinion, timestamp is a helpful thing (however, it may af
Chris et al -
The MySQL online manual does show *.* to be used for global priviledges,
but my MySQL book only used the *. My mistake! However, the online
manual does not indicate (or I am missing it) what the use of * grants.
Thank you for the help...it is now working and my DB, "sfyc" does
Hello.
I don't know. You may want to hack MySQL source (it seems not
too hard to change the dbug/dbug.c file). As an alternative you can
make a feature request at:
http://bugs.mysql.com
In my opinion, timestamp is a helpful thing (however, it may affect the
performance which is already
Hello.
> "Fulltext initialization"
Ok, now we exactly know that we should optimize the FULLTEXT part
of your query. I don't know the options which directly affects the speed
of the FULLTEXT searches, so I suggest you to play with key_buffer and
table structure. The ratio of Key_reads to Ke
Hello.
> grant all on * to todd identified by 'my_password' with grant option;
May be you wanted '*.*' instead of '*'? See:
grant all on *.* to todd identified by 'my_password' with grant option;
> mysql -u todd -p sfyc
You should specify the database name not a table name ('sfy
Did you run the statement witht he mysql database as the current
database? If so , you're statement probably got converted to this:
grant all on mysql.* to todd identified by 'my_password' with grant option;
It seems like a logical thing
The grant statement applying to all databases/tables sho
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 with "Sort aborted" error. To the client it
returns errors like "ERROR 3 (HY000): Error writing file '/tmp/MYFh2O
I have created a table, "sfyc" and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, "todd" cannot access "sfyc" with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
+---+--+
| host | user
__
Mirza <[EMAIL PROTECTED]> wrote on 05/09/2005 14:31:12:
>
> I would like someone from MySQL AB to clarify issue with SCO asap. I
> wouldn't like to use technologies for my business that later could be
> used against me (in legal sense). Does MySQL AB understand that it hel
Hi,
Ok. Is there a way to get a timestamp in the file too? If
this happens while I'm not near a machine I want to make sure I can
find the right time frame in the file.
Thanks, Tuc
>
> Hello.
>
> When I suggested to create a trace file, I wanted to find the place
> wher
I would like someone from MySQL AB to clarify issue with SCO asap. I
wouldn't like to use technologies for my business that later could be
used against me (in legal sense). Does MySQL AB understand that it helps
funding their legal cases against us (GPL users) ? If someone feels OK
with SCO p
Hello
GP> What state is SHOW PROCESSLIST reporting for this query?
"Fulltext initialization"
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
--
MySQL General Mailing List
For l
Hello.
When I suggested to create a trace file, I wanted to find the place
where mysqld hangs. In my opinion, it is possible. You should
research the last entries at the end of the trace file (using tail,
for example) after mysql has hung. I'm not sure if we are able to find
any clues in th
Hello.
I'm not familiar with this subject, however, have you been at:
http://dev.mysql.com/doc/mysql/en/howto-cf.html
http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html
http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html
http://www.ma
Hello.
Please, start a new thread when you're asking a different question.
In my opinion, it is safer to restore an archive into the datadir
of 4.0.23 server. Then perform a dump using mysqldump utility
and finally import it to the new 5.x instance. I suggest you to
read this page before
Hello.
If you think that it is possible to have several records with the same
post and title, then, in my opinion, your table should have two indexes for
foreign key constraints and one AUTO_INCREMENT field for primary key.
mysql> show create table titles_posts\G;
*
Hello.
Maybe this could help you somehow:
http://bugs.mysql.com/bug.php?id=12191
Check that you are running the latest release.
Nico Grubert <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I am running MySQL 4.1 on Linux.
> I have some problems sorting records with german umlauts.
>
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
What version of MySQL are you running?
"T. Horsnell" <[EMAIL PROTECTED]> wrote:
> Someone kindly replied to my log qu
Hello.
At first, we should ensure that most time query is spending in the
ordering of the results. What state is SHOW PROCESSLIST reporting
for this query?
Michael Monashev <[EMAIL PROTECTED]> wrote:
> Hello
>
> GP> And MySQL uses a filesort algorithm.
>
> How to make the filesor
Hello.
Have you run 'FLUSH PRIVILEGES'?
[EMAIL PROTECTED] wrote:
> On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote:
>> Now I have all the users in the new mysql.user table. But when I try
>> to login, the same credentials do not work.
>
> A bit more info on this. T
37 matches
Mail list logo
