RE: [PHP-DB] setting root password
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 error messages for security reasons.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly this:
c:\cd C:\mysql\bin
c:\mysql\binmysql -uroot -p
mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message you must have
privileges to update tables in the mysql database to be able to change
passwords for others. What could I be doing incorrectly?
-Matt
RE: [PHP-DB] setting root password
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 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 error messages for security reasons.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly this:
c:\cd C:\mysql\bin
c:\mysql\binmysql -uroot -p
mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message you must have
privileges to update tables in the mysql database to be able to change
passwords for others. What could I be doing incorrectly?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] setting root password
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 PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
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 error messages for security reasons.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly this:
c:\cd C:\mysql\bin
c:\mysql\binmysql -uroot -p
mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message you must have
privileges to update tables in the mysql database to be able to change
passwords for others. What could I be doing incorrectly?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] setting root password
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 Office)
Subject: RE: [PHP-DB] setting root password
try
mysql\ use mysql
then
mysql\show tables
is the user table there?
if not, have you dropped the user table?
David
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 11:09 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
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 PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
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 error messages for security reasons.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly this:
c:\cd C:\mysql\bin
c:\mysql\binmysql -uroot -p
mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message you must have
privileges to update tables in the mysql database to be able to change
passwords for others. What could I be doing incorrectly?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php mssql
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 to use the trim function to get rid of the extra chars. This problem has never occured before and I now find it quite annoying. Does anybody have any ideas? Thanks, Dale -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] setting root password
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:
---
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 PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
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 error messages for security reasons.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly this:
c:\cd C:\mysql\bin
c:\mysql\binmysql -uroot -p
mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword');
I get the following familiar message:
You have an error on your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto
the
mysql client with:
mysql mysql -uroot -p
then press enter again when it prompts you for a password.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message you must have
privileges to update tables in the mysql database to be able to change
passwords for others. What could I be doing incorrectly?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php mssql
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 -0700 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 to use the trim function to get rid of the extra chars. This problem has never occured before and I now find it quite annoying. Does anybody have any ideas? Thanks, Dale -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Question: Copy and paste text into mysql text column
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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Question: Copy and paste text into mysql text column
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 commands. They allow you to filter misc. code that might be imbedded in the data and also prepare the data for insertion into the database (if you're going to store it). Ed Lazor, President http://RPGStore.com Up to 50% off. Over 20,000 items in stock -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Reverse (or backward?) Infinity Loop
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 Category 4 Category 5 A reverse (or backward) loop! We need to get the last category and then follow the ParentId until the 0 ParentId. Have anybody made this before (I hope so)? Many Thanks, Bruno B B Magalhaes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Generate Menu based on database structure
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 menu class to store each record as an object of the class if anyone can point me to any sites or offer any hints. Cheers, Gav -Original Message- From: Leo G. Divinagracia III [mailto:[EMAIL PROTECTED] Sent: Friday, 15 October 2004 11:29 AM Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Generate Menu based on database structure graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
