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.“
Dear IT Guru’s
Please check my sequel account for errors. My password to the mysql server is as follows:
dmcquoid_admin
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’@’10.28.1.234′(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.
Best,
Des McQuoid
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 http://student.santarosa.edu/~lmcbee/_mmServerScripts/MMHTTPDB.php 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.
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
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
Is there a way to do the exercises in lesson six without the SRJC SQL connection?
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
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?
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.
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.
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?
Thanks!
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
Mark – Have you uploaded the Connections folder to the server in the site root folder?
Yes,
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
http://forums.adobe.com/message/2696260
Good catch, right from Mr Powers himself. I wonder what you did to get the extra back ticks.
I don’t think the problem is the testing server set up.
Here’s what I have:
server name: student.santarosa.edu
Connect using: FTP
FTP address: student.santarosa.edu
Username: lmcbee
Password: (yep….I’m using the right one)
Root Directory: public_html/
Web URL: http://student.santarosa.edu/~lmcbee/
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
Linda – I will let the server administrator know you’re getting this error.
one thing that hung me up for a while
When setting up the database connection in MySQL Workbench,
I used the Hostname: student.santarosa.edu
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.
Localhost is used because the connection is from the webserver/PHP processor to the database, both are running on student.santarosa.edu
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 sonic.net. 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
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.
Yes, I was successful at establishing a connection using Dreamweaver.
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?
Thanks!
Hi Mitch – I am able to connect to your database account and see your table via Dreamweaver. I have tried it a few times.
Mitch, Leeana, Shelby – Please send me your MySQL Admin passwords and I wll have the server administrator look into your accounts.
thanks
Jay
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
Thanks
kate
Success! Don’t know why. Did the administrator do something?
Hi Jay – I’m getting a mysql error #2000 while attempting to connect to bluehost.com 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.
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.
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…..
Mitch – where is your db set up at? I got DW working on another computer system.
My DW build is 4964
Hi Jay,
I’m writing with my information regarding the school server connection issue.
My username:
jarden
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.
Thanks,
Julie Arden
Advanced Dreamweaver
Spring 2011
My username is pwilson and I am using a Mac I get the following error in MySQL workbench:
CANNOT CONNECT TO DATABASE SERVER
Your connection attempt failed for user ‘pwilson_admin’ from your host to server at student.santarosa.edu:3306:
Access denied for user ‘pwilson_admin’@’76.221.176.225′ (using password: YES)
My password is: PW35172
Will this work if I am away from the JC?
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.
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.