SwarfEye

Quite right.

That would have been very useful… funny that it didn’t come up in all my searching on the subject.

I was using this as my main document…

https://help.ubuntu.com/community/WordPress

I will suggest that they link to the “Installation” page on this document.

Thanks.

B

Ok, I figured it out, but I have to say that the documentation for the newby is quite patchy.

So, just in case someone in a similar spot comes across this post, I will list all the things that need to happen and how to do it (it’s the how to do it that appears to be missing from everything else!)

First up, it was my wp-config.php file that was screwy. For some reason the default install leaves a file called wp-config.php which is entirely not like anything that is supposed to go there. I replaced it with wp-config-sample.php.

Then you need to fill in the new wp-config.php file. For me, all I had to set were the database name, user name, and user password… but then there is the question of how do you find this information???

1) Log into mysql by using the command…

mysql -u root -p

Give mysql the root password you gave it during installation. You should end up at the mysql command prompt.

2) Find out what the name of the database is. At the mysql command prompt use the command…

show databases;

In this case, I found out that the database was named “wordpress”

3) Find out what the mysql username is. Use the command…

select User from mysql.user;

… this should yield a list of users, but on a new install it will be quite short. For me it was obvious that the username I was looking for was “wordpress”.

4) Set the wordpress user password. I was unable to determine what the default installation wordpress user password was, so this is how I figured out what to in wp-config.php file.

SET PASSWORD FOR 'user'@'host' = PASSWORD('newpassword');

Plug these new values into the new wp-config.php file. Then restart apache. On the Ubuntu command line that is…

sudo /etc/init.d/apache2 restart

… Then everything worked again!

B

Ok,

So, I’m not sure how to check and see that mysql is in fact running. Nor am I sure what the correct username and password for the database would be.

I’ve reviewed the installation instructions, and I don’t see any indication that I was ever asked to enter this information… and so I don’t know it at this point.

I was asked to provide a root password for the mysql installation. This password I have, but I have not been able to figure out how to do anything with mysql. I am not able to log in or anything.

Suggestions?

B