On Mon, 3 Mar 2008, Daniel Brown wrote:
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password "my_pw";
but i can't do:
mysqladmin -u root -h dev.jss.com password "my_pw";
how do i change pw for [EMAIL PROTECTED]
Quickly STFW'ing/RTFM'ing would give you an answer.
One way is to log into the remote host (dev.jss.com) via SSH as
root (or use a control panel such as cPanel).
Another is to use the MySQL client and log in remotely as such:
mysql -h dev.jss.com -u root -p
(Enter the MySQL root password)
Then type the following MySQL queries:
USE mysql;
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
FLUSH PRIVILEGES;
Just be sure to replace 'newpwd' with the password you want to
use. MySQL's PASSWORD() function will handle hashing the password, so
don't send it encrypted or pre-hashed.
mysql> select user,host,password from mysql.user;
+------+----------------------+------------------+
| user | host | password |
+------+----------------------+------------------+
| root | localhost | **************** |
| root | dev.jss.com | |
| | dev.jss.com | |
| | localhost | |
+------+----------------------+------------------+
4 rows in set (0.00 sec)
i have no problem set password for [EMAIL PROTECTED], but for some reason i
can't set a password for [EMAIL PROTECTED]
is there any security issue not to set password for [EMAIL PROTECTED]
what about these two:
''@'localhost' & ''@'dev.jss.com'
thanks,
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
