php - Is my hosting company messing me up here: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)? -

i use hosting company aplus.net, , can't seem past connection error i'm getting when trying process php write database content webpage, , curious if because database appears not on same server entire rest of hosting account, , if there way resolve in code? first attempt @ writing php, , know if code wrong, or if hosting company messing me up. (and either way, how fix it)

here's code that's failing pull database:

{   $con = mysql_connect("localhost","2p5dq9vxmy240651","my_password");   if (!$con)   {     die('could not connect: ' . mysql_error());   }   mysql_select_db("felineasthma_2p5dq9vxmy240651", $con);   $users_name = $_post['name'];   $users_comment = $_post['requests'];   $users_name = mysql_real_escape_string($users_name);   $users_comment = mysql_real_escape_string($users_comment);   $inputid = $_get['id'];   $query = "   insert `felineasthma_2p5dq9vxmy240651`.`submissions` (`id`,    `name`, `requests`, `inputid`) values (null,     '$users_name', '$users_comment', '$inputid');";   mysql_query($query);   echo "<h2>your request has been processed, reload page.</h2>";   mysql_close($con); } 

and here's screen captures inside hosting account (links because don't have enough posts here yet upload images, sorry):

felineasthma_2p5dq9vxmy240651 doesn't appear in hosting account

yet exists in mysql manager, on different server

i more confused while making user database, control panel didn't allow me make username, randomly assigned one. help? advice?

i found more modern tutorial learn php with, , works, need add security measures now. here's working code snippets, if ever comes here asking same questions.

here's form action places entries database:

<?php $servername = "sql5c40n.carrierzone.com"; $username = "my_username"; $password = "my_password"; $dbname = "my_database"; $users_name = $_post['name']; $users_request = $_post['requests'];  // create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // check connection if (!$conn) {     die("connection failed: " . mysqli_connect_error()); }  $sql = "insert submissions (name, requests) values ('$users_name', '$users_request')";  if (mysqli_query($conn, $sql)) {     header("location: clv.php"); } else {     echo "error: " . $sql . "<br>" . mysqli_error($conn); }  mysqli_close($conn); ?>  

here's include puts database entries onto page:

<?php $servername = "sql5c40n.carrierzone.com"; $username = "my_username"; $password = "my_password"; $dbname = "my_database";  // create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // check connection if (!$conn) {     die("connection failed: " . mysqli_connect_error()); }  $sql = "select id, requests, name submissions"; $result = mysqli_query($conn, $sql);  if (mysqli_num_rows($result) > 0) {     // output data of each row     while($row = mysqli_fetch_assoc($result)) {         echo "" . $row["requests"]. " - " . $row["name"]. "<br>";     } } else {     echo "0 results"; }  mysqli_close($conn); ?>