Search KB

	Advanced Search

Featured Articles

	NewPad Home Install SQL Server Ver. Install mySQL Version Install Access Version Secure Access DB Common Errors Search KB

Web Wiz NewsPad mySQL Installation

1. Check with your web host that your web space meets the system requirements for running Web Wiz NewsPad mySQL Version
    
2. Make sure that you have a mySQL Database (mySQL 4.1+, or mySQL 5+, and myODBC Driver 3.51) and that you have the required login details to connect to your mySQL Database.
    
3. Uses a zip utility program to extract the files to your hard drive keeping the original file structure intact.
   
4. Using an FTP program upload the NewsPad directory containing all the files and images onto your web space making sure that the files stay in there original directories.
   
5. Create a blank database on the mySQL instance or use an existing one. If you are using a web host they should supply you with your mySQL Database, connection details, and login information. If you are using your own server use mySQL Admin (pictured below) to create the database on mySQL.
   
6. Edit, with a text editor, the file 'database_connection.asp' found in the 'database' directory entering your mySQL details, where indicated;
   
   
• mySQL Name - This will be the name or location of the mySQL instance (URI, IP address, or localhost)
• mySQL Username - This will be the name of the user account you use to login into the mySQL database
• mySQL Password - This will be the password that you use with the mySQL Username above
• mySQL Database Name - This is the name of the actual database
  

7. Once you have finished editing the 'database_connection.asp' save the file back to the 'database' directory keeping the file name the same.
   
   
8. The next step is to call the web page 'mySQL_server_setup.asp' found in the main folder of NewsPad in your web browser using the URL to this page. This file will create all the tables, relations, and default values in your mySQL Database.
   
   
   
   
9. When you run the 'mySQL_server_setup.asp' tool you will be asked for your mySQL Database Username and Password again. This is done for security and because sometimes you have a different login username for creating and altering tables in your mySQL Database.
   
   
10. After the 'mySQL_server_setup.asp' has successfully completed you should delete this file as it should not be run again and will prevent hackers from misusing the file.
     
11. The NewsPad database should now be created and you can now use Web Wiz NewsPad.
     
12. Once all the files are uploaded type into your web browsers address bar the domain name and folder that you have uploaded Web Wiz NewsPad to.
    
13. Now that Web Wiz NewsPad is uploaded and running see, Logging into the online Admin Control Panel, to find out how to set up NewsPad and administer your Web Wiz NewsPad installation.
     
14. If you find that you are getting errors and pages not displaying please see Troubleshooting and Common Errors.
     
15. To login into Web Wiz NewsPad the default admin username and password is: -
     
    • Username: Administrator
    • Password: letmein