Copy link to clipboard
Copied
I've been attempting to link to my mySQL database through the Dreamweaver interface for the purpose of writing web-based applications. I consistently get an error that indicates that some problem exists but is not specific. A colleague suggested that permission set on the mySQL server might not allow REMOTE accept to the database schema. I called Network Solutions and got a somewhat tenuous reply that perhaps their shared hosting services won't allow me to use Dreamweaver in this fashion.
Does anyone here actually use Network Solutions (in other than a VPS-mode) and is successful in connecting to their mySQL database?
(NOTE: I am able to get the phpMyAdmin application running on the Network Solutions server to connect and display the contents of the database. But the mySQL GUI applications connect and give some information but to date have not allowed me to the see the full extent of the databse information the way phpMyAdmin does.)
Any suggestions for which ISPs do allow a successful connection would be appreciated. I am told too that many folks run a local version of PHP/mySQL on their Macs (which is what I am using) and do their work locally. Has this been the predominate mode of working for most of you?
Copy link to clipboard
Copied
generally most people use a local testing server to do their work. the easiest way to do this on your mac is MAMP. http://www.mamp.info/en/downloads/index.html
Although macs do come ready to support php/mysql, it will make you're life much easier using mamp. simply start it up and apache php mysql are all ready to rock. test your pages in the htdocs folder and connect to mysql using the localhost connection (and make sure you pay attention to the ports... use 3306 if confusion sets in).
as for connecting remotely to a database, yes it can be done... i do it all the time with my hosting (that is not NS), and you're have to do it that way if you're working on a sql server database / asp from your mac. but for now, i'd just work locally.
Copy link to clipboard
Copied
Thanks! Took your advice and it works marvelously.