title: Mysql CREATE DEFINER
body: <p>it's my first question here and I honestly made it after long investigation without answers.</p>
  
  <p>I have created an intranet web application that run on a CentOS web server, the application use another local server (always CentOS) for the mysql database.</p>
  
  <p>Inside the database I have created routines wich evey start like this:</p>
  
  <pre><code>CREATE DEFINER='localuser02'@'192.168.0.5' PROCEDURE 'Createuser'
  </code></pre>
  
  <p>The IP 192.168.0.5 is the IP of the server where application is installed.</p>
  
  <p>Until here all is ok the application is working.
  Now some days ago as the server that run the application is an old one, to add another server (I mean commodity server), what I was thinking is to do a traffic balance between them.</p>
  
  <p>Now I have setup correctly both servers to run the application, the problem is with the SQL DEFINER which have just one IP.</p>
  
  <p>My servers have now 192.168.0.5 and 192.168.0.6.</p>
  
  <p>Theoretically my new DEFINER should be like this:</p>
  
  <pre><code>CREATE DEFINER='localuser02'@'192.168.0.5, 192.168.0.6' PROCEDURE 'Createuser'
  </code></pre>
  
  <p>But I don't know how to proceed.</p>
  
  <hr>
  
  <p>thanks for the answer.</p>
  
  <p>For wildcard I have understand like using with percent like you said 192.168.% or like suggested by eggyal 192.168.0.%
  my question and concerns in doing this if it will work? Since my network is distributed like this:</p>
  
  <pre><code>192.168.0.1 - router
  192.168.0.2 - voip phone
  192.168.0.3 - voip phone
  192.168.0.4 - firewall
  192.168.0.5 - Server 01
  192.168.0.6 - Server 02
  192.168.0.7 - SQL Server
  192.168.0.8 - LAN Printer
  192.168.0.9 - First pc
  192.168.0.10 - Second pc
  </code></pre>
  
  <p>My question is having IP from 192.168.0.1 to xxx.10 reserved, if I add wildcard on SQL could be a collision with address I mean could the DEFINER try to authenticate for example on voip phone or a printer or the firewall instead of the two servers exclusively?</p>
  
  <p>Also second question, there is the possibility to list more than one IP to be more tidy like:</p>
  
  <p><code>CREATE DEFINER='localuser02'@'192.168.0.5, 192.168.0.6' PROCEDURE 'Createuser'</code></p>
  
  <p>Thanks in advance</p>