Problem: It cant display information entered in the databse intead it display an error stated below.. Error code: Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\wamp\www\lormahr\employee\view_employee.php on line 486 On line 486: $result=mysql_query($query);
It is telling you that the error is on line 486 because this line of code was written to print out the results, check to make sure that your database login details are correct and that all tables are stated correctly!
You need to open a MySQL connection using mysql_connect and select a database using mysql_select_db before you can do queries. For example like this: $connection = mysql_connect('host', 'username', 'password'); mysql_select_db('databasename'); PHP:
This error comes When you have not defined the DB location and credentials or if you have defined them wrong
Set a password first for your SQL , and also other said make sure you have correct database username,password and server...
Hi, this is mysql error, i think your this user "ODBC" don't have permission on localhost please set that first and then try that page again. Thanks,
i think you are entering your user information in the wrong file due to the fact that ODBC is selected as default user for php unless defined and im sure wamp default user is "root" try lookin for where line 486 is and if ites a function or an include or even a var look where the var is created and edit the settings from there?