[Answered] Connection Failure For Mysql Database

[jansterenborg]

Hello,

my website http://vcr.heliohost.org/ is to test whether I can read data from a MySQL database

also on the server

name database is vcjan_php

there are two rows of data in the data base

there is a user called: larry (vcrjan_larry)

password: larry2015

2 columns: name and email

I try with PHP scrips to make the connection

the script is visible on the site

perhaps I overlooked something

thank you

[jansterenborg]

I made some adjustments and the server sees my page 4 as an php page and

the compiler found an error. This error is corrected and now I get this:

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1044): Access denied for user 'vcrjan_larry'@'localhost' to database 'vcrjan_php' in/home1/vcrjan/public_html/db_connect.php on line 113

Connection failed: Access denied for user 'vcrjan_larry'@'localhost' to database 'vcrjan_php'

 

This is a real connection thing.

Why can't user larry not enter the database?

 

I havn't any answers (yet)

Can you help me with this last thing?

 

ps you can see this last error here on page 4

 

http://vcr.heliohost.org/

 

http://vcr.heliohost.org/db_connect.php

[jansterenborg]

the problem lies in the mysql server address i used 'localhost' as a kind of default because in the user panel there is no mention of this address

or I overlooked it. So I hope you add this info on the side.

[jansterenborg]

Last result:

 

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'http://vcr.heliohost.org/' (1) in /home1/vcrjan/public_html/db_connect.phpon line 113

Connection failed: Unknown MySQL server host 'http://vcr.heliohost.org/' (1)

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'http://vcr.heliohost.org/mysql' (1) in/home1/vcrjan/public_html/db_connect.php on line 113

Connection failed: Unknown MySQL server host 'http://vcr.heliohost.org/mysql' (1)

[jansterenborg]

one more time

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'http://stevie.heliohost.org/' (1) in/home1/vcrjan/public_html/db_connect.php on line 113

Connection failed: Unknown MySQL server host 'http://stevie.heliohost.org/' (1)

[jansterenborg]

The first problem is solved:

 

in $servername it has to be 'stevie.heliohost.org' and not 'http://stevie.heliohost.org/'

 

 

now the next problem arises

 

 

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'vcrjan_jan'@'stevie.heliohost.org' (using password: YES) in/home1/vcrjan/public_html/db_connect.php on line 114

Connection failed: Access denied for user 'vcrjan_jan'@'stevie.heliohost.org' (using password: YES)

 

the password of user jan is not identified as correct (but it is correct)

[Tjoene]

First, The servername should be localhost, not stevie.heliohost.org

 

Second, have you created a MySQL user named vcrjan_jan in cPanel and assigned it to the database you are trying to connect to?

[jansterenborg]

Hello Moderator from Belgium

thanks for your reply.

the connection works with stevie.heliohost.org

but i will change that in localhost other servers reject that

i have named a user vcrjan_jan

and assigned it to?

i will look at that

thanks!

 

Changed stevie.heliohost.org in localhost and

I assigned user jan to database vcrjan_php

 

the error stays the same

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'vcrjan_jan'@'localhost' (using password: YES) in/home1/vcrjan/public_html/db_connect.php on line 115

Connection failed: Access denied for user 'vcrjan_jan'@'localhost' (using password: YES)

[jansterenborg]

its working

just use the exact password not name and _ of the database before it

thanks