How can I change MYSQL username and password ( root) .NOW username is "administrator" and pass=null

Answers

1. John J

   On 2006-07-31 11:16:43

   
   
   you can, as root or with proper access, run the query "UPDATE {dbName}.users SET password=PASSWORD({pw}) WHERE user='administrator';" replace {dbName} with the proper db, it is usually mysql, but it may be different, and replace {pw} with the password you choose.

2. TruthIsGod

   On 2006-07-31 11:06:38

   
   
   use mysql; set password = password("idiot") where user = administrator;