Do I have to create a database before I install composr?

Post

Posted
Rating:
#7225 (In Topic #1792)
DO I have to create a database before I can run the quick installer for Composr? or does the installer create the database as part of the install.

I have done it both ways and am having trouble. the second time I tried, I created a database and user/password but on proceeding I encounter a error message that reads "Could not connect to database-server (when authenticating) (Access denied for user 'apofrien_ocpo791'@'localhost' (using password: YES))"

Post

Posted
Rating:
#7235
Hi,

You generally would need to create the database yourself first.

Composr will try to autocreate the database if missing, but this would require a MySQL user with access to do this, typically the root user (not really a good idea to use such a high privileged user for the website DB user).

MySQL users can be a bit weird. In particular, they exist only for a particular database hostname. For example, you may create a user foo for hostname localhost, which would not work if accessing the database via 127.0.0.1 or example.com. Maybe that's your issue. Or maybe you just put in the wrong password or some accidental whitespace around the password.
2 guests and 0 members have recently viewed this.