MySQL user setup in Webmin
I recently had to setup a new database user in Webmin for a project using Joomla 1.0.13.
I went Servers -> MySQL -> User Permissions -> Create new user. Don’t be fooled into thinking that the actual form at the bottom really has anything to do with creating a new user. It’s only a connection to existing Linux users.
I selected all permissions in the interface I was directed to. I also used the Any radio button alternative thinking that it must be the most sensible alternative since I wanted to create some kind of power user. Wrong! When I tried to run the site I could not connect to the database.
Instead of “Any” you have to explicitly write “localhost” in the text field to the right, otherwise Joomla won’t be able to connect to the database. And I suspect any site that connects to “localhost” won’t work either.
You would think that the any host alternative would include localhost, apparently not.