I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the
passwords end up being like
I'm running into a problem with a ratings script I'm writing. The
overview is that a user can rate an item from 1-10. What I want it to do
is display the highest rated item, with 10 being the highest rating. In
case there are multiple items sharing the same score, the item that has
been rated t
hould find and edit
table where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I hope)..I have a database
that has a field in it that autoindexes the number. I screwed up and
imported a bunch of wrong data. Up to row 200 it's right, beyond
that
Hey, I have a really simple question (I hope)..I have a database that
has a field in it that autoindexes the number. I screwed up and imported
a bunch of wrong data. Up to row 200 it's right, beyond that it was
wrong so I had delete it all. The problem now is the autoindexing is set
to 1105, I
How would I do that? I'm still a novice when it comes to many aspects of
mysql.
[EMAIL PROTECTED] wrote:
Hi,
Try to enable query log.
Thanks & Regards
Dilipkumar
[EMAIL PROTECTED]:
Hey there, I inherited a couple of servers that are in production but I
noticed that there\'s not activ
Hey there, I inherited a couple of servers that are in production but I
noticed that there's not active logging for mysql on any of them. I
looked and they don't have an active my.cnf file any where on the
machines. One machine is running mysql 4.1.5 and the other is running
mysql 5.0.18
When
I have a small question about the DATE function. This is what I want to do:
- User enters information into form and submits it to database
- When info is added to database the current date is stored ala 2003-03-26
- Now I want to take that date 2003-03-26 and tack on either 15 or 30 days
on to it
I'm looking for a webbased interface that will allow me to managae mysql
databases. However, phpmyadmin has been ruled out due to the fact it
requires the username and password to be stored in the config file and
that it doesn't have any security to protect the average joe from
stumbling across it.
considerations would kick in for anything
> beyond TEXT (max 65535).
>
> So I'd probably go with the LONGTEXT, too.
>
> HTH,
> Tore.
>
> - Original Message -
> From: "Tom Ray" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: W
Hey there, I'm kinda new to using mysql to its full potential and I was
wondering something. I want to store resume information, but I just want
the user to cut and paste the resume in the "Resume" field and then store
all that in one column in the table. Which table type should I use for
this? Lo
I just got a Red Hat 7.3 box up and running and have mysql on it...I've
noticed that when using mysqladmin it doesn't prompt me for a password
like other boxes that I've been on(ones I didn't build) have...is there
a way to set this?
TIA
---
IVILEGES?
>
>-Original Message-----
>From: Tom Ray [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, 10 January 2002 2:07 PM
>To: [EMAIL PROTECTED]
>Subject: Problems with User logins.
>
>
>I'm kinda new to mySQL and I set up a user (myself) and a database for
>myself on ou
I'm kinda new to mySQL and I set up a user (myself) and a database for
myself on our webserver at work. I did the "insert into" into the User
table and the Db table. However, when I try to log into the database I
get errors. I go to my mysql path on the machine and do:
./mysql -u username -p d
13 matches
Mail list logo