Re: MySQL view definer

2020-01-23 Thread Javier Guerrero García
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

Re: MySQL view definer

2020-01-23 Thread dw1970
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