Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Saturday, August 29, 2015

How to Increase the Maximum Allowed Packet in cPanel


Log in to your cPanel by using the link which your Web host gave you when you purchased your hosting account. You can find that link in the confirmation email the company sent you upon registration.
Click on the 'MySQL databases' icon.
Click on the 'Settings' icon.
Select the 'Advanced' tab and scroll down the list until you find the 'max_allowed_packet' variable. Click in the field next to it, and input the new maximum allowed packet size you want to use.
Click on 'Save' to save your new settings.
VPS Hosting

How to Create a Forum Website


Register a domain name for your website at a domain name registrar such as FreeHostia or GoDaddy (see Resources).
Buy a web hosting package to host your website online. Hosting is available from the domain name registrars listed above and many different sites. Buy a package that includes at least one MySQL database.
Download and extract the newest version of the phpBB Installation Package from its official website (see Resources).
Upload every file and folder you just downloaded into the same public location on your website (such as yoursite.com/forum).
Open a web browser and navigate to the 'install' folder of wherever you put phpBB. If you put it in yoursite.com/forum, go to yoursite.com/forum/install.
Click on the 'Install' tab and follow the on-screen instructions to install phpBB. If you get stuck, you can find detailed installation instructions in INSTALL.html and README.html, in the 'docs' folder.
Find extra add-ons for your forum and different visual styles from the phpBB website (see Resources).
Tell people to come to your site and start talking.
VPS Hosting

Tuesday, August 25, 2015

How to Create a Forum With HTML


Buy a domain name. You can think of the domain name as being the address for your internet web site. Whenever a surfer types your domain into the address bar on their web browser, they will be taken to your web site. Therefore, buying a domain name is the first step in the process of creating your forum. If you already have a web site and domain name, then you can skip this step.
Obtain web hosting. Now that you have a domain name, you will need to have a web hosting service to host the files associated with your forum. A web host is essentially a company that owns servers and other computer hardware, and allows you to lease space on their servers for a small monthly fee. The cost will depend on how much disk space and bandwidth your forum will require. Most new forums require few system resources, so you can always start out with the most basic hosting plan, and then upgrade your account as your forum gains popularity.
Create a MySQL database for your forum. After you have an account with a web host, they will provide you with access to a Control Panel on their server, which you will use to manage your account. From the Control Panel, there should be a link or button that you can click to create a new MySQL database. This is a very simple process that basically just requires you to fill out a short form and to let the server create the database for you. Once it has been created, you will be given the database name, user name and user password.
Choose a forum script to use on your web site. There are a large number of forum scripts to choose from. The three most popular are Vbulletin, phpBB and Simple Machines Forum (SMF). Vbulletin carries an annual fee for use of the software, but that money is used to hire professional developers to constantly work on improving the forum script. Both phpBB and SMF are free forum scripts that have received a large amount of international recognition for providing high quality message board software without charging anything for the product.
Install the script for your forum. After selecting a forum script in the previous step, download the files for the script and upload them to your web hosting account. The easiest way is to use an FTP program, such as SmartFTP. Once the files have been uploaded to the server, simply visit your site by typing the domain name into your browser’s address bar. The installation script should begin to run automatically. You will be prompted for the database name, user name and user password that you were given when you created the database during Step 3. Remember to delete the installation directory from your server after you have installed the forum. This will be a folder titled either “install” or “installation”. Simply right click on the folder from your FTP software, then select delete, and click “ok” when asked if you are sure.
Configure your forum. After your forum has been installed, log in to the forum using the administrator user name and password that was created during the installation process. This will take you into the administrative control panel, which is not seen by normal forum visitors. This is where you will create forum categories, define how many messages per page, set user permission and make other configurations that will govern how your forum runs. Once your forum has been configured, it is ready to be used by the general public.
VPS Hosting

Sunday, August 23, 2015

How to Log Into My Godaddy PHPMyAdmin (6 Steps)


Log into your regular GoDaddy account on the GoDaddy website (see Resources.)
Click on 'Products' in the menu that appears, and then click 'Hosting.'
Click on 'Launch' next to the account whose database you want to manage.
Click 'MySQL' in the databases list from the 'Hosting Control Center' that appears.
Scroll to the database whose contents you want to access via phpMyAdmin. Click 'Manage via phpMyAdmin,' which is located next to the database name.
Enter the username and password you chose when creating the database via the prompt, and then click 'Go.'
VPS Hosting

Friday, August 21, 2015

How to Install Wordpress On 1and1 Servers


Log in to your 1and1 control panel and click the hosting package on which you want to install WordPress.
Click “MySQL” under the Database heading on the hosting panel and then select “MySQL Database.”
Enter a description for your new database in the field provided. Something as simple as “WordPress Database” is fine, provided you only plan to have one iteration of WordPress installed on your 1and1 account.
Create a password for the database in the “Password” field and then verify it in the “Repeat Password” field. Make a note of this password as you will need it when installing WordPress.
Click “Set Up” to finish creating your database. When creation is complete, 1and1 displays the details of your database, including the database name and username. Make a note of both of these values as you will need them when installing WordPress.
VPS Hosting