Menu

Cannot connect to MySQL Database on Creation

Help
astro
2007-02-13
2013-06-03
  • astro

    astro - 2007-02-13

    I have installed the phpFormGenerator from my webhosting's fantastico list and am creating a form and up to the last step of entering the MySQL database table info yet every way i do it (trying all possibilities ive looked at from my webhosting) has come back unable to connect, some with a msg such as

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user '<username>'@'<domainhosting>' (using password: YES) in /home/<username>/public_html/form/process3.php on line 288

    Could not establish connection to MySQL database with the information provided.

    others just saying

    Could not establish connection to MySQL database with the information provided.

    im not sure what is going wrong and if anyone has any idea then please let me know.

     
    • TNTEverett

      TNTEverett - 2007-02-13

      The fact that your error message says "process3.php" indicates that there is something wrong with your installation or with the way you are using your form.  This file is part of the generator and should not be used for finished form operation. 
      The generator creates forms using this file as a template.  Your form should have its own folder and in that folder you should find the form1.html file and a process.php file, not a process3.php file. 

       
      • astro

        astro - 2007-02-13

        would you be able to then, put a list of steps i should take to create a new form. do i need to create the folder in /use for the new form or is there something else i should be doing

         
        • TNTEverett

          TNTEverett - 2007-02-14

          Whe you create a form, the end of successful generation has a link to your form.  Did you try this link?

           
          • astro

            astro - 2007-02-14

            well thats where the problem is, this error in connecting to the database is on the last step of the form generation and so there is no link to the form

             
            • TNTEverett

              TNTEverett - 2007-02-14

              Using your initial form entry data, go to the phpmyadmin just before completing the form and create a db with the name and fields from your form data.  When finished go ahead and complete the last form generation step. 
              Also make sure the db has a valid username and password.  Problems are usually related to usernames and passwords but I have used the method of manually creating the db to get around some these issues in the past. 
              The problem with helping everyone with any problems like this is that I must have complete access to all web site resources to properly diagnose the issues.  So be patient.  It's better for both of us if you don't have to provide this type of access to someone you don't know.  Please take some time to discuss your issues with your host.  Sometimes they can be very helpful figuring out what you may be doing wrong.

               
              • astro

                astro - 2007-02-14

                thanks for the help guys, i know this isnt in the same question but once i have created the form is there a way i can edit the field types (such as change text box to check boxes)

                 
                • TNTEverett

                  TNTEverett - 2007-02-15

                  There is so much information available on any subject on the web.  All you need to do is spend a little time searching and I am positive you can find the answer to any question you have. 
                  Forms:
                  Try this link
                  http://www.w3.org/MarkUp/html3/forms.html

                  This shows up in a search for "html form properties".

                  Check this one out for all types of web development tutorials.
                  http://www.w3schools.com/

                   
    • flordegudua.com

      flordegudua.com - 2007-03-07

      Hi  i get the same error...   and its funny , becouse my form works for 1 2 3 4 5 6 7 8 fields , but if i try 19 fields ...  i get the error /home/<username>/public_html/form/process3.php on line 288

      mmm
      by de the way , could you plase some one tell me how can i don´t load the  db to create a new table with the correct fields....

      thanks a lot   ant you are welcome to visite  my site... www.flordeguadua.com

      Tito

       
      • TNTEverett

        TNTEverett - 2007-03-08

        I'm not sure what you are trying to do but I know I have seen and created forms with more than 19 fields.  The error comes from process3.php which is during the creation of your form.  Can you send me the steps you take to create this form?  I can try to dupliccate your error and tell you how to get around it. 

         

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.