-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 12 November 2003 17:35, Bobby R. Cox wrote:
> Help I have a connect.php that allows for authentication of my database
> as a user "pmt" I changed the password and didnot back up the
> file...Now I can't access at all.
>
> What is the command to change the password for user "pmt" without
> knowing the correct password.
If you have "root" access to mysql then you can simple UPDATE the user table
in the mysql database.
UPDATE mysql.user SET password = password("newpassword") WHERE user = "pmt";
FLUSH PRIVILEGES;
- --
Mike Williams
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQE/snHFInuLMrk7bIwRAkMXAKCYxbhGZmZw1n5VV85hJ7KDJ6+SVACfedZU
eI/dh2lG2Hw+DPv9CFeWBFk=
=f0vn
-----END PGP SIGNATURE-----
--
[EMAIL PROTECTED] mailing list
