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

Post

Posted
Rating:
#8605 (In Topic #2868)
Avatar
Standard member
friendly is in the usergroup ‘Community saint’
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))"


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Business Art Gallery
powered by ocPortal
Online now: No Back to the top

Post

Posted
Rating:
#8620
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
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.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top
1 guest and 0 members have just viewed this.
Back to Top