Replacing table prefix in myphpadmin and wp-config disables WP dashboard


New Member
I have deployed openlitespeed-wordpress in GCP and it just selects the default values in wp-config.php including DB_NAME and DB_USER as 'wordpress" and table_prefix as 'wp_'
i changed the database name in both phpmyadmin and wp-config without any issues but when i replace the table prefix it disables the access to WP dashboard and login redirects to homepage.
I looked up this issue and found some suggestions that it might happen if some enteries in 'options' and 'usermeta' tables still have old prefix but i cannot find any entry with old prefix(wp_).
Is there any other solution to change the table_prefix through console? Thanks