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
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
[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
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
