doubledee Posted January 22, 2012 Share Posted January 22, 2012 I am using a free web hosting site for my Test Site. (www.byethost.com) They do offer phpMyAdmin, but after poking around, I cannot find the following... - Database Host Name - Database User - Database Password Where would I find this critical information, so I get my database and site running?! Debbie Quote Link to comment Share on other sites More sharing options...
AyKay47 Posted January 22, 2012 Share Posted January 22, 2012 The MySQL default credentials are located in the MySQL section of the php.ini file. however, they are not always set. Quote Link to comment Share on other sites More sharing options...
doubledee Posted January 22, 2012 Author Share Posted January 22, 2012 The MySQL default credentials are located in the MySQL section of the php.ini file. however, they are not always set. What good would knowing that do me on a Shared Host?! Debbie Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 22, 2012 Share Posted January 22, 2012 You need to ask your hosting company. We don't have that information. Quote Link to comment Share on other sites More sharing options...
doubledee Posted January 22, 2012 Author Share Posted January 22, 2012 You need to ask your hosting company. We don't have that information. On my Dev Laptop SELECT CURRENT_USER( ) root@localhost ------------------------ SELECT USER() root@localhost On my Free Hosting Account SELECT CURRENT_USER( ) b2_12345@% ------------------------ SELECT USER() b2_12345@192.168.0.2 What is the percentage sign? What is 192.168.0.2? Debbie Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 22, 2012 Share Posted January 22, 2012 192.168.0.2 appears to be the IP address of the MySQL server on their local network. b2_12345 is the user name. The @% represents the type of access the user has, whether it's only local login, over the network, etc. Quote Link to comment Share on other sites More sharing options...
AyKay47 Posted January 22, 2012 Share Posted January 22, 2012 The MySQL default credentials are located in the MySQL section of the php.ini file. however, they are not always set. What good would knowing that do me on a Shared Host?! Debbie Well, yeah you should just contact your hosting provider for this, but what I was getting at is you can use ini_get to view the default values, whether that will help you or not I'm not sure here, odds are that the credentials are host=localhost user=root password="" Quote Link to comment Share on other sites More sharing options...
fenway Posted January 23, 2012 Share Posted January 23, 2012 If your hosting provider won't tell you how to connect to your database, get a new host. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.