MySQL Accept Any Password
- by George
Suppose that I have a test server with a large group of test accounts. The test accounts have unknown passwords which are hard-coded into the application's reports and are stored encrypted in the mysql.users table.
Is there any option or hack which can be used to make mysql accept any text as the "correct" password for an account? For example:
Update mysql.user Set Password="*" where 1=1
Note: The above line wouldn't work because it would literally set the password to "*" and not the wildcard character. However, I am looking for a way to create a mysql account which would accept anything as a valid password. This machine is disconnected from the network and I have full access to the mysql database...