how to connect to a live server with viewen












0















I am trying to get my website on a live server with viewen but for some reason, I have the following errors. I am not sure why the errors occurred because I have uploaded all the files to the same public_html folder. The only assistance I had from them was to create a new database, which I did and below is my credentials: I am not sure if my dbh.php is set up correctly:



<?php



$dbservername = "localhost";

$dbroot = "root";

$dbpassword = "";

$dbdatabase = "pianocou_loginsystem";



$conn = @mysqli_connect($dbservername, $dbroot, $dbpassword, $dbdatabase);





I got rid of the password just for security reason but did include it in my dbh.. Must I change the dbroot? They also told me to leave it as localhost for the server.



[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(header2.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'header2.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(viewcounter.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'viewcounter.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: views in /home/pianocou/public_html/index.php on line 118

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(footer.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'footer.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(includes/dbh.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'includes/dbh.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: conn in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_init() expects parameter 1 to be mysqli, null given in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP   2. mysqli_stmt_init() /home/pianocou/public_html/index.php:131

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, null given in /home/pianocou/public_html/index.php on line 133


Most of my errors said the same thing....



enter image description here






php mysqli







share|improve this question

























  • change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

    – Alex
    Nov 24 '18 at 18:17






  • 1





    all these warnings are not about mysql :-)

    – Alex
    Nov 24 '18 at 18:18











  • thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

    – piano0011
    Nov 25 '18 at 3:03











  • and the DIR has two underscore on each side?

    – piano0011
    Nov 25 '18 at 3:04











  • Yes! That is magic constant in php

    – Alex
    Nov 25 '18 at 3:09
















0















I am trying to get my website on a live server with viewen but for some reason, I have the following errors. I am not sure why the errors occurred because I have uploaded all the files to the same public_html folder. The only assistance I had from them was to create a new database, which I did and below is my credentials: I am not sure if my dbh.php is set up correctly:



<?php



$dbservername = "localhost";

$dbroot = "root";

$dbpassword = "";

$dbdatabase = "pianocou_loginsystem";



$conn = @mysqli_connect($dbservername, $dbroot, $dbpassword, $dbdatabase);





I got rid of the password just for security reason but did include it in my dbh.. Must I change the dbroot? They also told me to leave it as localhost for the server.



[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(header2.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'header2.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(viewcounter.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'viewcounter.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: views in /home/pianocou/public_html/index.php on line 118

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(footer.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'footer.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(includes/dbh.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'includes/dbh.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: conn in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_init() expects parameter 1 to be mysqli, null given in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP   2. mysqli_stmt_init() /home/pianocou/public_html/index.php:131

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, null given in /home/pianocou/public_html/index.php on line 133


Most of my errors said the same thing....



enter image description here






php mysqli







share|improve this question

























  • change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

    – Alex
    Nov 24 '18 at 18:17






  • 1





    all these warnings are not about mysql :-)

    – Alex
    Nov 24 '18 at 18:18











  • thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

    – piano0011
    Nov 25 '18 at 3:03











  • and the DIR has two underscore on each side?

    – piano0011
    Nov 25 '18 at 3:04











  • Yes! That is magic constant in php

    – Alex
    Nov 25 '18 at 3:09














0












0








0








I am trying to get my website on a live server with viewen but for some reason, I have the following errors. I am not sure why the errors occurred because I have uploaded all the files to the same public_html folder. The only assistance I had from them was to create a new database, which I did and below is my credentials: I am not sure if my dbh.php is set up correctly:



<?php



$dbservername = "localhost";

$dbroot = "root";

$dbpassword = "";

$dbdatabase = "pianocou_loginsystem";



$conn = @mysqli_connect($dbservername, $dbroot, $dbpassword, $dbdatabase);





I got rid of the password just for security reason but did include it in my dbh.. Must I change the dbroot? They also told me to leave it as localhost for the server.



[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(header2.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'header2.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(viewcounter.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'viewcounter.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: views in /home/pianocou/public_html/index.php on line 118

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(footer.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'footer.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(includes/dbh.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'includes/dbh.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: conn in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_init() expects parameter 1 to be mysqli, null given in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP   2. mysqli_stmt_init() /home/pianocou/public_html/index.php:131

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, null given in /home/pianocou/public_html/index.php on line 133


Most of my errors said the same thing....



enter image description here






php mysqli







share|improve this question
















I am trying to get my website on a live server with viewen but for some reason, I have the following errors. I am not sure why the errors occurred because I have uploaded all the files to the same public_html folder. The only assistance I had from them was to create a new database, which I did and below is my credentials: I am not sure if my dbh.php is set up correctly:



<?php



$dbservername = "localhost";

$dbroot = "root";

$dbpassword = "";

$dbdatabase = "pianocou_loginsystem";



$conn = @mysqli_connect($dbservername, $dbroot, $dbpassword, $dbdatabase);





I got rid of the password just for security reason but did include it in my dbh.. Must I change the dbroot? They also told me to leave it as localhost for the server.



[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(header2.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'header2.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 6

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(viewcounter.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'viewcounter.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 7

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: views in /home/pianocou/public_html/index.php on line 118

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(footer.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'footer.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 126

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(includes/dbh.php): failed to open stream: No such file or directory in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  include_once(): Failed opening 'includes/dbh.php' for inclusion (include_path='.:/opt/alt/php70/usr/share/pear') in /home/pianocou/public_html/index.php on line 127

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Notice:  Undefined variable: conn in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_init() expects parameter 1 to be mysqli, null given in /home/pianocou/public_html/index.php on line 131

[25-Oct-2018 10:46:32 UTC] PHP Stack trace:

[25-Oct-2018 10:46:32 UTC] PHP   1. {main}() /home/pianocou/public_html/index.php:0

[25-Oct-2018 10:46:32 UTC] PHP   2. mysqli_stmt_init() /home/pianocou/public_html/index.php:131

[25-Oct-2018 10:46:32 UTC] PHP Warning:  mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, null given in /home/pianocou/public_html/index.php on line 133


Most of my errors said the same thing....



enter image description here






php mysqli




php mysqli






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 27 '18 at 13:58







piano0011

















asked Nov 24 '18 at 14:33









piano0011piano0011

65




65













  • change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

    – Alex
    Nov 24 '18 at 18:17






  • 1





    all these warnings are not about mysql :-)

    – Alex
    Nov 24 '18 at 18:18











  • thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

    – piano0011
    Nov 25 '18 at 3:03











  • and the DIR has two underscore on each side?

    – piano0011
    Nov 25 '18 at 3:04











  • Yes! That is magic constant in php

    – Alex
    Nov 25 '18 at 3:09



















  • change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

    – Alex
    Nov 24 '18 at 18:17






  • 1





    all these warnings are not about mysql :-)

    – Alex
    Nov 24 '18 at 18:18











  • thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

    – piano0011
    Nov 25 '18 at 3:03











  • and the DIR has two underscore on each side?

    – piano0011
    Nov 25 '18 at 3:04











  • Yes! That is magic constant in php

    – Alex
    Nov 25 '18 at 3:09

















change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

– Alex
Nov 24 '18 at 18:17





change your code from include_once(viewcounter.php); to include_once(__DIR__.'viewcounter.php')'

– Alex
Nov 24 '18 at 18:17




1




1





all these warnings are not about mysql :-)

– Alex
Nov 24 '18 at 18:18





all these warnings are not about mysql :-)

– Alex
Nov 24 '18 at 18:18













thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

– piano0011
Nov 25 '18 at 3:03





thanks! will give that a go! so would I need to do that for all my include files? I think it looks like it....

– piano0011
Nov 25 '18 at 3:03













and the DIR has two underscore on each side?

– piano0011
Nov 25 '18 at 3:04





and the DIR has two underscore on each side?

– piano0011
Nov 25 '18 at 3:04













Yes! That is magic constant in php

– Alex
Nov 25 '18 at 3:09





Yes! That is magic constant in php

– Alex
Nov 25 '18 at 3:09












1 Answer
1






active

oldest

votes


















0














Database root is not the root it will be your Database user and make sure the Database user has full rights to the Database.






share|improve this answer
























  • thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

    – piano0011
    Nov 28 '18 at 7:54











  • I didn't get sql failed in my localhost but just my live server

    – piano0011
    Nov 28 '18 at 7:54











  • did you check if the database user name is correct or you are entering correct password

    – Dhruv Joshi
    Dec 24 '18 at 13:26











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53459214%2fhow-to-connect-to-a-live-server-with-viewen%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Database root is not the root it will be your Database user and make sure the Database user has full rights to the Database.






share|improve this answer
























  • thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

    – piano0011
    Nov 28 '18 at 7:54











  • I didn't get sql failed in my localhost but just my live server

    – piano0011
    Nov 28 '18 at 7:54











  • did you check if the database user name is correct or you are entering correct password

    – Dhruv Joshi
    Dec 24 '18 at 13:26
















0














Database root is not the root it will be your Database user and make sure the Database user has full rights to the Database.






share|improve this answer
























  • thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

    – piano0011
    Nov 28 '18 at 7:54











  • I didn't get sql failed in my localhost but just my live server

    – piano0011
    Nov 28 '18 at 7:54











  • did you check if the database user name is correct or you are entering correct password

    – Dhruv Joshi
    Dec 24 '18 at 13:26














0












0








0







Database root is not the root it will be your Database user and make sure the Database user has full rights to the Database.






share|improve this answer













Database root is not the root it will be your Database user and make sure the Database user has full rights to the Database.







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 28 '18 at 7:49









Dhruv JoshiDhruv Joshi

1




1













  • thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

    – piano0011
    Nov 28 '18 at 7:54











  • I didn't get sql failed in my localhost but just my live server

    – piano0011
    Nov 28 '18 at 7:54











  • did you check if the database user name is correct or you are entering correct password

    – Dhruv Joshi
    Dec 24 '18 at 13:26



















  • thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

    – piano0011
    Nov 28 '18 at 7:54











  • I didn't get sql failed in my localhost but just my live server

    – piano0011
    Nov 28 '18 at 7:54











  • did you check if the database user name is correct or you are entering correct password

    – Dhruv Joshi
    Dec 24 '18 at 13:26

















thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

– piano0011
Nov 28 '18 at 7:54





thanks for the kind assistance but I have selected all the checkbox to give the user full permission and have added the username but don't know why I got sql failed

– piano0011
Nov 28 '18 at 7:54













I didn't get sql failed in my localhost but just my live server

– piano0011
Nov 28 '18 at 7:54





I didn't get sql failed in my localhost but just my live server

– piano0011
Nov 28 '18 at 7:54













did you check if the database user name is correct or you are entering correct password

– Dhruv Joshi
Dec 24 '18 at 13:26





did you check if the database user name is correct or you are entering correct password

– Dhruv Joshi
Dec 24 '18 at 13:26




















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53459214%2fhow-to-connect-to-a-live-server-with-viewen%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Wiesbaden

Image
Wappen Deutschlandkarte 50.0825 8.24 117 Koordinaten: 50° 5′  N , 8° 14′  O Basisdaten Bundesland: Hessen Regierungsbezirk: Darmstadt Höhe: 117 m ü. NHN Fläche: 203,93 km 2 Einwohner: 278.654 (31. Dez. 2017) [1] Bevölkerungsdichte: 1366 Einwohner je km 2 Postleitzahlen: 65183–65207, 55246, 55252 Vorlage:Infobox Gemeinde in Deutschland/Wartung/PLZ enthält Text Vorwahlen: 0611, 06122, 06127, 06134 Kfz-Kennzeichen: WI Gemeindeschlüssel: 06 4 14 000 LOCODE: DE WIB NUTS: DE714 Stadtgliederung: 26 Ortsbezirke Adresse der Stadtverwaltung: Schlossplatz 6 65183 Wiesbaden Webpräsenz: www.wiesbaden.de Oberbürgermeister: Sven Gerich (SPD) Lage der Landeshauptstadt Wiesbaden in Hessen und im Regierungsbezirk Darmstadt Offizielles Logo der Landeshauptstadt Wiesbaden Flagge der Landeshauptstadt Wiesbaden Wiesbaden is
Read more

Marschland

Image
Kilometerweite Marsch in den Vier- und Marschlanden am Elbdeich Die Wedeler Marschlandschaft in Schleswig-Holstein Der Hadelner Kanal zur Entwässerung der Marsch Die tief gelegene Marsch und ein Entwässerungskanal Das Schöpfwerk Otterndorf im Land Hadeln zur Entwässerung der Medem verfügte damals bereits über die größte Kreiselpumpe Europas. Das Schöpfwerk in Neuhaus für die Aue und des Neuhaus-Bülkauer Kanals Als Marsch(land) (v. niederdt., altsächs. mersc ) – auch Masch , Mersch oder Schwemmland genannt – bezeichnet man eine nacheiszeitlich entstandene geomorphologische Landform im Gebiet der nordwestdeutschen Küsten und Flüsse sowie vergleichbare Landformen weltweit. Inhaltsverzeichnis 1 Landschaft 2 Entstehung 3 Marschböden 4 Nutzung 5 Marschgebiete in Deutschland 6 Siehe auch 7 Literatur 8 Weblinks 9 Einzelnachweise Landschaft | Marschen sind generell flache Landstriche ohne natürliche Erhebungen. Si
Read more

Dieringhausen

Image
Dieringhausen Stadt Gummersbach 50.982777777778 7.5316666666667 165 Koordinaten: 50° 58′ 58″  N , 7° 31′ 54″  O Höhe: 165  (160–245)  m Einwohner: 5055  (30. Jun. 2016) Postleitzahl: 51645 Vorwahl: 02261 Lage von Dieringhausen in Gummersbach Im Hohl ca. 1927–1930 Ansicht von Südwesten bei Bünghausen Dieringhausen (im örtlichen Dialekt Dierkesen ) ist ein Ortsteil von Gummersbach im Oberbergischen Kreis, Regierungsbezirk Köln, Nordrhein-Westfalen (Deutschland). Inhaltsverzeichnis 1 Geographie 2 Geschichte 3 Kultur 3.1 Sehenswürdigkeiten 3.2 Regelmäßige Veranstaltungen 4 Infrastruktur und Wirtschaft 4.1 Verkehr 4.1.1 Schienen- und Busverkehr 4.1.2 Straßen 4.2 Öffentliche Einrichtungen 4.2.1 Schulen und Bildungseinrichtungen 4.2.2 Kirchliche Einrichtungen 5 Persönlichkeiten 5.1 In Dieringhausen geboren 5.2 In Dieringhausen gelebt 6 Einzelnachweise 7
Read more