Comments on How To Set Up A Feng Office Suite Web Server On Ubuntu Server 10.10

The find command seems excessively complicated. The command

sudo unzip *.zip

Would  do what you want, assuming there aren't a bunch of ZIP files in /var/www.

I would also be inclined to laziness and

sudo chown -R www-data:www-data /var/www

instead of giving a separate command for each sub-directory. This also has the advantage of chown-ing the files as well as the directories.

Finally, by piping the MySQL commands, don't you have to enter the MySQL root password each time? Wouldn't it be better to get the mysql prompt once (with mysql -u root -p), then enter the commands all together?

Thanks for that. Ive made a couple of changes.

I must have worded my comment poorly.

It does indeed seem less secure to include the MySQL password after the -p option. What I was thinking of was to get to the MySQL prompt, then enter the commands.

That would be

 mysql -u root -p

 Which will prompt for the MySQL root password. Once you're in the MySQL prompt ( mysql> ), you can enter the SQL commands one after the other

create database fengdb;
create user 'fenguser'@'localhost' identified by 'fengsqlpassword';
grant all on fengdb.* to 'fenguser'@'localhost';
quit;

without needing pipes and without needing to enter the password multiple times or include it in insecure scripts.