storde procedures

Discussion in 'MySQL' started by dizyn, Mar 5, 2008.

0
  1. #1
    I want to run procedures but i am not able to run it with normal users, i need root access, i can run them without root?

    Here is the error i am getting:

    <b>Warning</b>: mysqli::mysqli() [<a href='function.mysqli-mysqli'>function.mysqli-mysqli</a>]: (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in <b>/home/cmela/public_html/database/connections.php</b> on line <b>4</b><br />
    Error connecting MySQL: Access denied for user 'root'@'localhost' (using password: YES)


    I need to know can i run procedures without root?

    thank you
    -dizyn
     
    dizyn, Mar 5, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    You need to give the user execute privileges to execute SP's. You don't need root or anything, just execute.
     
    jestep, Mar 6, 2008 IP