Results 1 to 4 of 4

Thread: Wordpress installation on LAMP

  1. #1
    Join Date
    Nov 2013
    Beans
    2

    Wordpress installation on LAMP

    I'm running Lubuntu 13.10 on a Samsung NC10 plus netbook. For the record it's been rock solid so far.

    I've managed to setup LAMP. Have phpmyadmin working.

    Attempting to install Wordpress so I can run as a test version before implementing changes to my live site. I already stuffed something yesterday testing out child theme. I still don't quite get it but I'll get there. This meant the site was down all day and I don't want that to happen again in future.

    Following these instructions https://help.ubuntu.com/13.04/server...wordpress.html I seem to have it all going well until the last bit of code:
    Code:
    cat wordpress.sql | sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf
    Firstly it said there was "no such file or directory"

    So I then after following a few variations via http://ubuntuforums.org/archive/index.php/t-824277.html specifically
    Code:
    mysqldump -u username -p wordpress > wordpress.sql
    I managed to get there to be no error. But I'm not sure if that was the only piece of code I should have used?

    So when I now try to get into localhost/blog/wp-admin/install.php I get "Error establishing a database connection"


    This is all after a previous setup of LAMP confused the out of me so I just removed and purged all the files and started again. Getting so close to working it out mwahaha. Would really appreciate any help anyone can offer me.

    EDIT: Just as cautionary I also just ran
    Code:
    mysql -u username -p wordpress < wordpress.sql
    and restarted apache2 and meh, same error
    Last edited by sw1ayfe; December 1st, 2013 at 01:09 AM.

  2. #2
    Join Date
    Nov 2013
    Location
    Sheboygan, WI USA
    Beans
    88
    Distro
    Kubuntu

    Re: Wordpress installation on LAMP

    I always create a user in phpmyadmin and assign them a database with the same username with all permissions except grant - then I set the password by hand. The wp-config.php has the settings needed to connect to the database if the wordpress "install wizard" doesn't ask you for any database info. If you dont have a wp-settings.php file, cp wp-config.new.php wp-config.php and there you go.
    Code:
    define('DB_NAME', 'your db name');    // The name of the database
    define('DB_USER', 'your db username');     // Your MySQL username
    define('DB_PASSWORD', 'your db username password'); // ...and password
    define('DB_HOST', 'localhost');    // 99% chance you won't need to change this value
    Last edited by rackit; November 30th, 2013 at 03:34 PM.

  3. #3
    Join Date
    Nov 2013
    Beans
    2

    Thumbs up Re: Wordpress installation on LAMP

    Awesome matey thank you. I did not know it actually did that too. Was really doing me in all the back and forwards and I couldn't visually imagine the difference between my hosted server and this. All setup now after starting it clean.

    Now just to work out how to do the backed up test version of a live wordpress site. Eek
    Last edited by sw1ayfe; December 1st, 2013 at 01:11 AM.

  4. #4
    Join Date
    Nov 2013
    Location
    Sheboygan, WI USA
    Beans
    88
    Distro
    Kubuntu

    Re: Wordpress installation on LAMP

    I do a full db dump from phpmyadmin and then pull it back in to the working server. You can do the same from mysql workbench... just different vernacular.
    Last edited by rackit; December 1st, 2013 at 06:56 AM.
    Kind Regards,

    Jerry Gartner

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •