{"id":321,"date":"2023-07-16T11:34:47","date_gmt":"2023-07-16T11:34:47","guid":{"rendered":"https:\/\/www.ehcp.net\/?p=321"},"modified":"2023-08-13T20:38:08","modified_gmt":"2023-08-13T20:38:08","slug":"access-denied-for-user-ehcplocalhost","status":"publish","type":"post","link":"https:\/\/www.ehcp.net\/?p=321","title":{"rendered":"Access denied for user ‘ehcp’@’localhost’"},"content":{"rendered":"\n

Access denied for user ‘ehcp’@’localhost’ (using password: YES)<\/p>\n\n\n\n

This error may happen if you changed your ehcp mysql dbuser pass, either restore it, or change pass in config.php too, in \/var\/www\/vhosts\/ehcp dir, or alternatively, you may re-install ehcp.<\/p>\n\n\n\n

\n\n\n\n

Question:<\/p>\n\n\n\n

I always get this error :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ehcp’@’localhost’ (using password: YES) in \/var\/www\/vhosts\/ehcp\/config\/adodb\/drivers\/adodb-mysql.inc.php on line 365
Error Occured while connecting to db, check your db settings…
This is mostly caused by wrong ehcp password in config.php
if you just installed ehcp, then learn\/know your ehcp root password, then re-install ehcp..<\/p>\n\n\n\n

I have tried 3 times to reinstall it, but error remain. And I’ve checked config.php and it’s ok.
And I saw that there is not some new ehcp user in mysql or ehcp table… Maybe it can’t connect to mysql server at installing? But I know 100% that password is correct.<\/p>\n\n\n\n

Answer:<\/p>\n\n\n\n

which version do you use ?
latest version is 0.29.12 and it does not install if you dont provide right password,<\/p>\n\n\n\n

so, download latest version from www.ehcp.net\/download<\/a><\/p>\n\n\n\n

check your pass in config.php,<\/p>\n\n\n\n

then, use that pass to check connection to mysql:<\/p>\n\n\n\n

on server console:
mysql -u ehcp -p
then enter your password,
if it accepts, it is ok.
if not, your ehcp user in mysql is not correct.
make it correct.<\/p>\n\n\n\n

i may also connect by ssh and investigate, if you wish.<\/p>\n\n\n\n

\n\n\n\n

also, at the end of installation there is such errors:
language error: (error_occured) is not defined in currentlanguage of:(en) please define $this->lang[‘en’][‘error_occured’]=”……..”; in language\/en.php (source:Error sending info to daemon (sync dns) (executequery: insert into operations (op,action,info,info2,tarih) values (‘syncdns’,”,”,”,”)))err: Unknown database ‘ehcp’last db error:Unknown database ‘ehcp’<\/p>\n\n\n\n

as you see there is Unknown database ‘ehcp’<\/p>\n\n\n\n

\n\n\n\n

I solved the problem. The problem was with the mysql root password. Maybe when you entering it and the script checking it – the check goes well… but when the script trying to make some real queries for creation DB etc. it can’t connect.. I think the problem is with symbols in the mysql root pass, I think with ‘(‘ or ‘!’…
So I changed mysql root password to something simple like ‘newpassword’ and installation was successful.<\/p>\n","protected":false},"excerpt":{"rendered":"

Access denied for user ‘ehcp’@’localhost’ (using password: YES) This error may happen if you changed your ehcp mysql dbuser pass, either restore it, or change pass in config.php too, in \/var\/www\/vhosts\/ehcp dir, or alternatively, you may re-install ehcp. Question: I always get this error :Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ehcp’@’localhost’ (using password: YES) […]<\/p>\n","protected":false},"author":1,"featured_media":326,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/posts\/321"}],"collection":[{"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=321"}],"version-history":[{"count":1,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions"}],"predecessor-version":[{"id":323,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions\/323"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=\/wp\/v2\/media\/326"}],"wp:attachment":[{"href":"https:\/\/www.ehcp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ehcp.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}