https://dev.mysql.com/doc/refman/8.0/en/connection-access.html (rtfm ;-)
On Thu, Jan 23, 2020 at 2:12 PM Javier Guerrero García
wrote:
> myname@% and myname@localhost are totally different users. The first
> means "myname connecting from anywhere", while the second means "myname
> only when it
Have followed Javier's hints to edit view of staffviewposition by applying
security to the invoker instead of the definer. But still unable to solve
the problem ie unable to fetch view data. see
http://www.bbrclubhk.com/testdb/testdb.html as compared to the one in
another web hosting service