260 Part II . PHP and MySQL (Web host sites) less
260 Part II . PHP and MySQL less restrictive licensing scheme than before, but it happened to be incompatible with PHP s Apache-style license, and therefore the PHP Group no longer felt able to distribute the database libraries. At press time this issue was in the process of being amicably worked out to allow Open Source combined works to be distributed without charge but you should still check to be absolutely positive that this is the case. The definitive location for MySQL licensing information is www.mysql.com/doc/en/Licensing_and_Support.html. There are separate sections for commercial use and for use under the GPL which is probably the use most relevant to most PHP developers. You should read the license carefully, but here are some common use cases that will be affected by MySQL s new licensing scheme: . Web site only: If you use MySQL solely as part of a commercial or noncommercial Web site, you may use it without worrying about licensing issues. MySQL AB suggests you purchase a support contract to further development work. . Open Source project under GPL: If you distribute MySQL server or client libraries as part of an Open Source project properly released under the GNU General Public License, you can (and must) redistribute MySQL and its source code freely. . Commercial redistribution: If you bundle MySQL server or client libraries as part of a commercial product, you must purchase a commercial license from MySQL AB. . Open Source project under non-GPL license: This is the potentially problematic situation at the moment, because if you bundle MySQL server or client libraries with your non-GPLed Open Source project, your code could be infected by the GPL. Check the MySQL licensing page to determine the most current status of MySQL in relation to your project. Remember that in many cases you can evade these licensing strictures simply by not redistributing the database yourself but rather requiring your users to procure and install MySQL separately. Installing MySQL: Moving to Version 4 Remember to install the MySQL server and client libraries before installing PHP! Although it s not strictly necessary in every circumstance, especially on Windows, it s always a good habit with PHP to make sure that all third-party servers and libraries are properly installed before telling PHP to link to them. Preinstall considerations MySQL was in version 3 for a long time, and many PHP developers got used to working with it during this period. However, MySQL 4 has introduced some innovations and changes, both on the database side and the PHP side. Both new and experienced webdevs should take the time to familiarize themselves with these changes. Even if you have a lot of experience with MySQL 3, you shouldn t necessarily expect to be able to install and use MySQL 4 with exactly the same procedures. There are three main MySQL-specific issues to consider before you install new versions of MySQL and PHP: incompatible new client libraries, the new PHP mysqli extension, and new table types that support transactionality.
Searching for affordable and reliable webhost to host and run your web applications? Go to our java web server services and you will be pleased.