why does wp core install say table 'wp_options' doesn't exist [duplicate]

Question

Im using wp cli on my bedrock directory setup and have the files in the wp dir. now installing the core using

wp core install --url=xxx --title=xxx --admin_user=xxx --admin_email=xxx --admin_password=xxx

and gives

PHP Fatal error: Uncaught mysqli_sql_exception: Table 'xxx.wp_options' doesn't exist in

The target db is empty with no tables. Please suggest.

Answer 1

Found out the problem was I was using php8. The same wp cli command worked properly in php74