Mysql underscore in user name
Posted: 16. March 2011 00:03
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
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