Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

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

1 Answer 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

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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