Ricardo D Argence asked:


cPanel is short for Control Panel and is a graphical user interface or GUI that is web-based and designed to afford webmasters and web designers easy access to many aspects of the web hosting system.

It used to be hard, if not impossible, for most people to figure out what to do with their hosting once they paid for it.

cPanel is an interface that allows web hosting companies to offer a graphical interface to people seeking to set up and run websites on a number of RPM-based Linux platforms.

cPanel is usually interfaced with the end user via ports 2082 and 2083 with authentication accomplished through surfing to a specific web page and logging in. Because cPanel is graphically based, it is extremely easy to use and very intuitive for novice as well as veteran users to work with.

If you want to set up a blog, mailing list, php link directory or basic content management system, cPanel is the way to go.

By clicking on the happy face icon used by Fantastico, a user is taken a list of software that is grouped into various topics and offered as an easy setup and tracking system for just about anything the end-user might want to add to the Internet community.

As a result, a webmaster can concentrate on the content and quality of what’s offered from the website and not the technical aspects of getting the site up and running.

With cPanel, managing your MySQL databases are a breeze to manage, releasing hosting companies from endless help requests from confused people. cPanel manages setup and maintenance of email accounts using three different web interfaces for retrieval via the web of email coming into the account.

Raising and lowering email quotas, adding and manipulating databases, managing PGP keys, setting up crontab tasks, email and FTP tasks and more.

Via Fantastico, several add-on scripts automate the installation and upgrade of many of the popular applications like SMF, WordPress, Joomla, TikiWiki and phpBB to name a few. There are over 50 other scripts to choose from and it is constantly updated.

There are some pros and cons to using cPanel with webhosting. One of the biggest cons is in the ever increasing reality that cPanel is a hackers dream.

With identity theft being a prevalent and expanding phenomenon, the ease of making sub-domains portion and ease of using cPanel has been and continues to be exploited.

Vigilance is necessary to avoid having the account suspended due to phishing. A hacker will set up a sub-domain called aol.YOURDOMAIN.com or bankofamerica.YOURDOMAIN.com and point unsuspecting victims to the sub-domain on your site via bulk email.

After a few days, your site will disappear and you will receive an email where the web hosting company will shut you down due to phishing. If you receive this email, go back into cPanel and click on the sub-domains button.

It will give you the sub-domain in question, and you can attempt to get rid of it. Get rid of the contents via FTP and delete (or attempt to delete) it via cPanel. If you can’t get rid of it, contact your web hosting company. They will be happy to help you. Be sure and change your password because it’s passed around like candy in a schoolyard.

What makes cPanel so easy is what makes it so easy to exploit. Until lately, most of these scripts ran through a cPanel that was set to either X or X2 layout. Nowadays, the scripts can run under any layout.

That’s the only con to this great piece of software. It takes consistent monitoring; however, it is not something that happens that often. Hacking cPanel is just something that most webmasters need to understand. If you want to avoid it altogether, simply set up your site with 0 sub-domains or the exact amount of sub-domains you need for your needs.

If you have 100 sub-domains with your package, ask the administrator to reduce it to 5 until you need more. In that way, you can benefit from the fantastic feature-rich cPanel interface and won’t need to deal with the crap that comes along with it.

There is so much positive advancements in using this interface, that the sub-domain problem shouldn’t be a deterrent to using it. It is definitely the best system on the market.

googletechtalks asked:

Google TechTalks
April 28, 2006

Stewart Smith
Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is an active member of the free and open source software community, especially in Australia.

ABSTRACT
Part 1 - Introduction to MySQL Cluster The NDB storage engine (MySQL Cluster) is a high-availability storage engine for MySQL. It provides synchronous replication between storage nodes and many mysql servers having a consistent view of the database. In 4.1 and 5.0 it’s a main memory database, but in 5.1 non-indexed attributes can be stored on disk. NDB also provides a lot of determinism in system resource usage. I’ll talk a bit about that.

Part 2 - New features…

F^3 asked:


Please tell me that this is possible…

Jeremy Gislason asked:


What is MySQL?

First released in May 23, 1995, MySQL is an open source database software. It is part of a large and growing family of open source software including Linux, Apache, and programming languages PHP and Perl. However, unlike many open source products where the copyright is owned by the individual authors or distributors, MySQL is owned and sponsored by a single for-profit firm, MySQL AB, which holds the copyright to most of the codebase. They develop and maintain the system, sell support, service contracts, and proprietary-licensed copies of MySQL.

MySQL is a relationship database, which is a collection of items or tables organized into predefined categories or described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. This format is enormously popular with more than 100 million copies of the software downloaded over the life of MySQL. The popularity stems from the fact that the databases are easy to create and access. Additionally, they are easy to extend, a new data category can be added without requiring that all existing applications be modified.

When creating a relational database, you can not only extend the data, you can define the domain of possible values in a data column and any additional constraints that you want to apply to the value of your data. This makes your information significantly more valuable and user friendly.

