more apache/php

[Dungeon-Dave]

mysql> USE databasename_db;

Database changed

mysql> UPDATE user SET Password=PASSWORD('password') WHERE user='testuser';

ERROR 1146 (42S02): Table 'databasename_db.user' doesn't exist

mysql>

All users are stored in the mysql.users table, ie: the "users" table in the "mysql" database.

 

A safer method is to use the "set password" statement, rather than try to update the mysql.users table directly, i.e.:

Code:

set password for testuser = password('PA55W0RD!');