Help regarding connection

[lgoddgreat]

I was trying to create a website that enables the users to Input something in it, like user info. but it always gives an error whenever I try to test submit the inputted data's into the database.
'Could not Connect: Access denied for user 'smdg'@'localho st' (using password: YES)'

connection:

define('DB_NAME', 'testdb');
define('DB_USER', 'smdg');
define('DB_PASSWORD','samplepass');
define('DB_HOST', 'localhost');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, '3306');

config.inc.php

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'smdg';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

anyone who can point out what I did wrong or what I'm missing?

[RonB]

Are you able to connect from the command line using the same credentials?

Take the port number out of the connect statement.

Don't use the mysql_ functions, they are depreciated. Instead, you should be using mysqli_ or PDO.

[lgoddgreat]

yes I am able to connect, I double checked it.

take note that my problem is i cant insert any info to the database by connecting through the internet. I can view the Form in which the Infos will be inputted but when I try to press 'submit' button it always gives me an error saying 'Access denied for user "user@localhost " blah blah. like that, I've consulted some friends and they said that it should work but it doesn't

[RonB]

Which of those 2 code snippets are you using when connecting to the database?

The first one is using the mysql_connect() function incorrectly and should generate a syntax error. The second one doesn't show the connect statement but implies that it will be using the mysqli_connect() function.

There is also a discrepancy with the configured password. Since you're receiving an access denied error instead of a syntax error, I'll assume you're using the second code snippet when connecting, which is passing an empty string as the password instead of the password configured in the other snippet. Have you tried setting the password?

Try changing:

$cfg['Servers'][$i]['password'] = '';

To:

$cfg['Servers'][$i]['password'] = 'samplepass';

Make sure you put in the real password.

[lgoddgreat]

still the same. no improvement, maybe ill just try a different approach on this. thanks for your help though. cheers