An error occurred while trying to create the database.

Need help installing Joomla! 4.x? For all Joomla! 4.x installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
samlatif
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Oct 31, 2012 3:14 pm

An error occurred while trying to create the database.

Post by samlatif » Mon Aug 15, 2022 5:04 pm

I tried to install new J4, get an 'error occurred while trying to create the database.
The user may not have enough privileges to create a database. The required database may need to be created separately before you can install Joomla'
My question is from where I can get the j4 db tables to drop in the new db created?
Thank you

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27924
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: An error occurred while trying to create the database.

Post by imanickam » Mon Aug 15, 2022 6:03 pm

There is no need to create tables manually.

I would suggest creating a new database and for that database creating a user with ALL PRIVILEGES granted.

Once this done, you could just install Joomla with the database created. During the install process, Joomla will automatically create all the tables.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
ex-Joomla! Translations Coordination Team
Eegan - Support the poor and underprivileged

samlatif
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Oct 31, 2012 3:14 pm

Re: An error occurred while trying to create the database.

Post by samlatif » Tue Aug 16, 2022 2:34 pm

Thanks Imanickam, however, I already created a DB with all privileges' user and still get the same error message, maybe it is a shared server issue on siteground, it asks to create the db manually,
any suggestions?
Thanks

User avatar
ceford
Joomla! Ace
Joomla! Ace
Posts: 1161
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: An error occurred while trying to create the database.

Post by ceford » Tue Aug 16, 2022 3:52 pm

On a shared host you create a database and user with the host tools, typically cPanel. Then install Joomla.

See https://docs.joomla.org/J4.x:Hosting_Setup for more information.


Post Reply

Return to “Installation Joomla! 4.x”