With a simple script and a few commands in mysql – you are ready to go…..
After setting up a new Ubuntu Server, these are the steps to complete:
1: Download prep-script from ftp.cmcs.dk
2: Run script
3: run “Mysql -u root -p”
4: execute the following commands:
4a: create database xxx
4b: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON xxx.* TO ‘yourusername’@’localhost’ IDENTIFIED BY ‘yourpassword’;
4c: flush privileges;
5: sudo shutdown -r now
open your server with a browser.