Credentials supplied to concrete5 to access the sql database did not work.

Typically you don't use 'root' as user, but you make a separate user for each site, make a database, then grant privileges to that user on the database and a password.

If you are using phpMysql, look up tutorial on how to make a new user and database and give it privileges, then supply those to c5 on the install.

If you are using mysql command line:
create database DATABASE_NAME;
create user DATABASE_USER;
grant all on DATABASE_NAME.* to 'DATABASE_USER'@'localhost' identified by 'PASSWORD';

Doctrine\DBAL\Driver\PDOException thrown with message "SQLSTATE[HY000] [2002] Connection refused"

Stacktrace:
#22 Doctrine\DBAL\Driver\PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47
#21 PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#20 PDO:__construct in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#19 Doctrine\DBAL\Driver\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Connection/PDOConnection.php:22
#18 Concrete\Core\Database\Connection\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Driver/PDOMySqlConcrete5/Driver.php:18
#17 Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
#16 Doctrine\DBAL\Connection:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
#15 Doctrine\DBAL\Connection:getDatabasePlatformVersion in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
#14 Doctrine\DBAL\Connection:detectDatabasePlatform in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
#13 Doctrine\DBAL\Connection:getDatabasePlatform in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:57
#12 Concrete\Core\Database\Connection\ConnectionFactory:createConnection in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:71
#11 Concrete\Core\Database\Connection\ConnectionFactory:make in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:185
#10 Concrete\Core\Database\DatabaseManager:makeConnection in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:94
#9 Concrete\Core\Database\DatabaseManager:connection in /var/www/html/concrete/concrete/src/Support/Facade/Database.php:26
#8 Concrete\Core\Support\Facade\Database:__callStatic in /var/www/html/concrete/concrete/src/Package/PackageList.php:73
#7 Concrete\Core\Package\PackageList:get in /var/www/html/concrete/concrete/src/Application/Application.php:159
#6 Concrete\Core\Application\Application:setupPackageAutoloaders in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:489
#5 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:initializePackages in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:170
#4 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:bootHttpSapi in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:125
#3 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:boot in /var/www/html/concrete/concrete/src/Foundation/Runtime/DefaultRuntime.php:80
#2 Concrete\Core\Foundation\Runtime\DefaultRuntime:boot in /var/www/html/concrete/concrete/bootstrap/start.php:35
#1 require in /var/www/html/concrete/concrete/dispatcher.php:36
#0 require in /var/www/html/concrete/index.php:3


Thank you for your reply. I was able to get in and now receive this error message. Help again appreciated.

I've never had that specific problem, which seems to be due to the database not accepting connections on the port specified.

The default mysql port is 3306

Hello
Thank you. I set the post as you suggested and was then able to access my admin account. Today though I tried again to access it and the same message appeared again.
Suggestions greatly appreciated.
Thank you!!!!
Denise
Doctrine\DBAL\Driver\PDOException thrown with message "SQLSTATE[HY000] [2002] Connection refused"

Stacktrace:
#22 Doctrine\DBAL\Driver\PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47
#21 PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#20 PDO:__construct in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#19 Doctrine\DBAL\Driver\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Connection/PDOConnection.php:22
#18 Concrete\Core\Database\Connection\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Driver/PDOMySqlConcrete5/Driver.php:18
#17 Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
#16 Doctrine\DBAL\Connection:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
#15 Doctrine\DBAL\Connection:getDatabasePlatformVersion in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
#14 Doctrine\DBAL\Connection:detectDatabasePlatform in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
#13 Doctrine\DBAL\Connection:getDatabasePlatform in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:57
#12 Concrete\Core\Database\Connection\ConnectionFactory:createConnection in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:71
#11 Concrete\Core\Database\Connection\ConnectionFactory:make in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:185
#10 Concrete\Core\Database\DatabaseManager:makeConnection in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:94
#9 Concrete\Core\Database\DatabaseManager:connection in /var/www/html/concrete/concrete/src/Support/Facade/Database.php:26
#8 Concrete\Core\Support\Facade\Database:__callStatic in /var/www/html/concrete/concrete/src/Package/PackageList.php:73
#7 Concrete\Core\Package\PackageList:get in /var/www/html/concrete/concrete/src/Application/Application.php:159
#6 Concrete\Core\Application\Application:setupPackageAutoloaders in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:489
#5 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:initializePackages in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:170
#4 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:bootHttpSapi in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:125
#3 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:boot in /var/www/html/concrete/concrete/src/Foundation/Runtime/DefaultRuntime.php:80
#2 Concrete\Core\Foundation\Runtime\DefaultRuntime:boot in /var/www/html/concrete/concrete/bootstrap/start.php:35
#1 require in /var/www/html/concrete/concrete/dispatcher.php:36
#0 require in /var/www/html/concrete/index.php:3

