Jump to content

[Answered] Connection Failure For Mysql Database


jansterenborg

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...