Uses of MySQL

There are many uses of MySQL for a business and you can find many significant case studies at http://www.MySQL.com/why-MySQL/case-studies/. Among them are many stories about how information generated from MySQL has saved IT teams thousands of man hours and thousands of dollars.

Here’s an example of how you can use it for your business. Consider a typical order entry database. It might include the following columns for customer information: name, address, and phone number. . Another table might describe an order and have these columns: product, customer, date, and sales price. This table and the relevant information could be used to show a report on all customers that bought products on a specific date. A financial services manager in the same company could, from the same tables, obtain a report on accounts that needed to be paid.

Craigslist uses MySQL to power more than 50 forums, among many other things, and Yahoo Finance uses it to aggregate headlines for its website.

Benefits of MySQL

Ease of use. A basic knowledge of SQL and database manipulation is required however MySQL is logical and easy to use. This means you don’t have to spend as much time and money either training existing staff, or hiring developers.

Security. There are not a lot of databases that can compare to the security that MySQL offers. It includes solid data security layers that protect your sensitive information. Rights can be set to allow some or all privileges to either individuals or groups. Passwords are encrypted. The access to your database can be controlled by a remote machine that can completely control what a user can view. The system can be locked down even more through the operating system.

Capacity and memory. MySQL can handle almost any amount of data from only a few rows to as much as 50 million rows or more. The default file size limit is about 4 GB. It manages memory very well, which means it functions efficiently and speedily without crashing or dumping your information. Additionally, MySQL server has been thoroughly tested to prevent memory leaks.

Unbeatable flexibility. MySQL runs on many operating systems, including Novell NetWare, Windows, Linux, and UNIX

It supports several development interfaces including JDBC, ODBC, and scripting languages including PHP and Perl. This enables you to create database solutions that run on all major operating systems, including Linux, UNIX, and Windows.

More than one person can access business information at a time. This means that a large group of people can access the information at once but there can also be several connections at one time.

Multiple storage engines, or types of table, allow you to choose which one is most effective.

Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

Technical support. One of the drawbacks to many open source products is the fact that the support is sometimes nonexistent or slow to respond at best. The products are free or close to free so it’s a trade off. However, MySQL Enterprise offers support itself, including 24/7 30-minute response time and the support team has direct access to the software developers.

Licensing. We’ve already discussed the fact that open source products are extremely cost efficient! MySQL AB makes MySQL Server available as free software, but they also offer the MySQL Enterprise subscription offering for business users and dual-license it under traditional proprietary licensing arrangements for cases where the intended use is incompatible with the General Public License agreement.

Drawbacks of MySQL

Early versions of MySQL lacked many standard relational database management system (RDBMS) features, usually with the goal of trading guaranteed accuracy for speed. Many (but not yet all) such criticisms have been remedied in later versions of the software, including transactions and relational integrity constraints.

Some say that MySQL’s feature list leaves something to be desired, but its fans swear that a scaled-down feature set means you only have to deploy, configure and maintain what you need

There are also a few common errors such as out of memory or packet too large they generally relate to the configuration of the server and are uncommon and the errors are fairly easy to remedy.

Bottom Line:

The uses of MySQL are seemingly endless and for a business the information gathered is priceless. Combined with PHP, it can be used to create dynamic web pages. If you’re using any type of web 2.0 technology like forums, online ordering, subscription forms etc…must utilize a database of some sort to gather and analyze the information. When it comes to database technology, there really isn’t anything that beats MySQL for stability, price, and ease of use.

MemberSpeed Content Management software can run on MySQL 3.23 and above.

joe c asked:


Why can’t I log-on to my cPanel via webhosts and how do I solve this? That’s the questions. I cannot acces my Files, MySQL, Mail, PHP, etc on my own computer but in a different computer I can. Im using a laptop with Windows XP. I know laptop and Windows XP or my webhost is not the case cause I can still acces my cPanel from a diffrent computer with WIndows. I checked my firewall and its it seems pretty normal. It’s on standard mode. I tried logging in a different browsers but I still can’y log-on.
Please help me with this matter. I appreciate any help or response. A Helpful response will recieve 10 points.
I can connect to internet. Internet is not the problem. My router is working perfectly.
to: j-r-c
I just did! moron!
I don’t recieve any errors. As I said, I can access my cPanel from another computer bu not on my own computer. When I log-on i typed in the right username and password but i hit enter I dont see my cPanel. Instead the browser is loading for minutes and seems like nothing happened.

Dave asked:


I’ve got a form setup which accepts text via a textfield, here the user can type whatever and insert spacing and new paragraphs. The text and whatever formatting is present is saved correctly to the MySQL database, but when displaying it via PHP it displays everything on a single line.

Is there a way around this to display it as it was originally entered?

Markus Fernandez asked:


The recent boom in field of Information Technology has seen a steep rise in the demand of trained professionals in PHP and MySQL. Software companies specializing in php mysql web development are always searching for skilled professionals for recruitment in several important projects. The current supply of PHP experts is much below par, in terms of potential growth in the industry.

