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 <javi...@gmail.com> wrote: > 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/ >> >