The lesson learned here, is that even though the new MySQL database setup form will accept mixed case characters as the database name/username, it will silently convert them to lowercase on you. The fix (or a plausible explanation, at least) And of course, when I tried to log into phpMyAdmin a moment later with the lowercase username, it went right in. The guy confirmed that the database was in good shape and that the last password reset took effect, then had me reset it again. I submitted a support ticket, as recommended in the thread, and then called Customer Support for good measure. So I tried using the lowercase version at phpMyAdmin and still no luck. ![]() īack in the Control Center, I noticed that the mixed case characters I’d used for the database/username had been converted to lowercase. Then it was time to Google, which turned up a thread full of people with the same experience at. I waited a few more minutes for good measure and tried again. I copied and pasted the username and password from my config file into the log in fields and wham, I got the #1045.Īfter much second guessing and more copying and pasting, all with no luck, I tried resetting the password back in the Hosting Control Center. I gave it 10 or 15 minutes to get all set up and then launched phpMyAdmin. So, I picked a string of characters for the database name and a different string for the password (making sure the password contained at least 1 uppercase character and 1 number), pasted them into the config.php file I was going to use on the project and then pasted them into the database setup form and created my database. This gives me a good mix of uppercase, lowercase, and numbers, which satisfies the requirements of most password systems that require even minimum complexity. I typically use a subset of the 63 random alpha-numeric characters (a-z, A-Z, 0-9) in the bottom box. ![]() ![]() One excellent source of such strings is GRC’s Ultra High Security Password Generator. While setting up a new MySQL account at a GoDaddy hosted web site, I kept getting an error when logging in to phpMyAdmin.įor things like database usernames/passwords and other things that I’ll never have to remember or type, I like to use a long string of random characters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |