Results 1 to 5 of 5
September 3rd, 2008, 11:49 PM #1Confessions of a WordPress Newbie - Hosting Your Own
Since WordPress gets so much GoodPress around here I decided it's my best choice for a new blog site I'm developing. Instructions for the installation are heavily geared toward users who buy hosting services. My installation is on one of our servers so is being installed locally. I ran into a couple issues that I had to do a little digging to work through...
First, during the "5 minute" install that turned into three hours, once I figured out how to create a MySQL database using the command line utility, the install routine would connect to the database server but couldn't "select the database". More searching... I finally found precise syntax in the WP forum which indicated that I had not set permissions correctly. It would have been nice if this was in the instructions. So I'm posting it here...mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
-> IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
Second issue in next post...
September 4th, 2008, 12:04 AM #2
My first attempt at installing WP was directly at the server console. Finally got it installed to the point of logging in to WP and was presented with a page not found error. And going to the home page resulted in a funky white screen with all black text and some links scattered around. Then I realized that when I tried to access the site using it's domain name, the page address changed to the private internal network IP. After nothing I did would change the malady, I decided that the installation takes on the address of the connection it's installed on. So I killed the database and began a re-install. But this time I remoted out to one of my client's networks and ran the install across the Internet from there. The whole process went flawlessly.
And, it took only five minutes!
September 4th, 2008, 12:29 AM #3
Just one of the many reasons I could never handle running my own server without something like cpanel.
Do you have cpanel or something similar? If you know how to do all that via command line, no problem I guess. I'd have to relearn everything I'm doing if I had to create a db and assign permissions via command line! LOL!Generate more fake news.
September 4th, 2008, 01:17 AM #4
I never felt the need to use cpanel type apps as I've always provided hands on personal service for clients.
As far as knowing how, I just do what I have to do. Different database language inceptions are basically similar, just different syntax. I've never worked with MySQL until a week ago, and I think at this stage of life I'm not that willing to put the effort into it (read lazy) that I have MS SQL server and Access. I'm not one of those Unix types that thrive on command line gymnastics.
September 4th, 2008, 12:59 PM #5Originally Posted by BoomersGenerate more fake news.
By walshkian89 in forum Domains & HostingReplies: 11Last Post: April 24th, 2012, 04:50 PM
By dunnington74 in forum Midnight Cafe'Replies: 11Last Post: July 28th, 2009, 05:10 PM
By dunnington74 in forum Midnight Cafe'Replies: 1Last Post: July 12th, 2009, 01:23 AM
By filmont in forum Blogging, Mobile and Social MediaReplies: 30Last Post: January 7th, 2009, 09:47 AM
By Haltingpoint in forum eBay Partner NetworkReplies: 6Last Post: October 16th, 2008, 04:19 PM