Reply to thread

Message

<blockquote data-quote="jameson_uk" data-source="post: 970987" data-attributes="member: 11220">You are specifying a user:&nbsp;&nbsp;I am assuming you are trying to connect from the same machine that hosts the database?How did you setup this database?&nbsp;Do you have MySQL workbench installed?&nbsp; (<a href="http://dev.mysql.com/downloads/workbench/" target="_blank">http://dev.mysql.com/downloads/workbench/</a>)Stop TV Service and MySQL service in windows then go into workbench.If necessary add a new connection (just accept all the defaults)&nbsp;Go into manage security and check the connection you probably just added (mine is mysqld@localhost)&nbsp;Go to the options file section and on security tab tick the &quot;skip-grant-tables&quot; option&nbsp;Now go to the startup / showdown section and restart the server.&nbsp;Finally go to the home page and connect to the connection for the SQL Development tool.&nbsp;In there run[code]select * from mysql.user;[/code]&nbsp;Mainly interested in user and host columns.&nbsp;&nbsp; What values do you have there?&nbsp;Afterwards go back to the admin stuff.&nbsp; Stop the server, untick the &quot;skip-grant-tables&quot; option, apply and start the server again</blockquote>

[QUOTE="jameson_uk, post: 970987, member: 11220"] You are specifying a user: I am assuming you are trying to connect from the same machine that hosts the database? How did you setup this database? Do you have MySQL workbench installed? ([url]http://dev.mysql.com/downloads/workbench/[/url]) Stop TV Service and MySQL service in windows then go into workbench. If necessary add a new connection (just accept all the defaults) Go into manage security and check the connection you probably just added (mine is mysqld@localhost) Go to the options file section and on security tab tick the "skip-grant-tables" option Now go to the startup / showdown section and restart the server. Finally go to the home page and connect to the connection for the SQL Development tool. In there run [code]select * from mysql.user;[/code] Mainly interested in user and host columns. What values do you have there? Afterwards go back to the admin stuff. Stop the server, untick the "skip-grant-tables" option, apply and start the server again [/QUOTE]

Verification