The Linux-Apache-MySQL-PHP (LAMP) server is a popular web programming environment. Many sites use LAMP technology to support online stores, blogs, and content management systems (CMS). A LAMP server environment is often difficult to configure, due to the multitude of packages that need to be synchronized. The Ubuntu server takes all of the hassle out of installing a LAMP server by preconfiguring all of the individual components to operate properly.
If you install the LAMP server, the installation process displays an additional query window, shown in Figure 3-16.
The MySQL server uses user accounts to access databases contained within the server. The main administrative user account is the root user. By default this user account doesn't have a password, which could be a dangerous thing, especially if your Ubuntu server is on an open network.
You can select a password for the root MySQL user account from this window.
While not mandatory, it is highly recommended that you set a password tor the MySQL administrative "root" user.
if that -field is left blank, the password will not be changed.
New password for the MySQL 11 root" user:
<TaU> nuvbb It: I ween ilenis; <Sudut:> seleuls; <Enltrr> aulivatts but Iuris
Figure 3-16: The MySQL root user window.
The default empty root password for MySQL has become security issue for many sites. If the system administrator forgets to assign a password, anyone can get into the MySQL server and perform administrative functions. For that reason Ubuntu goes out of the way to ensure that you assign a password to the MySQL root account.
Of course the flipside to this problem is setting a root password then forgetting it. Chapter 21, "Web Server," explains how to get out of this predicament.
Was this article helpful?