close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 4/18/2013 10:37 am by john70964 | Last modified 4/20/2013 5:57 am by john70964 | 5946 views | 8 replies |

john70964

"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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

john70964

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

john70964

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

john70964

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post

john70964

I created a new user and the connection was made OK

Thanks for your help Jason

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...