To train the educated work force in this regard various MySQL and PHP training courses have been developed. These courses provide elaborate training to the professionals for developing website with the usage of these languages.

PHP Training Objectives

Two main objectives of php and mysql web development program are:

• To develop skills to create interactive and data-driven sites

• Skill development for database creation in MySQL programming

Prerequisites For Training

The most important criteria for acquiring PHP training is thorough knowledge of HTML. The course should focus on any level in programming for teaching database creation.

On the other hand there are courses for fresher in the field of php and mysql web development. Some institutes like Indus Net Academy, has launched ACE Web Developer course with the aim of teaching real applications in PHP and MySQL. These courses are beneficial for creating awareness among candidates about programming language.

Course Details

Once you get enrolled into these training courses you can acquire knowledge in areas like PHP Programming Fundamentals, Strings Functions, Arrays Functions, HTML/CSS and Forms, File Handling and Email Handling in PHP, Object Oriented PHP and Session Handling etc. On the other hand, the ACE Web Developer course emphasizes on other programming languages such as MySQL Basics, Extended PHP, OOPS in PHP 5, Exception handling in PHP 5, XML / SOAP etc.

Another vital aspect of these php mysql development courses are; 70% hands-on and 30% lecture ratio, as far as the training part of the course are concerned. By engaging the students in live projects the courses ensure that the students have a thorough understanding of the actual application of such programming languages.

So if you have some knowledge about HTML, then you can get online training as well as work as a freelancer for php mysql web development. Some of the requirements essential for learning this programming language are:

• A personal computer at home

• Linux, Windows, MacOS X, or Solaris operating system

• Web server (either Apache httpd or Microsoft IIS)

• PHP 5 or later with the PEAR extensions enabled

• MySQL 4.1 or later (5 or later recommended)

• Internet Explorer 6 or Firefox 2

PHP programmers can now get quality work through the Internet from the freelancing websites. It is an open source language and is free to install and use. This is the main reason for the increase in the popularity of this language.

wildman asked:


This program introduced itself in my browser and interferes with what I want to do. How come Yahoo allowed this through their defenses that are suposesed to be so good, and how are they going to correct the problem?

Adam Scott asked:


These days, web hosting is easily reachable to even those type of people who may have low level technical skills and training. All this is possible due to the existence of the user-oriented control panel. One of such popular control panel is the cPanel ( control panel). The full form of cPanel is Control Panel. It is a way to allow the website owners to maintain and keep their websites updated. This website based cPanel was developed by Darkorbc communications Inc. and it was basically made for the consumer to conveniently control every aspect of their activity on the concerned website. cPanel type of control panel is very suitable for the beginners. Through cPanel, emails can be conveniently operated. You can use cPanel with many browsers, like IE, Opera, Firefox and others. cPanel provides various facilities such as :

1) It provides a backup facility:

Through backup facility, you get the opportunity of creating a reserve copy of an account file and also databases. You can also restore some part of the user’s account.

2) Organizes emails:

You can create, add and also change password during managing of email accounts. cPanel is also used for Auto responders, forwards, mailing list and spam filtering.

3) Stats:

The websites efficiency and website popularity can be measured with different tools such as webalizer, web stats, analog stats, view latest visitors, view bandwidth usage and also by using the view bandwidth usage facility.

4) Sub domains provision:

You can use cPanel to create and manage sub domain’s. Also, statistics of its use can be viewed. In other words, you can add or remove sub domains and perform sub domains redirects too.

5) FTP:

FTP accounts can be managed with the help of cPanel. In other words, accounts can be created in order to access to certain directories or domains. You can add, remove, change passwords for accessing. You also will have the ability to kill FTP sessions.

6) Site tools facility :

There are tools available for protecting the website. The front page password can be changed, do redirects, MIME types can be edited and also apache handlers can be edited. There is also a provision for search engine tool submitting and File Manager option. Pre-Installed CGI scripts are also available for usuage.

cPanel is a user friendly interface. Anyone with any level of Internet and computer usuage ability can successfully use cPanel. It was designed with the aim of encouraging more average website owners and also to accommodate most ages and educational groups of computer users. cPanel has also included a facility called “Fantastico” which allows website owners to easily install programs such as Wordpress, Moodle, phpBB, mambo and Joomla with one click. It would take a lot of time of the website owner would try to install these programs alone.

cPanel offers great assistance in terms of saving time of people who are not experts in creating databases. The cPanel provides databases and database management from the main screen. People of all levels can use cPanel program. cPanel gives the website owner a feel of respect for the website as a whole. It is very easy to accomplish tasks of maintaining website. Hence, whenever you choose a web hosting provider, see that the company that is chosen is having cPanel as part of its package.

Smoothie asked:


I have all three installed and they run separate of eachother. Apache and php are working great, I just can’t get MySql to come to the party.