a Cymbalista wrote:
>>We have just moved to a new web server where we are running mysql
>>version: 5.0.45
>>On the old machine, when we gave the following command:
>>update table1 set passwd = password('xx') where user_name="xx";
>>
>>and th
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote:
We have just moved to a new web server where we are running mysql
version: 5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name="xx";
and then gave t
PS, the document I send you also mentions:
To change the password but create a short hash, use the OLD_PASSWORD()
function instead:
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
ht
>Thanks. So how does one use the password function in MySQL 5?
Most probably just the same, but your MySQL 4 password hashes are
incompatible
with MySQL 5 password hashes.
A search on "password" in the MySQL docs returns quite some stuff, see:
http://dev.mysql.com/doc/refman/5.0/en/password-hash
Thanks. So how does one use the password function in MySQL 5?
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
>>> On 4/9/2008 at 2:57 PM, in message <[EMAIL PROTECTED]>,
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
>> Thanks for the email but that didn
>Thanks for the email but that didn't help. I gave the commands again using
only single quotes and I still get no results.
>On the old machine we were running MySQL 4.0.15a. Is there any difference
with the password function in these 2 versions?
Could be, I remember MySQL 4.1 having a new passwo
Thanks for the email but that didn't help. I gave the commands again using
only single quotes and I still get no results.
On the old machine we were running MySQL 4.0.15a. Is there any difference
with the password function in these 2 versions?
--
Malka Cymbalista
Webmaster, Weizmann Institut
>Thanks for the answer but that's not it. It was my typo. I am really
updating and selecting from the same table.
Perhaps "not it" either, but strings should be in single quotes, not double
quotes.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
htt
"Edward Kay"
<[EMAIL PROTECTED]> wrote:
>> We have just moved to a new web server where we are running mysql
>> version: 5.0.45
>> On the old machine, when we gave the following command:
>> update table1 set passwd = password('xx') where user_na
> We have just moved to a new web server where we are running mysql
> version: 5.0.45
> On the old machine, when we gave the following command:
> update table1 set passwd = password('xx') where user_name="xx";
Here you're updating 'table1'...
&
We have just moved to a new web server where we are running mysql version:
5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name="xx";
and then gave the following command,
SELECT user_name FROM alon_
On Wed, 2006-10-11 at 13:12 -0500, Peter Brawley wrote:
> >Still don't get it
> Did you read the section of that manual page headed "Join processing
> changes in MySQL 5.0.12"? It explains why and how to rewrite all such
> queries using explicit JOIN ... ON | USING syntax.
>
This works in 4.x but
>Still don't get it
Did you read the section of that manual page headed "Join processing
changes in MySQL 5.0.12"? It explains why and how to rewrite all such
queries using explicit JOIN ... ON | USING syntax.
PB
-
[EMAIL PROTECTED] wrote:
Still don't get it
:(
Hi,
Take
Still don't get it
:(
> Hi,
>
> Take a look at the answer written by Peter Brawley to Jason Chan at Oct
> 10, 2006, ~04:34 PM. Answer included below:
>
>> Jason
>>
>> following statement works in 4 but not 5
>>
>> SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
>> cat_state, c
Hi,
Take a look at the answer written by Peter Brawley to Jason Chan at Oct
10, 2006, ~04:34 PM. Answer included below:
Jason
following statement works in 4 but not 5
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
cat_state, c.name as cat_name, c.description as cat_desc,
hi,
currently using mysql 4.0.18. want to move to 5.0 (latest stable version
for commercil use). is there anytihng I have to be considered DB will not
work?
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
_CACHE
to query in smack's file to disable the influence of query cache (it's
present in my-large.cnf) and compare results again.
Oleg Rusanov <[EMAIL PROTECTED]> wrote:
> Hello.
> my-large.cnf is twice quicklier, but the description from
> my-medium.cnf is approach
Hello.
my-large.cnf is twice quicklier, but the description from
my-medium.cnf is approaches (such as a web server).
It is necessary that Mysql worked twice more slowly on a web server?
amd64# uname -r
5.4-STABLE
make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install
Chip Wiegand wrote:
John,
Yep, looking at phpinfo.php shows no support for mysql. This is very
strange. I know these things don't just happen by themselves. I also know
there are only two people with the password to the server, myself and my
boss (and he knows nothing about the server to begin
I
hope not.
--
Chip
> On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
> > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
> > freebsd-5.1.
> > It has been working fine for the past few years, now all of a sudden
today
> > I get an
It sounds like someone upgraded your PHP libraries, and forget to include
MySQL support. Do you admin this server, or does someone else?
j- k-
On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
> I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4
"John W. Holmes" <[EMAIL PROTECTED]> wrote on 05/03/2004 10:59:15
AM:
> From: "Chip Wiegand" <[EMAIL PROTECTED]>
>
> > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
> > freebsd-5.1.
> > It has been working fine for
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
freebsd-5.1.
It has been working fine for the past few years, now all of a sudden today
I get an undefined function error. This is from httpd-error.log -
PHP Fatal error: Call to undefined function: mysql_connect() in
For my Cobalt server, I just d/l th mysql build from the Cobalt website
(which is now @ sun.com) . And it worx just fine.
Saqib Ali
-
http://www.xml-dev.com
On Thu, 17 Jul 2003, Clint S. Jones wrote:
> What type of MySql can I install on a cobalt web server??? Please help...
Jul 2003, Clint S. Jones wrote:
> What type of MySql can I install on a cobalt web server??? Please help... not
> sure...
>
>
>
> Clint S. Jones
> Computer Teks, Inc.
> President
> 1520 East Sunrise Blvd.
> Suite: 202
> Fort Lauderdale, FL 33304
> (95
What type of MySql can I install on a cobalt web server??? Please help... not sure...
Clint S. Jones
Computer Teks, Inc.
President
1520 East Sunrise Blvd.
Suite: 202
Fort Lauderdale, FL 33304
(954) 465-5516
(954) 767-6150 fax
[EMAIL PROTECTED]
www.webingenuity.net <h
> Hi, I'm a MySQL newbie - Is there a "MySQL Web Server"
> product ? Oracle has their OWS (Oracle Web Server)
> for example.
>
As far a I know this is based on Apache.
Of course it takes Oracle weeks to update it after
a security vulnerability is exposed, whereas if
The one and only Apache web server
> Hi, I'm a MySQL newbie - Is there a "MySQL Web Server"
> product ? Oracle has their OWS (Oracle Web Server)
> for example.
>
> Can anyone reccomend a *very* lightweight web server
> with enough scripting ability to talk t
Hi, I'm a MySQL newbie - Is there a "MySQL Web Server"
product ? Oracle has their OWS (Oracle Web Server)
for example.
Can anyone reccomend a *very* lightweight web server
with enough scripting ability to talk to MySQL -
preferably f
Search the MySQL list, http://lists.mysql.com/php/search.php for "ram
needed", there are some pretty good references there as to what the
footprint of MySQL is.
>>> Simon Green <[EMAIL PROTECTED]> 10/22/02 02:59AM >>>
Hi
I am putting together a MySQL server for the ISP I work for. We are
going to
Hi
I am putting together a MySQL server for the ISP I work for. We are going to
provide a mysqld for each web user.
I plan on using mysqld_multi for this. But what I can not work out is how
much CPU and memory I will need for each user.
As this is a generic system all I need is a average system!
> -Original Message-
> From: Nestor [mailto:[EMAIL PROTECTED]]
> Sent: 08 October 2002 16:01
> To: [EMAIL PROTECTED]
> Subject: Reposting: Connecting a web server to a db server
>
>
> Any ideas?
>
Have you reloaded the mysql server?
Try this at the shell...
m
Sorry or posting this again, but I have try everything
I could think and I am getting no where.
I have a webserver(10.1.1.3) running Linux RH7.3 with
PHP4.2.3 and a DBserver(10.1.1.2) running W2K and MySQL 3.23.52
The user mbn has select and insert permissions:
grant select, insert on database
Nestor,
Tuesday, October 08, 2002, 12:58:25 AM, you wrote:
NF> OK now I am getting this error:
NF>
NF> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
NF> /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36
NF> Warning: MySQL Connection Failed: Acce
OK now I am getting this error:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /usr/local/htt
I messed up in the ip addressing sorry!
--
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);
And I ge
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to MySQL serv
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to
I have installed the php-mysql package and can now connect to the database.
There is however another error which I do not undertand.
Warning: No MySQL-Link resource supplied in
/usr/local/www/vantweststamps/databaselogin.php on line 15
Connected successfully
,Line 15 is
mysql_close();
If I the
"Peter Goggin" <[EMAIL PROTECTED]> writes:
> So far as I can tell the mysql files included in the CD set are:
> mysql-3.23.49-3.i386.rpm
> mysqlclient9-3.23.22-6.i386.rpm
> mysql-devil-3.23.49-3.i386.rpm
> mysql-server-3.23.49-3.i386.rpm
>
> Do these files include Innodb support?
Yes.
> Are th
Peter,
Thursday, September 12, 2002, 3:35:26 AM, you wrote:
PG> So far as I can tell the mysql files included in the CD set are:
PG> mysql-3.23.49-3.i386.rpm
PG> mysqlclient9-3.23.22-6.i386.rpm
PG> mysql-devil-3.23.49-3.i386.rpm
PG> mysql-server-3.23.49-3.i386.rpm
PG> Do these files include Inno
So far as I can tell the mysql files included in the CD set are:
mysql-3.23.49-3.i386.rpm
mysqlclient9-3.23.22-6.i386.rpm
mysql-devil-3.23.49-3.i386.rpm
mysql-server-3.23.49-3.i386.rpm
Do these files include Innodb support?
Are they sufficient to install mysql?
I would be grateful for any advi
Hi
I have a web DB proyect and I would like to make a VB6 client where I can
connect to a local X database and a Web MySQL on a UNIX server.
So far, locally everything works great with VB6 and MySQL, the grids,
textbox, ADO control, etc.(DNS-Less and with DNS).
But when I connect to the DB on th
On Mon, Mar 04, 2002 at 03:06:46PM -0500, [EMAIL PROTECTED] wrote:
> I am currently implementing a database-ran webserver dll:
> Info:
> Ms Visual C++
> MySQL ++ 1.7.1
> MySQL-nt 3.23.47
> MyISAM db.
> 3or 4 Queries in the application
>
> Biggest Query:
> 66,000 records
> using LIKE "something%"
I am currently implementing a database-ran webserver dll:
Info:
Ms Visual C++
MySQL ++ 1.7.1
MySQL-nt 3.23.47
MyISAM db.
3or 4 Queries in the application
Biggest Query:
66,000 records
using LIKE "something%"
Question:
I am currently using a connection every time I query, but since this is a
stat
;[EMAIL PROTECTED]>
> Sent: Friday, July 20, 2001 10:04 AM
> Subject: Re: Please help - does changing the port the web server listens on
> affect mysql?
>
> > That's what I expected, but haven't figured out the problem with the one
> > database.
> > I created
- Original Message -
From: "Chip" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 10:04 AM
Subject: Re: Please help - does changing the port the web server listens on
affect mysql?
> That's what I expected, but haven't f
That's what I expected, but haven't figured out the problem with the one
database.
I created another very simple database and form and can insert data from the
web
form with no problem.
--
Chip
Jeremy Zawodny wrote:
> MySQL knows nothing of the ports that your Web server
Congratulations to the Webby Award!
> MySQL knows nothing of the ports that your Web server may listen to.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5
MySQL knows nothing of the ports that your Web server may listen to.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 33 days, processed 260,996,108 queries (90
I am having a problem with inserting data into a table via a web form,
which was
working just fine prior to changing the port the web server is listening on
from 80
to 8080. I can insert data via the mysql command line just fine, just not
from the
web form. Below are the forms and table def for
f any of you have time to participate and
are interested, please drop me a line. Thanks!
CC
-
FOR IMMEDIATE RELEASE
July 17, 2001
BLUE WORLD LASSO 5 PRODUCT LINE TO PROVIDE TIGHT INTEGRATION WITH
LEADING OPERATING SYSTEM, DATABASE, WEB SERVER and WEB AUTHORING
PRO
ss Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 7:51 AM
To: [EMAIL PROTECTED]
Subject: problem regarding ASP+MySQL in NT with IIS (web server)
respected sir,
i have a problem regarding conn
HUTOSH SHARMA [mailto:[EMAIL PROTECTED]]
> Sent: 18 May 2001 13:51
> To: [EMAIL PROTECTED]
> Subject: problem regarding ASP+MySQL in NT with IIS (web server)
>
>
> respected sir,
> i have a problem regarding connectivity between ASP and mysql.
> will it possible to connect asp
respected sir,
i have a problem regarding connectivity between ASP and mysql.
will it possible to connect asp with mysql if yes then how we can do it
will it need any driver if yes then from where we get that driver ..
will i get some tutoril in this matter...
thanking you
ashutosh
On Fri, Apr 13, 2001 at 09:35:38AM +0800, Leon Harris wrote:
>
> I believe that the session was idle. It also does it when I give the
> -2 option to ssh ( ssh2 is supposed to not time out, according to
> some usenet posts I have read). The point of the excercise is to
> have an encrypted connect
Hi Jeremy, thanks for your reply.
I believe that the session was idle. It also does it when I give the -2
option to ssh ( ssh2 is supposed to not time out, according to some
usenet
posts I have read).
The point of the excercise is to have an encrypted connection that I can
make DBI calls to the
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
>
> If you just reply to this message, and include
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote:
>
> On the client I do a
> ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306
>
> then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname
> and I get an encrypted connection. ( thats what tcpdump shows me) !
> Lovely !
>
>
Hi all.
I have had a real nightmare with mysql and ssh, trying to get a tunnel
going. I also have had similar probs with stunnel, but that is another
post.
I am running OpenSSH_2.5.2p2, SSH protocols 1.5/2.0, OpenSSL 0x0090581f
as the ssh client on the web server and sshd version
On Fri, Jan 26, 2001 at 10:39:46AM -0600, Patrick Goetz wrote:
>
> Thanks for the response.
>
> On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
> > > It just occurred to me, however, that this becomes a much bigger
> > > problem when the web server(s) and the databa
If you do any benchmarking with this setup let me know as I'm curious about
performance.
Mark Maunder.
Patrick Goetz wrote:
> Currently, every system I've set up is small enough so as to have the web
> server and the database server on the same machine. Consequently, loss of
> secu
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
> > It just occurred to me, however, that this becomes a much bigger
> > problem when the web server(s) and the database server are running
> > on different machines.
>
> Only if they're on dif
On Thu, Jan 25, 2001 at 10:01:59PM -0600, Patrick Goetz wrote:
>
> Currently, every system I've set up is small enough so as to have
> the web server and the database server on the same machine.
> Consequently, loss of security due to packet-sniffing can be
> completely cont
Currently, every system I've set up is small enough so as to have the web
server and the database server on the same machine. Consequently, loss of
security due to packet-sniffing can be completely controlled by using,
say, apache-ssl, since communications between the web server an
65 matches
Mail list logo
