"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

judging by the error, your page is trying to access a stored procedure, when creating the stored procedure and the root user does not have privleges to run it.You will need to grant the root user privileges to access the stored procedure.

Thank Jason
I think the users are the same for both of these connections.

The error is saying otherwise.

the error is saying that the root user does not have access to the database being used by this connection.

Thanks Jason
I am attaching a picture of the set up perhaps you can see what I need to do to correct this.
Thank you
John

your screen shot shows the root@127.0.0.7 user, your connection uses localhost for the host name.

try changing the connection to use the 127.0.0.7 address for the connection.

Thanks Jason
I think you misread the 127.0.0.7 should be 127.0.0.1
When I changed hostname_ConnNo1 to 127.0.0.1 in the connection file I still get

The user specified as a definer ('root'@'localhost') does not exist.

when are you getting the error:
The user specified as a definer ('root'@'localhost') does not exist.

Testing the connection? or in the web browser when testing a page?

if when testing a page, what is the URL in the address bar?

if when testing the connection, what is the URL PRefix in the site settings for the testing server?

is your screen shot of navicat showing your local mysql database? or a remote mysql database?

I created a new user and the connection was made OK

Thanks for your help Jason