gjdonaldson

OK with the help of the help desk I figured this one out. 1. My shortcut to cPanel on my desktop was using the ip address and not the server name. Therefore I was accessing cPanel on the old server. This complicated troubleshooting. 2. In my php scripts I was attaching to the database not on localhost but on acornfusion.com. Even though acornfusion.com and localhost are the same box they have different IP addresses. Since acornfusion.com was not in my list of allowed hosts the database connection could not be made.

I have put in a help desk ticket on this but it appears that my php application is not able to connect to my MySQL database since the server was upgraded. Not exactly sure it is related but is seems to have started at the same time. Not only is my php application having problems but I can also no longer connect from my local system using MySQL-Front. The database checks out fine and I can access it with myphpadmin. I am not using localhost in the script as I use my domain name so that when I run them locally they find the database. It was all working Friday and failing on Monday. Any thoughts on this would be appreciated. Thanks!

Just thought I would add my two cent to this thread. I was looking for a tool for html, php and mysql. I had been back and forth and looked at several both free and pay for. Based on the discussion above I downloaded html-kit and took a look. Well a website and several perl scripts later I am sold on it. It is the editor I have been looking for since I moved of DEC VAXes and lost TPU. I just need to figure out how to setup a learn sequence. The built in scripting language for developing plugins is fantastic. I was amazed at how fast I was able to develop a plugin to execute the perl script in the editor window and put the output in the Output window. Wow!

I have just finished going down a similar path with a very simple application. I plugged "mysql php" into my favorite search engine and then had to search through everything that came back. Here are some of the resources I found that were very helpful: http://www.zend.com/zend/tut/tutorial-yank.php http://www.thescripts.com/serversidescript...ases/page0.html http://www.linuxworld.com/story/34322_p.htm http://codewalkers.com/tutorials/9/1.html Hope this helps! Greg Donaldson Rockville, MD

Have you tried accessing the database using your local client? If not, you might want to try it. I am not sure what platform you run locally but if it is windows you could try using something like MySQL-Front. I found that if I configured my database to allow access from % and then configured MySQL-Front to: server: **** user: mytchuser_dbuser password: <the pw for the user above> database: mytchuser_dbname I was able to get access locally. Once I got that working I was able to setup remote to remote access. One note if you do get it working you might want to change the security from the wildcard % to the actual host ip address as it would be more secure. Hope this helps! Greg Donaldson Rockville, MD

Good Folks, Recently I had the opportunity to post a question regarding MySQL to the forums. It took me a while to decide where the right place was. When I did a search it seemed that there were MySQL questions in several places. I posted my question in the backend services forum and got a quick answer. Does MySQL have a home in the forums? Thanks! Greg Donaldson Rockville, MD

Thanks for the feedback. I don't see a problem working around it.

Good Folks, I am relatively new to this community. I have been lurking in the background for a week or so. I decided to develop and host a site at TCH as part of a research project where 100 or so responses need to be collected to an online survey. I am using the survey as an opportunity to better develop my web skills. I am developing the suvey using php, javascript and mysql. The survey is not sensative or private data. However, it makes use of a username and password that will be given to participants to reduce the likelyhood of extranious data being entered. For the sake of my question my database is call test_survey. It has two users test_srvyadm and test_srvyusr. The test_srvyusr is the username people who are filling out the survey will be given. The test_srvyadm will be the username for administering the survey and reviewing the results. I am in the final stages of development. I have the survey setup where it collects, validates and enters data in to the database. I am in process of making some final refinements before I go into production. My question is how do I set the rights of test_srvyusr in the database to just be able to insert rows? I have found plenty of documents that explain how to do this if I had root access to the database but as this is a shared environment I don't. Maybe things work the same but I figured I would look for some guidance before I went for the trial and error approach. Thanks! Greg Donaldson