php - Access denied for user localhost -
i following tutorial(http://www.wikihow.com/create-a-secure-login-script-in-php-and-mysql) build login system.
it looks it's working fine now, on login page, there error dont quite understand means , how can affect operation.
( ! ) scream: error suppression ignored ( ! ) warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (28000/1045): access denied user 'sec_user'@'localhost' (using password: yes) in c:\wamp\www\uncultured\login copy\includes\db_connect.php on line 3 call stack # time memory function location 1 0.0005 370336 {main}( ) ..\login.php:0 2 0.0009 373048 include_once( 'c:\wamp\www\uncultured\login copy\includes\db_connect.php' ) ..\login.php:2 3 0.0012 375688 mysqli->mysqli( ) ..\db_connect.php:3
i grateful if can point me in right direction, much! cheers
have added privileges in mysql server user "sec_user" ?
something like: grant (insert required privileges here) on yourdatabase.(table allow access to) 'sec_user'@'localhost' identified '(insert desired password here)';
for instance select, update, insert , delete on tables in database: "mydatabase" sec_user on localhost password 'mysecretpassword' be:
grant select,update,insert,delete on mydatabase.* 'sec_user'@'localhost' identified 'mysecretpassword';
Comments
Post a Comment