Matt,
Is there a space between PASSWORD and the opening parenthesis? There
shouldn't be, if there is. Otherwise, your statement worked without errors
for me on MySQL Version 4.0.16.max-nt.
Make sure that you are logged in as root.
C : \ select user();
Sometimes MySQL is cryptic about its
try
set password for 'root'@'localhost' = PASSWORD('somepassword');
bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 08:36:37 -0500
Matt,
Is there a space between PASSWORD and the opening parenthesis? There
shouldn't be, if
I entered select user();
It outputs:
---
user()
[EMAIL PROTECTED]
---
After I enter:
SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
ERROR 1146: Table mysql.user does not exist.
How is this possible?
- Matt
-Original Message-
From: [EMAIL
How embarrassing.
Yes I must have accidentally deleted the table.
I reinstalled and it works fine now.
Thank you very much for your help.
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 11:14 AM
To: Perry, Matthew (Fire Marshal's
Recently, I had to format my db server and when I re-attached the database,
I noticed some unusal behavior. I have some fields in certain tables with a
width of 60. When I would extract data from the table for that specific
field, the data would contain extra blank chars. As a result, I am forced
when you log on, there is no default database set to use
type: use mysql
bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 11:09:56 -0500
I entered select user();
It outputs:
Th cols are likely defined as CHAR not as VARCHAR. CHAR cols will pad out
the length of the value to the full width of the column...change the type to
varchar...
bastien
From: Dale Hersowitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php mssql
Date: Tue, 19 Oct 2004 09:36:25
I have a textarea field that will allow users to copy
and paste text into , it might be plain text, or it
might come out of word.
I'm wondering what type of validations I should
perform on this field ?
Any suggestions / ideas ?
Thank you,
Stuart
--
PHP Database Mailing List
I have a textarea field that will allow users to copy
and paste text into , it might be plain text, or it
might come out of word.
I'm wondering what type of validations I should
perform on this field ?
Any suggestions / ideas ?
Hi Stuart,
Check out the strip_tags and mysql_escape_string
Hi guys,
I have a normal categories table:
catId
catParentId
catName
catStatus
But I want when a user enters on:
http://hostname/site/products/catId1/catId7/catId13/../../contentId.html
A listing should apear like that:
Category 1
Category 7
Category 13
Category 2
Category 3
Thanks for the link.
I've got a working JavaScript menu system; I wanted a PHP script that
runs once/day to generate the tree structure in the JavaScript config
file. That way each time I added a page to the database, it would be
automatically added to the menu system.
I'm still interested in the
11 matches
Mail list logo