CODEWITHSUNDEEP
phpmysql
vivek sharma
vivek sharma

Reputation: 1

Stored procedure access denied for user to database

CREATE DEFINER=`vicky`@`localhost` PROCEDURE `rundaily`(IN `yesterday` DATE)
NO SQL 
begin 
    declare csession varchar(128); 
    declare clastsession varchar(128); 
    declare cactivityid int; 
    declare clastactivityid int; 
    declare cproductsk int; 
    decl

#1044 - Access denied for user 'vivek'@'192.168.0.%' to database 'vivek_dev'

Upvotes: 0

Views: 3242

Answers (1)

jophab
jophab

Reputation: 5509

The error tells that user vivek do not have proper privilege over the database vivek_dev.

You need to grant privileges for the user over the database to avoid this error.

Run the following code as root.

grant all privileges on DB Name .* to 'vivek'@'192.168.0.%' identified by "PASSWORD";

Change the password. Read about Grant Statement here

Upvotes: 1

Related Questions