"The user specified as a definer ('root'@'localhost') does not exist"
I have created a results details page in Dataassist but when I try to run the page I get the error
"The user specified as a definer ('root'@'localhost') does not exist"
The connection is simliar to
<?php
# FileName="WADYN_CONN.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ConnNo1 = "localhost";
$database_ConnNo1 = "xxx2013";
$username_ConnNo1 = "root";
$password_ConnNo1 = "password";
@session_start();
$ConnNo1 = mysql_pconnect($hostname_ConnNo1, $username_ConnNo1, $password_ConnNo1) or trigger_error(mysql_error(),E_USER_ERROR);
?>
==========================
I have another site which works perfectly well where the connection is similar to:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conn1 = "localhost";
$database_conn1 = "yyyy";
$username_conn1 = "root";
$password_conn1 = "password";
$conn1 = mysql_pconnect($hostname_conn1, $username_conn1, $password_conn1) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Can anyone see why the connection should no be working please.
Many thanks
John