No page number in first page
I am assuming that you already know how to set page numbers to your document.
Removing page number on the first page and starting page number from the second page is even easier than the accepted answer.
Click on Format menu and select Title page.
You will now be presented with a 'Title pages' dialog box. Under 'Page numbering' heading, select the option 'Reset Page Numbering after title pages'. You may choose the number of title pages that you don't want to have the page number.
First, make a copy of your document for safety purposes!
Please set so called 'Title pages':
Menu format -> Insert title pages *convert existing pages to title pages
And while setting page numbers in footnote:
Menu insert -> Field -> Others -> Document -> Page -> Page numbers -> Offset.
Set it to requested value: 1
The previous answers are definitely the easiest way to fix your problem. The options involving Title pages are relatively new.
The "old" way is more generic and will solve many other problems as well.
One of the greatest strengths of LibreOffice writer is its concept of styles. Styles are sets of formatting options that can be applied to individual or multiple characters, paragraphs, lists, frames, or pages. When you assign a style to one of these "objects", it applies the formatting from the style, but also remembers that the object is formatted in that style.
Subsequently, if you change the definition of the style, every object that has that style may be updated - either manually or automatically, if auto update is selected for that style. It's a great way to uniformly change everything that should look the same in your document at one time - like changing all subtitles to have a different font or point size.
In this case, you could define and apply a page style for the title page that has no page number. You can also change anything else about this page without affecting the other pages.
You can open the styles dialog by pressing F11.
Styles are useful for all sorts of other things like making left pages different from right pages and making all your body text a particular font and size without changing special text like headings.
If you haven't used styles before, it takes some getting used to, but it's well worth the effort. There's a lot more to it as well. Styles are very powerful.
Bruce Byfield writes clearly on the subject and on several other writer subjects.
http://www.linuxjournal.com/article/7203
http://www.linuxjournal.com/article/7488
Solveig Haugland is also very clear on many writer topics.
http://openoffice.blogs.com/