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\bin>mysql -uroot -p mysql>SET 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] 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\bin>mysql -uroot -p mysql>SET 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\bin>mysql -uroot -p mysql>SET 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
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\bin>mysql -uroot -p mysql>SET 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
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\bin>mysql -uroot -p mysql>SET 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
After going to the command prompt I have done exactly this: c:\>cd C:\mysql\bin c:\mysql\bin>mysql -uroot -p mysql>SET 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
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