Newbie Setup Database errors in Joomla 3.9.21

[ByterBit44]

Newbie Setup Database errors


I get scores of errors like:

Error
INSERT command denied to user 'joomla'@'localhost' for table '#__viewlevels'
INSERT command denied to user 'joomla'@'localhost' for table '#__utf8_conversion'
INSERT command denied to user 'joomla'@'localhost' for table '#__action_log_config'

When I attempt to start Joomla after an install.

I’m using the 3.9.21 package on a Win 10 machine, with MYSQL 8.0.21

I choose this version of Joomla as it’s identical to a running system I’ve been asked to support.
I wanted to get comfortable with Joomla prior to working with a production environment.

For what it’s worth, I’ve been coding with PHP/MYSQL for almost 20 years, so I assume I followed the setup instructions OK with MYSQL, but when it come to Joomla my ignorance is profound –

Many thanks for any help!

[ByterBit44]

Well -
Debugging this myself:
I already had:

[mysqld]
default-authentication-plugin=mysql_native_password

so that wasn't the issue.

I then switched to MYSQL 5.7.43
and that helped, in that I now see Joomla tables in the DB.
However -
I still cant login, and none of the methods I read of in help or on [youtube] seem effective.
*sigh*
Sort of running out of time to make this work :>(

[gws]

I’m using the 3.9.21 package

are you sure?
If you are using a WAMP on windows the default MySql user is root and the password is blank/empty ie not used.

[ByterBit44]

Thanks for the reply!

Yes - I'm sure. I have HeidiSQL on the machine, and I've created a joomla user with a simple password.
I've done similar things with MYSQL 1000's of times -

In response to your note I tried to use "Root" and a blank PW - no change.

I've gone around the Joomla install process maybe 10 times now.
I see tables in HeidiSQL -
But I can't get beyond the 3rd Joomla install screen.

I get "Error Some errors occurred in backing up the database."
When I make the other choice I get
"Error
Some errors occurred deleting the database."

I see no way to debug the issue.

[ByterBit44]

Well -
I tried, *one last time* -
And of course the computer gods knew that - and let it install with root -

But -
Now I get:

" Warning: FOFModelBehavior::onBeforeBuildQuery(): Argument #1 ($model) must be passed by reference, value given in C:\wamp\www\joomla\libraries\fof\utils\observable\event.php on line 63
Call Stack"

I'm getting the sense that I'd rather shoot myself than take on the job of supporting this in production.

I suspect it would take someone well versed in the environment.
Do you know a good Joomla consultant?

[toivo]

Welcome to the Joomla forum!

" Warning: FOFModelBehavior::onBeforeBuildQuery(): Argument #1 ($model) must be passed by reference, value given in C:\wamp\www\joomla\libraries\fof\utils\observable\event.php on line 63

This PHP warning sounds like it is coming from Akeeba Backup. Is the version of Akeeba Backup compatible with Joomla 3.9.21 and the version of PHP you are using - check Akeeba Backup - Compatibility?

PHP warnings can be suppressed by changing the option 'Error Reporting' in the Global Configuration' to 'None', which is the recommended setting for production sites.

Please post the results from Forum Post Assistant (FPA) by following the instructions at https://forumpostassistant.github.io/docs/ so that our volunteer Joomla experts can review the configuration.

Feel free to ask further questions, but please post them as new topics into the right sub forums, for example General Questions/New to Joomla! 3.x.