Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] Access denied

Shibo

Technical details

Flarum version : 0.1.0-beta.7
nginx1.8+php5.6+CentOS 6.9

Flarum info:

[my@webhk bbs]# php flarum info
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/Connector.php:55
Stack trace:
#0 /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/Connector.php(55): PDO->__construct('mysql:host=loca...', 'root', '12345', Array)
#1 /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/MySqlConnector.php(22): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=loca...', Array, Array)
#2 /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/ConnectionFactory.php(60): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/ConnectionFactory.php(49): Illuminate\Database\Connectors\ConnectionFactory->createSingleConnection(Array)
#4 /home/wwwroot/Lebit/domain/le in /home/mydomain/web/bbs/vendor/illuminate/database/Connectors/Connector.php on line 55

mysql account info is correct and i've test it with phpmyadmin .

jordanjay29

Shibo MySQL version?

php -m output?

luceos

Shibo for host try 127.0.0.1 instead. If you get the same error your credentials are wrong, even if you think that is not the case. Perhaps your root user isn't allowed to connect to the database?

Shibo

jordanjay29 thanks , mysql version is 5.6
and php -m command as bellow :
[my@webhk bbs]# php -m
[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
ereg
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
imap
json
ldap
libxml
mbstring
mcrypt
mhash
mysql
mysqli
mysqlnd
odbc
openssl
pcntl
pcre
PDO
pdo_mysql
PDO_ODBC
pdo_sqlite
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlrpc
xmlwriter
xsl
zip
zlib

[Zend Modules]

Shibo

luceos Thanks Luceos , i 've granted enough permission to root and meanwhile set 'Host' of root is '%' .
but , execute 'php flarum info' , still occurs error .

jordanjay29

Shibo I think luceos is suggesting you create a new mysql database user and assign it permissions to use that database. It's possible your server configuration prohibits the root user from being used in scripts.

Shibo

jordanjay29 let me to clean a question : execute 'php flarum info' command with the username and password of flarum database in 'configure.php' , is it correct ?

clarkwinkelmann

Shibo php flarum info is just a command you can run in the command line prompt (in Flarum directory) to output environment details about your Flarum.

Changing the database credentials is done by editing config.php, which is unrelated to the command above ?

Shibo

clarkwinkelmann yes , i thought it ,but , why does it happen the PDOException ? confused it ~

jordanjay29

Shibo it's not a graceful error, no, but the PDO exception is what's telling the program that the MySQL Username and Password can't be accepted. Flarum's error handling is rudimentary right now, which is why you see the full error text instead of a useful message.

Shibo

jordanjay29 thanks for your reply . that's interesting , now that you say mysql account error , why is the website accessible with username / password in config.php ?

Shibo

jordanjay29 and the website is working fine , if username and pasword can't e accepted of MYSQL , users can't open my website, right ? you can see there : http://bbs.lebit.io .
thanks