Answered Access denied for user 'modxdatabase'@'localhost' (using password: YES)

Hello,
I'm stuck on the next step of the MODX Wizard setup, following this post http://forums.modx.com/thread/97701/make-sure-your-home-domain-com-public-html-core-cache-directory-exists-and-is-writable-by-the-php-process#dis-post-528533.

I created a brand new MODX CMS and entered the following Connection Information:
Database type: mysql
Database host: localhost
Database login name: modx database
Database password: <modx database password>
Database name: modx
Table prefix: modx_
Test database server connection and view collations, outputs the following:

Connecting to database server:
Could not connect to the database server. Check the connection properties and try again.

[2015-07-19 12:40:11] (ERROR in xPDOConnection::connect @ /home/domain.com/public_html/core/xpdo/xpdo.class.php : 3046) SQLSTATE[28000] [1045] Access denied for user 'modxdatabase'@'localhost' (using password: YES)

[2015-07-19 12:40:11] (ERROR in xPDOConnection::connect @ /home/domain.com/public_html/core/xpdo/xpdo.class.php : 3046) SQLSTATE[28000] [1045] Access denied for user 'modxdatabase'@'localhost' (using password: YES)

I'm not clear whether I should enter a different username and password?
The wizard indicates to me I need to create a new MODX database username and password.

Not sure if the code is relevant:
[ed. note: eiger3970 last edited this post 8 years, 9 months ago.]

Make sure to enter the full database name. It often will be your servername_database. Your user will also need full privileges, if that hasn't been setup for the user already.

Thanks. As this is a new MODX install, there is no MODX database previously installed.
I followed the MODX wizard to setup a new MODX system and was asked to enter a new database name.
I entered the following details.
Database type: mysql
Database host: localhost
Database login name: modx database
Database password: <modx database password>
Database name: modx
Table prefix: modx_

However, then MODX gives the error:
[2015-07-19 12:40:11] (ERROR in xPDOConnection::connect @ /home/domain.com/public_html/core/xpdo/xpdo.class.php : 3046) SQLSTATE[28000] [1045] Access denied for user 'modxdatabase'@'localhost' (using password: YES)

[2015-07-19 12:40:11] (ERROR in xPDOConnection::connect @ /home/domain.com/public_html/core/xpdo/xpdo.class.php : 3046) SQLSTATE[28000] [1045] Access denied for user 'modxdatabase'@'localhost' (using password: YES)

I'm searching for some clear instructions on how to setup MODX to fix whatever this error is caused by. http://rtfm.modx.com/revolution/2.x/getting-started/installation/basic-installation [ed. note: eiger3970 last edited this post 8 years, 9 months ago.]

I think the easiest way to fix this is to create the modx database yourself in PhpMyAdmin. I should be completely empty. Be sure to select utf8 as the character set and create a user with full rights to the DB. Use the database name and that user's database credentials in the database section when you run setup (to make things more secure, use a different username and password for the MODX Manager login).

Thanks.
I looked up how to use MODX PhpMyAdmin, but I don't have a cloud account https://modxcloud.com/userguide/using-modx-cloud/tools-and-configuration/database-management-phpmyadmin-and-remote-tools.html

Also, nothing about MODX and phpMyAdmin herehttp://wiki.modxcms.com/index.php/PhpMyAdmin

Do you mean to use CLI to configure some files? What would the path be in MODX files to the phpMyAdmin, as no search results are helping yet? [ed. note: eiger3970 last edited this post 8 years, 9 months ago.]

So, is MODX supposed to install its own database or do I enter a username and password for some database running on the currently installed webserver?

The MODX documentation I understand, says MODX will install a database? http://rtfm.modx.com/revolution/2.x/getting-started/installation/basic-installation

Yeah, no... it does not install the database. You have to create the database first, create user and assign to the database (or assign an existing user to the database), make sure to set full privileges for the user and then run the installer.

It does say it'll create the database but it does not.

MODX and phpMyAdmin are two different beasts. MODX is the CMS, phpMyAdmin is where you administer your databases. In cPanel (and most other server control panels) however you can create the database and user, set the user's privleges without entering phpMyAdmin at all. [ed. note: frogabog last edited this post 8 years, 9 months ago.]

I think MODX will try to create the DB, but it often fails. I usually just create it myself first. As Frobabog says, you'll find PhpMyAdmin in your host's admin panel (e.g. cPanel) in the database section.

Thanks.
My host doesn't have cPanel and I'm trying to install phpMyAdmin, but error: need MySQL 5.5 or later.

Upgrading MySQL from 5.1.73 with command # sudo yum update mysql-server, gives error: No Pakcages marked for Update.

Wow, 5.1 was released over 10 years ago. MySQL 5.5 was released about 3 years ago, and 5.6 has been available for a while.

You might consider this: http://bobsguides.com/modx-friendly-hosts.html