Server / Network Problems with SRJC MySQL databases

Advanced Dreamweaver students:   If you are having problems connecting to your MySQL database – either with Dreamweaver’s Database Connection/Databases Panel or with MySQL Workbench, please post a comment below with your username and the specific error number or problem you are having, which product you are using, on which operating system, etc. Be as specific as you can, for example:  ” My username is jperetz and I am using a Mac and I can connect to MySQL and see the tables in Dreamweaver, but MySQL Workbench crashes when I click on a connection.“  or “My username is jperetz and I am using Windows 7 and in Dreamweaver I get an FTP error  xxx when I test the  database connection to my MySQL database.

34 comments for “Server / Network Problems with SRJC MySQL databases

  1. March 4, 2011 at 12:08 am

    Dear IT Guru’s

    Please check my sequel account for errors. My password to the mysql server is as follows:

    Pwd: 1m7xcFCM

    I am having trouble accessing the server for my Advanced dreamweaver Class.

    None of the passwords work through mysql workbench.

    Neither from navicat – not at school nor from at home.

    I get the following error –

    1045 – Access denied for ‘dmcquoid_admin’@’′(using password: YES)

    I have tried to connect from the Maggini 2nd floor Lab and from my home.

    Any help to log on successfully would be appreciated.


    Des McQuoid

  2. March 4, 2011 at 8:53 am

    Using a MacBook, in Dreamweaver, I get the following error message when trying to connect to the SRJC SQL server:
    “1. There is no testing server running on the server machine.
    2. The testing server specified for this site does not map to the URL.
    Verify that the URL Prefix maps to the root of the site.”

    My user name is lmcbee. The testing server tests properly when I test it.
    The url maps to the root of the site.
    When is it necessary to use ~lmcbee and when is it necessary to use just lmcbee (no tilde)?
    I am able to connect with MySQL Workbench.

  3. Leeana
    March 4, 2011 at 9:03 am

    I am using a PC with Windows 7 and my user name is lrunning.

    I can connect to MySQL Workbench and create a table but it does not show up in Dreamweaver under Databases. Dreamweaver says there is no table.

    I have tried this at the JC and at home and the table does not show up.
    Thanks Leeana

  4. March 4, 2011 at 9:11 am

    In reference to the previous regarding the failure to connect to the SRJC SQL server…….
    Forgot to send my user info:
    Admin User:
    Username: lmcbee_admin
    Password: WxSg3f2B

  5. March 4, 2011 at 11:19 am

    Is there a way to do the exercises in lesson six without the SRJC SQL connection?

  6. Lisa Byrnes
    March 4, 2011 at 11:45 am

    My username is lbyrnes, I’m using Windows 7 and I get this error when I try to connect to MySQL from Dreameaver:

    MySQL Error#:2013

    Lost connection to MySQL server at ‘reading initial communication packet’, system error:110

    I have also tried connecting to MySQL through Dreamweaver on a computer at Maggini 2nd floor Lab with no luck.

    However, I haven’t experienced any problems on MySQL Workbench, everything is working fine on there. So it must be an issue with Dreamweaver.

    Admin User:
    Username: lbyrnes_admin
    Password: dPmHWWoJ

  7. Mitch
    March 4, 2011 at 2:19 pm

    Hi, I am using windows. I had success creating a table in the database with workbench. And dreamweaver will let me connect to the server from the databases panel. The problem is that dreamweaver shows that there are no tables whilst i can see the table in workbench. This is going to make doing the exercises rather difficult no?

  8. March 4, 2011 at 7:51 pm

    Linda – the error that you have seems to be more of a problem with your Dreamweaver Site definition – check the URL in the test server to make sure that it is aligned with the Server Root.

  9. March 4, 2011 at 7:55 pm

    MItch & Leeana – you problems both appear to be the same. I would suggest that you make sure that you are logging in as the same user for each connection. In MySQL, typically one user cannot see tables created by another user, so that may be what is causing this. Let me know if that is not the case.

  10. Mitch
    March 5, 2011 at 12:06 am

    So I don’t think that my user log in is the problem. I still can not see my tables in dreamweaver. Also, about 75% of the time I get an error when connecting via dreamweaver: mySQL error # 2013. Googling this leeds me to believe there is either a problem with the server at the JC, or that my dreamweaver is consuming too much time in the connection process, and timeout occurs… Any thoughts?

  11. Mark Alarie
    March 5, 2011 at 12:24 pm

    I seem to be able to get into my database via MySQL Workbench and can see the tables in Dreamweaver but,

    after I inserted the server behaviors into the add user page and test in either in Live View or a browser the record doesn’t get added and in the browser I get this message at the top of a new page. Also, the new record never does get added via the form.

    Incorrect table name ”

    I think I am using the correct table name because it is selected directly from a dialog box.
    Any ideas?

    Thanks. Mark

  12. March 5, 2011 at 12:58 pm

    Mark – Have you uploaded the Connections folder to the server in the site root folder?

  13. Mark Alarie
    March 5, 2011 at 2:05 pm

    I think I have made it work in the browser!!
    I googled this answer:
    I removed the “extra set of back ticks” as suggested around the table name

  14. March 5, 2011 at 2:36 pm

    Good catch, right from Mr Powers himself. I wonder what you did to get the extra back ticks.

  15. March 5, 2011 at 3:48 pm

    I don’t think the problem is the testing server set up.
    Here’s what I have:
    server name:
    Connect using: FTP
    FTP address:
    Username: lmcbee
    Password: (yep….I’m using the right one)
    Root Directory: public_html/
    Web URL:
    But, maybe I’m making progress, I am now getting the same error that Des is getting:
    MySQL Error#: 1045
    Access denied for user ‘lmcbee’@'localhost’ (using password: YES)

    Admin User:
    Username: lmcbee_admin
    Password: WxSg3f2B

    • March 6, 2011 at 11:03 am

      Linda – I will let the server administrator know you’re getting this error.

  16. Mark Alarie
    March 5, 2011 at 4:10 pm

    one thing that hung me up for a while
    When setting up the database connection in MySQL Workbench,
    I used the Hostname:

    I first used that for the MySQL connection in the Dreamweaver Database panel–
    didn’t work and got error messages similar to what I see here,

    this worked in Dreamweaver
    MySQL Server localhost

    I don’t quite get why it is localhost (because the database is not on my local computer), but when I changed it, Dreamweaver would connect for me.
    Maybe this will help someone.

    • March 6, 2011 at 11:02 am

      Localhost is used because the connection is from the webserver/PHP processor to the database, both are running on

  17. Shelby Erickson
    March 6, 2011 at 10:27 am

    I am using a MacBook Pro, OS 10.6.6, and have installed the MySQL Workbench 5.2.31. In class, I was able to establish 2 connections–one to the student server and one for I created a table based on the student server connection and got an error when I tried to save. (I’m not sure what the error was, but my program crashed). Since then, I have not been able to access the program. When opening, I can see the initial window that shows my saved connections and I can even create a new connection, but when I try and select any one of them to access the MySQL editor, I crash. I’ve reinstalled the program, but I continue to get the same result.

    Any ideas would be welcomed!
    thanks, Shelby

    • March 6, 2011 at 11:01 am

      Shelby – Have you tried to create a MySQL connection using Dreamweaver to see if you can login that way? It is explained in the book and in a blog post.

  18. Shelby Erickson
    March 6, 2011 at 3:32 pm

    Yes, I was successful at establishing a connection using Dreamweaver.

  19. Mitch
    March 7, 2011 at 2:36 pm

    So I don’t think that my user log in is the problem. I still can not see my tables in dreamweaver. Also, about 75% of the time I get an error when connecting via dreamweaver: mySQL error # 2013. Googling this leeds me to believe there is either a problem with the server at the JC, or that my dreamweaver is consuming too much time in the connection process, and timeout occurs… Any thoughts?

    • March 8, 2011 at 6:20 pm

      Hi Mitch – I am able to connect to your database account and see your table via Dreamweaver. I have tried it a few times.

  20. March 7, 2011 at 7:01 pm

    Mitch, Leeana, Shelby – Please send me your MySQL Admin passwords and I wll have the server administrator look into your accounts.


  21. Kathryn Patterson
    March 8, 2011 at 10:35 am

    I’ve installed MySQL workbench many times and when ever I double click on the Admin account we set up in class, it unexpectedly quits every time.

    Here’s my admin info:
    Username: kpatters_admin
    Password: JmfeFGv5


  22. March 8, 2011 at 12:32 pm

    Success! Don’t know why. Did the administrator do something?

  23. Tom
    March 8, 2011 at 11:20 pm

    Hi Jay – I’m getting a mysql error #2000 while attempting to connect to via Dreamweaver : “your mysql is using old authentication”
    A web search pointed out that I need to update my password using a new format. I’ve reached out to my hosting company to make the change.
    mySQL WorkBench works fine – it’s just the DW connection I’m still working on.

  24. Tom
    March 9, 2011 at 12:46 am

    I found this on Adobe…if our hosting company can’t figure this out I’ll to use the JC’s DB.

    One common error message that you might encounter when testing a PHP database connection to MySQL 4.1 is “Client does not support authentication protocol requested. Consider upgrading MySQL client.”

    You may have to revert to an earlier version of MySQL, or install PHP 5 and copy some dynamic link libraries (DLLs). For detailed instructions, see Setting up a PHP development environment.

  25. Mitch
    March 9, 2011 at 5:11 pm

    Weird. The error i get is mySQL error #2013 and my researching forums on the internet leed me to believe that it is a “timecode” issue. As if the server limits the amount of time any program has to get connected. If so then my dreamweaver is taking too long. I reinstalled dreamweaver and it still doesnt work. I am falling behind on my homework because I cant do anything with the server…..

  26. Tomas
    March 9, 2011 at 5:22 pm

    Mitch – where is your db set up at? I got DW working on another computer system.
    My DW build is 4964

  27. Julie Arden
    March 9, 2011 at 5:44 pm

    Hi Jay,
    I’m writing with my information regarding the school server connection issue.
    My username:

    The problem I have had is an intermittent connection. This occurs in both Dreamweaver and MySQL workbench. The connection can be made but for no apparent reason I will not have a connection at random. I almost always have a problem in the lab connecting. At home I usually can make a connection but on the day of class (Thursdays) I almost always lose my connection.
    I am working on a Mac osx 10.5.8

    I hope this description helped.

    Julie Arden

    Advanced Dreamweaver
    Spring 2011

  28. March 9, 2011 at 11:27 pm

    My username is pwilson and I am using a Mac I get the following error in MySQL workbench:

    Your connection attempt failed for user ‘pwilson_admin’ from your host to server at
    Access denied for user ‘pwilson_admin’@’′ (using password: YES)

    My password is: PW35172

    Will this work if I am away from the JC?

    • March 10, 2011 at 7:21 am

      Peter – You are using your FTP password. You should have other passwords for MySQL that you got when you installed MySQL (sudo sqlme). And yes, you should be able to connect from anywhere on the internet.

  29. Peter Wilson
    March 10, 2011 at 7:47 am

    Jay–that makes much more sense. Since I had previously set up my site through the JC I bypassed that step in the beginning of this class. I will do that and let you know. Sorry for my ignorance.

Comments are closed.