MySQL connection issue

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?

    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), PM for details.

    Thanked by 1[Deleted User]
  • And check your MySQL error log as well, sometimes that will give you a clue.

    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), PM for details.

    Thanked by 1[Deleted User]
  • @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?

    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), PM for details.

    Thanked by 1[Deleted User]
  • /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?

    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), PM for details.

    Thanked by 1[Deleted User]
  • 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?

    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), PM for details.

    Thanked by 1[Deleted User]
  • @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 :)

    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), PM for details.

    Thanked by 1[Deleted User]
  • 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?

    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), PM for details.

    Thanked by 1[Deleted User]
  • @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...

    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), PM for details.

    Thanked by 1[Deleted User]
  • Still threw some thanks your way for the time spent trying.

    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'.
    Thanked by 1zhuanyi
Sign In or Register to comment.