Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Archive › PowerCMS › MySQL Query Browser can't connect to MySQL Serve

MySQL Query Browser can't connect to MySQL Serve

Thread began 10/29/2009 1:29 pm by karenamck240415 | Last modified 10/30/2009 9:37 am by Jason Byrnes | 5340 views | 4 replies |

10/29/2009 1:29 pm | #1 karenamck240415

MySQL Query Browser can't connect to MySQL Serve

I am using the MySQL Query Browser for the first time and trying to get through the PowerCMS instructions under "Using MySQL Query Browser". I have no idea what to do, I keep getting error 1045.

The using phpMyAdmin step went fine.

10/29/2009 4:05 pm | #2 Jason ByrnesWebAssist

the error 1045 means the user name and password you are entering is not correct.

Are you trying to connect to a local mySQL Server or a remote MySQL Server?

If it is a local MySQL Server, set the Host name to Localhost.

if it is a remote MySQL Server, you will need to find out from your host a few things, 1) Do they allow remote connections to the MySQL server 2) what is the mySQL Server address to use.

10/29/2009 7:02 pm | #3 karenamck240415

MySQL Query Browser can't connect to MySQL Serve

I know the user name and pass word are incorrect but I have tried all the what are suppose to be the correct ones

it is a local server and I have tried localhost and 127.0.0.1

10/29/2009 7:12 pm | #4 karenamck240415

MySQL Query Browser can't connect to MySQL Serve

I figured this out but now I don't know what the .sql file I need to import is. It appears to be a user table. Was that provided by PowerCMS?

10/30/2009 9:37 am | #5 Jason ByrnesWebAssist

the CMS.sql file is in the Database folder of the PowerCMS files.

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.