thompa Posted January 3, 2017 Share Posted January 3, 2017 (edited) Hi, Happy New Year I am a free host user and wonder if anyone can help me to access a MySQL database using a PHP script?The Script file I am using contains the variables:-$dbHost="sql106.byethost9.com"; //MySQL server$dbUnam="b9_2951756"; //temp$dbPwrd="tennis"; //database password$dbName="b9_2951756_GTC"; //database name$dbPfix=""; //db table name prefix (optional)The variables are taken from the left-hand column of my cPanel and the error produced is:- MySQL hostname: "sql106.byethost9.com" MySQL username: "b9_2951756" and I use my cPanel Password The part I need, that isn't shown in cPanel is the correct 'Database Name'. When I use the 'MySQL' app (in cPanel) it shows:- 'MySQL DB Name' as "b9_2951756_GTC" ... but using this as above in the variable '$dbName' in my php file, doesn't work and I get the error message:- 'SQL query error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'b9_2951756_GTC._settings' doesn't exist' Can anyone indicated where I find the correct database name, how how I use what is there? Thanks in anticipation. Allan Edited January 3, 2017 by thompa Link to comment Share on other sites More sharing options...
Admin Posted January 4, 2017 Share Posted January 4, 2017 Base table or view not found: 1146 Table 'b9_2951756_GTC._settings' doesn't exist' suggests a required table does not exist in the database name specified. Link to comment Share on other sites More sharing options...
Recommended Posts