I use xampp for php/mysql development, but I have run into a real PITA problem.
My hosting website (using CPanel) forces you to prefix the master account name on both database names, and user names.
So I have databases named like this:
accountname_treedb, accountname_citydb, and so on.
MORE IMPORTANTLY, when I set up the name of a user who is going to get access to these databases, it ALSO prefixes the same thing, like:
accountname_user1, accountname_user2.
Ok, that's fine, I can live with it. But when I'm developing on my local machine, I want to use the same naming as is on the production machine.
The naming of the database is fine, but when I name a user with an underscore, xampp chokes. It APPEARS to allow me to name a user like this:
accountname_user1
....BUT, it invariably gives me "user denied access, etc".
If I create a user on xampp named simply "user1", and I change my php code from accountname_user1 to just user1, everything works. No other changes.
Is there someplace, some setting, where I can tell the xampp package to cut me some slack on usernames???
I know this is trivial, but if I do my development using different names, I just know that two or three times it's going to play "gotcha" with me, and I'll be debugging a newly uploaded software a few times for no reason. I'd be very grateful if somebody has the answer.
John