Increase privileges for user account

upsforum

• April 30, 2017 02:33

An account needof run this query but mysql require super user privileges CREATE DEFINER=`AR20190_incitta`@`%` PROCEDURE `spTipiCasa_select`() SELECT tbTipiCasa.IDTipoCasa, tbTipiCasa.Descrizione FROM tbTipiCasa

• 

  rpvw

  • April 30, 2017 09:51

  cPanel > DATABASES > MySQL Databases Look at the Current Databases, and click on the 'Privileged User' you want to change the privileges for (not the dustbin !!!). Manage User Privileges as required, and click on 'Make Changes' youtube.com/watch?v=lXnvDD9j6Hs

  0
• 

  upsforum

  • April 30, 2017 12:30

  in Cpanel > DB I active all provileges for it

  0
• 

  rpvw

  • April 30, 2017 13:54

  You may find this page of the MySQL manual useful. MySQL :: MySQL 5.7 Reference Manual :: 14.1.16 CREATE PROCEDURE and CREATE FUNCTION Syntax

  0
• 

  cPanelMichael

  • May 02, 2017 17:47

  Hello, You won't be able to grant the SUPER privilege to a database user with cPanel access alone. Assigning this privilege requires root access to the system: how to add super privileges to mysql database? How to grant super privilege to the user? That said, I'd check with the developer of the application you are using to see if there's a workaround to assigning that privilege to a database user due to the potential security risks: MySQL :: MySQL 5.6 Reference Manual :: 6.2.1 Privileges Provided by MySQL Thank you.

  0

Please sign in to leave a comment.