#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

mifzal.m

• December 14, 2021 19:32

I have changed my hosting Company and I have a backup of my SQL file. When I tried to import that to my new hosting Company via phpmyadmin, I get this error. How can I fix this problem? SQL query: /*!50001 CREATE ALGORITHM=UNDEFINED / /!50013 DEFINER=onlinea2@localhost SQL SECURITY DEFINER / /!50001 VIEW vwallorders AS select tbl_gf_codes.CodeId AS Id,cast(tbl_gf_codes.RequestedAt as date) AS OrderDate,tbl_gf_codes.UserId AS UserId from tbl_gf_codes union select tbl_gf_codes_slbf.CodeId AS Id,cast(tbl_gf_codes_slbf.RequestedAt as date) AS OrderDate,tbl_gf_codes_slbf.UserId AS UserId from tbl_gf_codes_slbf union select tbl_gf_log_requests.LogRequestId AS Id,cast(tbl_gf_log_requests.RequestedAt as date) AS OrderDate,tbl_gf_log_requests.UserId AS UserId from tbl_gf_log_requests */ MySQL said #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

• 

  cPanelAnthony

  • December 15, 2021 16:44

  Hello! Can you let me know if

  0
• 

  mifzal.m

  • December 15, 2021 16:52

  Thank you for your reply. It's too technical for me to understand. Can you explain me step by step please?

  0
• 

  cPanelAnthony

  • December 22, 2021 17:42

  Thank you for your reply. It's too technical for me to understand. Can you explain me step by step please?

  
  Hello again! Were there any specific steps you couldn't follow? If you're having issues with the article, I would recommend reaching out to your web hosting provider or reaching out to a systems administrator to help. You can look for a systems administrator to help here.

  0

Please sign in to leave a comment.