Results 1 to 8 of 8

Thread: MySQL installation on Ubuntu 12.04 with nginx

  1. #1
    Join Date
    Feb 2014
    Beans
    15

    MySQL installation on Ubuntu 12.04 with nginx

    Hey guys I'm trying to follow the digital ocean tutorial to install a WordPress on a vps, but every time I try I can't establish a database connection. There must be something I'm doing wrong... Could someone hint me to a more noob proof guide To install MySQL on nginx?

    thanks

  2. #2
    Join Date
    Jan 2009
    Beans
    Hidden!
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: MySQL installation on Ubuntu 12.04 with nginx

    Are you sure mysqld is running?
    Code:
    ps ax | grep mysql

  3. #3
    Join Date
    Feb 2014
    Beans
    15

    Re: MySQL installation on Ubuntu 12.04 with nginx

    Hey thanks for that command. My SQL was running. I got a little frustrated and set out to try again with another Ubuntu install. Hopefully I'll manage this time.

  4. #4
    Join Date
    Feb 2014
    Beans
    15

    Re: MySQL installation on Ubuntu 12.04 with nginx

    I've tried again and am now stuck while trying to create a database on MySQL with the following command:
    Code:
    mysql -u USERNAME -pPASSWORD -e 'create database DB_NAME'
    and recieve the following error:
    Code:
    ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES)
    How to find out what the issue is?

  5. #5
    Join Date
    Apr 2012
    Beans
    5,471

    Re: MySQL installation on Ubuntu 12.04 with nginx

    Did you actually set up a mysql user called USERNAME? iirc the default mysql-server install scripts only prompt you to set up the 'root'@'localhost' account

  6. #6
    Join Date
    Feb 2014
    Beans
    15

    Re: MySQL installation on Ubuntu 12.04 with nginx

    I've changed the values for USERNAME, PASSWORD and DB_NAME to my own values

    I have been following this tutorial: https://rtcamp.com/wordpress-nginx/t...-site/minimal/

  7. #7
    Join Date
    Apr 2012
    Beans
    5,471

    Re: MySQL installation on Ubuntu 12.04 with nginx

    OK let me try to rephrase. Is there a mysql user account with the "own values" of USERNAME and PASSWORD that you used?

  8. #8
    Join Date
    Feb 2014
    Beans
    15

    Re: MySQL installation on Ubuntu 12.04 with nginx

    hmm reading back the tutorial never mentions creating a user befor exept root and a password... I probably should do that

    Edit: Btw somehow I made a mistake and I recieve a "502 Bad Gateway" error. How to figure out what happened?
    Last edited by Youri_van_Dijk; February 13th, 2014 at 03:58 PM.

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
  •