edit this panel
Site Manager

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:
http://dev.mysql.com/doc/mysql/en/adding-users.html

/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