Database user specified as a definer

by Karthick88it   Last Updated September 11, 2019 23:06 PM

I have a view in my database. problem is below

Error SQL query:

FROM `lumiin_crm_prod`.`v_contact` 

MySQL said:

1449 - The user specified as a definer ('lumicrm'@'%') does not exist

i Google for a solution

User is created for Host & not for Global.

How to create the User for Global ????

Answers 1

Long story short: You do not have the user 'lumicrm'@'%' on the DB Server.

Login to MySQL and run

SELECT user,host FROM mysql.user WHERE user='lumicrm';

Let's say you see the user 'lumicrm'@'localhost'

You have to create the user so that the view can be recognized. There are three(3) things you can try

Try This #1

Login to MySQL as lumicrm and run this command


Given the output of that query:

  • Copy the output of that query to a Text File
  • Change the host portion of the userhost to '%';
  • Copy and Paste into a MySQL Session to create the View.

Try This #2

CREATE TABLE mysql.lumicrm LIKE mysql.user;
INSERT INTO mysql.lumicrm SELECT * FROM mysql.user WHERE user='lumicrm';
UPDATE mysql.lumicrm SET host='%';
INSERT INTO mysql.user SELECT * FROM mysql.lumicrm;
DROP TABLE mysql.lumicrm;

Now you have the MySQL user 'lumicrm'@'localhost' hacked in

Try This #3

Dump the Views to a Text File. Here are my posts on how to do this:

Edit the user for the View with the appropriate username. Copy the View Creation Code and Paste into a MySQL Session to create the View.

Give it a Try !!!

May 02, 2013 17:51 PM

Related Questions

Problem with mysqldump and view

Updated June 14, 2018 23:06 PM

Problem with View When Restoring a MySQL Backup

Updated June 17, 2016 08:02 AM