Table of Contents

documenting wowvps debian setup

it's either debian bug or something with wowvps debian image so we need extra steps to setup debian with wowvps

  • remove linux-image* as it's not used
  • aptitude update && aptitude safe-upgrade
  • check iptables -L. if it gives you error missing kernel module, open ticket ask them to fix it.
  • check if you can access mysql as root. otherwise, you might manually create root user and grant all privileges
  • check /tmp permission

manually add root user to mysql:

/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql --user=root mysql
mysql> INSERT INTO user
    ->     VALUES('%','rootalmightyusername',PASSWORD('some_pass'),
    ->     'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
    ->     'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
    ->     '','','','',0,0,0,0);
mysql> flush privileges;
mysql> quit
/etc/init.d/mysql stop
/etc/init.d/mysql start
#test it:
mysql -u rootalmightyusername -p some_pass
Add a New Comment
or Sign in as Wikidot user
(will not be published)
- +
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License