paulmellors.net | Paul Mellors

After posting earlier about having problems with Ubuntu Server and mysql I was given a little lesson in command line mysql by Philip Newborough [thanks]

I think i’ll pass it on. My problem was creating mysql users/databases via phpmyadin which left me unable to import my .sql files. Here’s what i had to do.

1, mysql –user=”root” –password=”your_root_password” - This connects to the mysql server as root

2, CREATE USER ‘new_username’@'localhost’ IDENTIFIED BY ‘password_for_new_username’;

3, GRANT ALL ON *.* TO ‘new_username’@'localhost’;

4, create database databasename;

I could then import my .sql files using -

mysql -u<username> -p database < databasefile.sql

If you’re reading this post then you’re reading it on my shiny new install of Ubuntu Heron Server 8.04 LTS.

I was using CentOS as a web server and while it worked fine i wanted to use a debian based server. I downloaded the Heron LTS iso and installed it, rather than install a LAMP system from the install i did a basic install so i could install the AMP parts manually. All went well until i wanted to restore my mysql databases. I use phpmyadmin to create databases because i’m lazy and it’s easy to click the priveleges link, add the usename/password job done but when i used the mysql command to import the .sql files, this is where it went tits up. For some reason it kept giving me

ERROR 1045 (28000) : Access denied for user: ‘myusername@localhost’ (Using password: YES)

I knew the username and password was correct but apprently it’s something to do with the user information being wrong in the user table….don’t ask me what, i gave up after a while and installed debian etch which i knew would work straight away…….

I’ll figure it out but until i do, debian [which i think is actually quicker on my machine than CentOS] will stay on it.

1, download the rpm from here

2, install pam-devel [ a requirement for VirtualBox]

3, rpm -Uvh the VirtualBox rpm

4, add your username to the vboxusers group

5, reboot

6, ENJOY

WEB - http://www.diggnationfans.com

IRC - #diggnationfans @ irc.freenode.net

Today i’ve decided i want to become an Ubuntu Member [see here]

eeek seems i have to do this, i suppose i better find a way to contribute to Ubuntu and it’s community.

1. Document your work on your home page on the Ubuntu Wiki. This can include links to code, mailing list messages, or wiki pages. It can also include narrative descriptions.

2. Be prepared to have current Ubuntu members provide testimonials on your work and involvement in Ubuntu. For many types of work, testimonials will be the single most important part of a members application. For example, if you are doing great work with the MOTU, ask some of them to be at the Community Council meeting where your membership is considered.

3. Add yourself to the Community Council Agenda and link to the wiki page

4. If it is convenient, come to the next Community Council meeting.

5. Upon approval by the council, you will need to “sign” a copy of the Code of Conduct. This can be done in three ways:

1. A signed (i.e., with a pen) paper copy FAXed to Benjamin Mako Hill at (+1) 815.361.7509.

2. A cryptographic (GPG) signature on the text of the code itself sent to Benjamin Mako Hill

3. A cryptographic (GPG) signature on the Code of Conduct in your Launchpad account.

• @princesssudi : sleep well #
• paul is off to work in 3 hours #
• Is contemplating moving his web server over to Heron. #
• @loudmouthman: it would be nice to think so. #
• paul has downloaded heron server, does he replace CentOS with it? #
• I finally beat Slash on medium GH3 #
• paul is creating a time lapse film using a webcam, motion and mencoder….. #
• @loudmouthman: stop mentioning suzy perry, i can’t concentrate now. #
• @princesssudi you’re welcome, have a good day, i’m coming to the end of mine, 3 hours till midnight then i can go home. #
• paul hopes he doesn’t get into trouble for setting up diggnationfans.com…*gulp* #
• @Steve well if i was in the area i would visit, but she’d only think who’s this freak coming to visit me #
• @glenn mcelhose: get him to wear some daisy’s in his hair. #
• @glennmc oops i meant you all wear daisy’s in your hair. #
• And on this final twitter, i bid thee a fond farewell and look forward to the glorious events of the morrow. #

• Thankful for the USB key he won as a power surge took out the laptop last night. #
• paul wants more than 3 twitter friends, follow me and i’ll follow you #
• paul is getting free things at http://www.freethingsforyou.com #
• paul is also a diggnation fan - http://www.diggnationfans.com #
• now i don’t have to log into facebook to update my status, i wonder how many requests i’ve got for crappy application installs? #
• Paul is not looking forward to 2 weeks of 3:30 - Midnight #
• @princesssudi it’s my working hours shift …. booooo #
• And as the night draws in, i bid thee farewell…..Goodnight all. #

Today i’m starting an experiment. My friend has been going on at me telling me about all the free items he’s been receiving ipod touch, nano etc So i’m going to have a go myself. Ok let me explain a little more. You sign up to a specific site which gives you a referral ID. You then take up one of their offers, which could be lovefilm, or a number of others, this gives you one complete offer, you then refer your mates to take up one of these offers, when they do you get that referral. To get the free item you need to get a specific amount of these referrals. So today i’m putting out my referal code, i’ve got a couple of domain names that i’m going put information on and see what happens.

Here is my referal code, take a look….

http://apple.freebiejeebies.co.uk/24988

*** UPDATE ***

http://www.freethingsforyou.com

http://www.freethingsforyou.com/forum

With 5 days to go, Hardy Heron is turning into a fantastic release. I’ve been using it for a while now, yes i’m one of those nutters that like to upgrade pre-alpha and play But i can quite honestly say, this is one of the best versions i’ve used, it just keeps getting better. It will be interesting to see how it fairs with the other major distros that are also preparing to release new versions, Fedora and opensuse.

No matter how many times i switch to different distros i always seem to come back to ubuntu…..They must be doing something right.

Thank goodness they do

telnet towel.blinkenlights.nl