[12:24] <mdke_> popey?
[02:33] <tonyyarusso> sigh
[02:34] <tonyyarusso> So I fail at wikis a lot.  How do you do a comment again?  (Tried #)
[02:39] <crimsun> ##
[02:40] <tonyyarusso> Ah
[02:40] <tonyyarusso> thanks
[02:44] <Madpilot> you were halfway there ;)
[12:06] <mdke> popey: awake?
[12:07] <popey> hi
[12:07] <mdke> popey: sorry, was out for dinner. Good time to run through that mysql thing?
[12:07] <popey> sure
[12:08] <mdke> are you able to connect to my screen session?
[12:08] <popey> i thought I could, but it seems that's not possible
[12:09] <mdke> I only just started it
[12:09] <popey> you have to both be logged in under the same account
[12:09] <mdke> oh well.
[12:09] <mdke> talk me through it?
[12:09] <popey> do you have a web based admin tool on that box?
[12:10] <popey> something like phpmyadmin?
[12:10] <mdke> no
[12:10] <mdke> I can look up the commands, but if you can tell me them that's better :)
[12:10] <popey> heh
[12:10] <popey> well the first one is easy
[12:11] <popey> do you have the root password?
[12:11] <mdke> popey: I have admin access
[12:12] <popey> ok, here's what I need
[12:12] <popey> 1) create a database
[12:13] <popey> 2) create a user which has access to that database, and give it a password
[12:13] <popey> 3) let me know what the above are
[12:13] <popey> I don't know the exact command syntaxes, I'd have to muddle through
[12:13] <mdke> I'll see if I can find a helpful guide
[12:13] <popey> well, the first step is easy
[12:13] <popey> mysql
[12:13] <popey> create database foo;
[12:14] <popey> however when you start mysql you need to start it with a user that has mysql admin access
[12:14] <popey> mysql -u adminuser -p
[12:14] <popey> and it will prompt for the password
[12:14] <popey> then when in, create the database with "create database foo;"
[12:15] <mdke> users with mysql are separate from users on the system, are they?
[12:16] <popey> they can be
[12:16] <popey> there is a user table which may reference real users
[12:16] <popey> usually root@ exists initially
[12:16] <mdke> good start:
[12:17] <mdke> root@hudson:~ # mysql
[12:17] <mdke> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[12:17] <popey> yes
[12:17] <popey> that's why you need to do