0

I have a view in my database. problem is below

Error SQL query:

SELECT * 
FROM `lumiin_crm_prod`.`v_contact` 
LIMIT 1 ;

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 ????

migrated from stackoverflow.com May 2 '13 at 15:24

This question came from our site for professional and enthusiast programmers.

  • Offtopic. Not a programming question (directly). Try the dba SE site. – Marc B May 2 '13 at 15:15
2

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

SHOW GRANTS FOR CURRENT_USER();

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;
FLUSH PRIVILEGES;
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 !!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.