Thank you so very much!!!!
I will do as you recommend.
It is greatly appreciated.
Enjoy your day.

Are you using phpMyAdmin or mysql from command line?

Were you able to access your site in the past and just recently started having problems? Or is this a new install?

I have been able to access and edit the site each day since I created it. I get this error each day I am working with it. I restart Apache and MySql and then it works again. It is just extra steps and I am not certain how to correct this. Thank you for your concern and guidance.

PS I am using PHPMyAdmin.

Are you using xampp / localhost or running on a live server?

Help appreciated. I received this error and have do not know how to access my admin site now. Thank you!!!
Doctrine\DBAL\Driver\PDOException thrown with message "SQLSTATE[HY000] [2002] Connection refused"

Stacktrace:
#22 Doctrine\DBAL\Driver\PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47
#21 PDOException in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#20 PDO:__construct in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
#19 Doctrine\DBAL\Driver\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Connection/PDOConnection.php:22
#18 Concrete\Core\Database\Connection\PDOConnection:__construct in /var/www/html/concrete/concrete/src/Database/Driver/PDOMySqlConcrete5/Driver.php:18
#17 Concrete\Core\Database\Driver\PDOMySqlConcrete5\Driver:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
#16 Doctrine\DBAL\Connection:connect in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:429
#15 Doctrine\DBAL\Connection:getDatabasePlatformVersion in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389
#14 Doctrine\DBAL\Connection:detectDatabasePlatform in /var/www/html/concrete/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:328
#13 Doctrine\DBAL\Connection:getDatabasePlatform in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:57
#12 Concrete\Core\Database\Connection\ConnectionFactory:createConnection in /var/www/html/concrete/concrete/src/Database/Connection/ConnectionFactory.php:71
#11 Concrete\Core\Database\Connection\ConnectionFactory:make in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:185
#10 Concrete\Core\Database\DatabaseManager:makeConnection in /var/www/html/concrete/concrete/src/Database/DatabaseManager.php:94
#9 Concrete\Core\Database\DatabaseManager:connection in /var/www/html/concrete/concrete/src/Support/Facade/Database.php:26
#8 Concrete\Core\Support\Facade\Database:__callStatic in /var/www/html/concrete/concrete/src/Package/PackageList.php:73
#7 Concrete\Core\Package\PackageList:get in /var/www/html/concrete/concrete/src/Application/Application.php:159
#6 Concrete\Core\Application\Application:setupPackageAutoloaders in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:489
#5 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:initializePackages in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:170
#4 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:bootHttpSapi in /var/www/html/concrete/concrete/src/Foundation/Runtime/Boot/DefaultBooter.php:125
#3 Concrete\Core\Foundation\Runtime\Boot\DefaultBooter:boot in /var/www/html/concrete/concrete/src/Foundation/Runtime/DefaultRuntime.php:80
#2 Concrete\Core\Foundation\Runtime\DefaultRuntime:boot in /var/www/html/concrete/concrete/bootstrap/start.php:35
#1 require in /var/www/html/concrete/concrete/dispatcher.php:36
#0 require in /var/www/html/concrete/index.php:3