myname@% and myname@localhost are totally different users. The first means "myname connecting from anywhere", while the second means "myname only when it connects locally". Review permissions on the whole thing (tables, views, user grants, etc...).
https://stackoverflow.com/questions/11634084/are-users-user-and-userlocalhost-not-the-same On Thu, Jan 23, 2020 at 2:05 PM dw1970 <dw1...@gmail.com> wrote: > 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 provider that works. > http://www.bbrchk.com/testdb/testdb.html > > Tried to enable DB query log but the web hosting provider disallow me to do > so because the service provided is a shared web hosting server which > enabling DB query log is prohibited. > > Still stuck with the problem of fetching view data. Any suggestions > welcomed. > > Regards, > David > > > > > > -- > Sent from: http://apache-flex-users.2333346.n4.nabble.com/ >
