0 Replies Latest reply: Jan 14, 2013 1:59 PM by whatalotofrubbish RSS

    Connecting to MySQL databases using latest version

    whatalotofrubbish Community Member

      I have a web site up and running using MySQL and PHP using CS5.5 and a 4 year old version of Xampp.

       

      On my new machine I have installed the latest version of Xampp which has later versions of MySQL and PHP on it than my web site has. I have done my best to set up users on the latest MySQL with attributes that exactly match those in the old version. I can access them using phpMyAdmin and they seem to be the same. When I try to connect using my old script, I get the following error message:

       

      "The user specified as a definer ('username'@'192.168.0.%') does not exist"

       

      The php version is 5.4.4 and the mysql version is 5.5.25a with PHPadmin 3.5.2

      Using Dreamweaver CS6 on a win7 64 bit machine.

      My connection file is coded as below:

      Do I need a different method of connecting using the new MySQL and PHP? Or have I a problem in the set up of my Xampp?