用户对数据库的存储过程访问被拒绝

Question

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'

Answer 1

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