Scrape data from a webpage and store them in a database
The database setup mydb should be in it's own function, or even just
a global since this script is rather minimal.  There's no reason to
duplicate this code.
If mysql.connector doesn't, I'd look for a database connector that
supports the with ... statement for connections and transactions
(relatively sure e.g. sqlalchemy supports that).  Because you can
always forget to call commit (or rollback), but with with you
have a little bit less mental overhead.
It's a simple script ... long term I'd worry about losing data that
way.  Also why is it dropping the whole table instead of, say,
DELETE FROM webdata; and only recreating the table if it doesn't
exist?
The bs4 part looks okay and the insert too; I'd perhaps have some
checks in there that you don't overflow on the 255 limit with the
review (or the name I suppose).  Also some warnings around empty
values might be good for you to debug / notice that something's off.
AFAIK requests is a good choice, you might also want to check the
status code though.


Okay, so long-term:


To be more flexible, look at argparse or any of the command line
parsing libraries so that you never have to edit the script in case
one of the parameters changes (database connection, URL).  I'd keep
the HTML querying like it is, that's usually not wise to put into a
configuration unless it changes frequently.