Creating website for first time. Error and cannot go further

Permalink
Error Message. Help is appreciated for I do not know what to do next. Thank you.
×
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

DeSp
View Replies:
ob7dev replied on at Permalink Reply
ob7dev
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';
DeSp replied on at Permalink Reply
DeSp
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.
ob7dev replied on at Permalink Reply
ob7dev
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
DeSp replied on at Permalink Reply
DeSp
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
DeSp replied on at Permalink Reply
DeSp
Thank you so very much!!!!
I will do as you recommend.
It is greatly appreciated.
Enjoy your day.
ob7dev replied on at Permalink Reply
ob7dev
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?
DeSp replied on at Permalink Reply
DeSp
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.
DeSp replied on at Permalink Reply
DeSp
PS I am using PHPMyAdmin.
ob7dev replied on at Permalink Reply
ob7dev
Are you using xampp / localhost or running on a live server?
DeSp replied on at Permalink Reply
DeSp
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