Help Connecting website to db

[Guarder]

Hello, i've added this website:

 

but when i try to open it,it says : 

Spoiler

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)Access denied for user 'root'@'localhost' (using password: NO)

 

 

what should i edit?...i have this 3 files in config folder:

1.Connect.php

<?php
# IP DO DEDICADO
$ip = "79.137.33.234";
// Connect PHP PDO
$connect = 'mysql:host=localhost;dbname=l2jdb';

try {
	$db = new PDO($connect,'root','');
	$db->setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
	echo $e->getMessage();
}

/*=======================================================================================*\
||########################| CONFIGURE NEWS |#########################||
\*=======================================================================================*/
$authorconf = 'Admin'; # Nome do author que irá aparecer nas news 


?>

2.Conf.php

<?php
$conexao = mysql_connect('localhost','root','') or die (mysql_error());
$banco = mysql_select_db('l2jdb', $conexao) or die(mysql_error());
$end = 'localhost';			 # Endere�o ou IP do seu site sem o 'http://www.', escreva assim: 'seusite.com.br' ou '200.145.221.89'
$nomedosite = 'L2 Forgot Life';

$host_smtp = 'mail.l2forgotlife.com';
$email_contato = 'EMAIL@l2forgotlife.com';
$senha_email_contato = 'SENHA';
?>

3.Config.php

<?php
$conexao = mysql_connect('localhost','root','') or die (mysql_error());
$banco = mysql_select_db('l2jdb', $conexao) or die(mysql_error());
$end = 'localhost';			 # Endere�o ou IP do seu site sem o 'http://www.', escreva assim: 'seusite.com.br' ou '200.145.221.89'
$nomedosite = 'L2 Forgot Life';

$host_smtp = 'mail.l2forgotlife.com';
$email_contato = 'EMAIL@l2forgotlife.com';
$senha_email_contato = 'SENHA';
?>

 

Edited February 15, 2019 by KIDutz

[wongerlt]

better warn who provoke to do that because everything starts with that.

[Pamela32]

do not do this if u dont know .. its possible to lose server from this 

[Guarder]

13 minutes ago, Pamela32 said:

do not do this if u dont know .. its possible to lose server from this 

 

it is saved i cannot loose it.i have backups

[SweeTs]

Google is your friend. 

 

Hint, you have to edit some mysql properties. If server / website is on another host, you have to allow the connection. By default it restrict to local, from memory.

 

I know that crappy feeling configuring it for the first time. Enjoy the drive 

[Guarder]

2 hours ago, SweeTs said:

Google is your friend. 

 

Hint, you have to edit some mysql properties. If server / website is on another host, you have to allow the connection. By default it restrict to local, from memory.

 

I know that crappy feeling configuring it for the first time. Enjoy the drive 

 

privileges to the user in db are give, ports are opened.i just dont know how to set this configs.none of the tutorials i found doesnt look like this configs

[Guarder]

32 minutes ago, baksteen said:

$conexao = mysql_connect('localhost','root','password') or die (mysql_error());

 

i am not using password

[Guarder]

1 minute ago, baksteen said:

Put there your password an try again. Same for other configs.

 

what password?im not using password mate

[wongerlt]

mysql and website on same pc?

[Guarder]

7 minutes ago, wongerlt said:

mysql and website on same pc?

 

no

[wongerlt]

Just now, KIDutz said:

 

no

so create new mysql account.

 

CREATE USER 'USER1'@'%' IDENTIFIED BY 'PASSWORD1';

and grant privileges for this user:

GRANT ALL ON *.* TO 'USER1'@'%';

'%' -  this mean for all ip address allow connect.

you can change it example to your website ip for security.

[Guarder]

18 minutes ago, wongerlt said:

so create new mysql account.

 

CREATE USER 'USER1'@'%' IDENTIFIED BY 'PASSWORD1';

and grant privileges for this user:

GRANT ALL ON *.* TO 'USER1'@'%';

'%' -  this mean for all ip address allow connect.

you can change it example to your website ip for security.

 

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not knownphp_network_getaddresses: getaddrinfo failed: Name or service not known

[Guarder]

its alway acces denied no matter what i do,how many tutorials i follow...it's still the same and nobody want to help me

[melron]

1 hour ago, KIDutz said:

it's still the same and nobody want to help me

 

are you retard or what?

[AlmostGood]

you actually sound pretty retaded, you can't do any basic googling to solve own problems where EVERYTHING you try to do was explained in hundreds of ways already. If you expect someone to do it for you with 0 own effort, just pay for it.

[DenArt Designs]

add me on skype if you want to pay i have developer he will propably help you with more than this