![]() ![]() The default password for RazorSQL is r admin. If you haven’t already, the razorsql_mysql_bridge.php file should be uploaded to your Godaddy site. ![]() If your direct connection is not set up, you must use RazorSQL PHP to connect. If your GoDaddy database is set up to allow direct connections (such as remote access), RazorSQL should be able to connect directly to the database. Users can connect to GoDaddy databases from a remote machine by using RazorSQL’s PHP bridge. Once you have entered all of the required information, you can click on the “OK” button to connect to the GoDaddy MySQL database. In the “Password” field, you will need to enter your GoDaddy MySQL password. In the “Username” field, you will need to enter your GoDaddy MySQL username. In the “Port” field, you will need to enter 3306. In the “Hostname” field, you will need to enter the GoDaddy server name that you want to connect to. ![]() Once you have downloaded and installed MySQL Workbench, you will need to open the program and click on the “New Connection” button. This entry was posted in Web Site Dev and tagged godaddy, mysql, php, troubleshooting, web app on Octoby Oliver Baty.In order to connect to a GoDaddy MySQL database remotely, you will need to use a program like MySQL Workbench. The phpMyAdmin login, then, is case sensitive, so you may want to copy and paste from the Control Center into phpMyAdmin to be sure you’re feeding it the correct username. 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 |