Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

MySQL connection issue
New on LowEndTalk? Please Register and read our Community Rules.

MySQL connection issue

edited October 2012 in General

I've got a 128MB Xen VPS setup using Minstall but am having MySQL connection issues.

MySQL IS up and running, I've created several database / users yet Wordpress can not connect to any of them. Has anyone else had similar issues?

I've never had an issue working with MySQL via SSH before, it's pretty straight forward actually. But now nothing I create can be connected to.

Help a dude out?

vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.

Comments

  • Are you able to connect to your DB by using the command line? mysql -u -p?

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • And check your MySQL error log as well, sometimes that will give you a clue.

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • @zhuanyi said: Are you able to connect to your DB by using the command line? mysql -u -p?

    Yup, I created the users and DBs via command line like I've always done.

    @zhuanyi said: And check your MySQL error log as well, sometimes that will give you a clue.

    Can't find the log(s).

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • @MannDude said: Can't find the log(s).

    There is no DBName.err file or nothing about MySQL log in /var/log?

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • /var/log/mysql is empty.

    The files
    /var/log/mysql.log and /var/log/mysql.err are also both empty.

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • Weird, at least your log file should not be empty, and I assume you checked your pid file to make sure MySQL is actually up and running?

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • Yup, it's running, as confirmed by: 'htop', 'ps -aux' but strangely NOT 'top'.

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • @MannDude said: Yup, it's running, as confirmed by: 'htop', 'ps -aux' but strangely NOT 'top'.

    Permission issue so that MySQL could not write to the logs? I am at my wit's end...may be rebooting the VPS would help?

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • @zhuanyi said: Permission issue so that MySQL could not write to the logs? I am at my wit's end...may be rebooting the VPS would help?

    Perhaps. I'll give that a go.

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • @MannDude said: Perhaps. I'll give that a go.

    Good luck :)

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • Reboot 'scheduled'.

    Not instant reboots...

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • @MannDude said: Reboot 'scheduled'.

    Can you do shutdown -r yourself in the VPS?

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • @zhuanyi said: Can you do shutdown -r yourself in the VPS?

    It's already rebooted. Same issue...

    I may just uninstall MySQL, and reinstall it manually and not with Minstall and just tweak it manually to reduce it's mem usage...

    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
  • @MannDude said: Same issue...

    Sorry I could not help any further...

    Thanked by 1[Deleted User]

    http://BornIn.Asia - FREE shared hosting and subdomain service for LET members! Click here to see how to get one yourself!
    96Forum: Low End VPS Discussions. Selling domains with GApp with various user counts (10 year reg incl. for some)

  • Still threw some thanks your way for the time spent trying.

    Thanked by 1zhuanyi
    vpsBoard.com - Now with over 450 members! A friendly community with active discussion. Come join us!

    IRC.FREENODE.NET #vpsBoard - Drop by and say, 'Hello'.
Sign In or Register to comment.