mysql question (solved)

[stretchedthin]

I'm trying to build mythtv for Vector and have a build ready to test.  The trouble is that before I can do that I need to create a database with mysql.  I have zip experience with mysql but I did try running the command they gave in the instructions as root...
mysql -u root -p  < /usr/share/mythtv/database/mc.sql

This results in the following error....
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

I'm stuck here, I was hoping someone with a little more mysql experience could help me out.

[retired1af]

First is mysql started? Post the contents of /etc/my.cnf

[bigpaws]

Did you

mysql_install_db, then do a chown at /var/lib/mysql to mysql.mysql.

Bigpaws

[stretchedthin]

Did you

mysql_install_db, then do a chown at /var/lib/mysql to mysql.mysql.

Bigpaws

First is mysql started? Post the contents of /etc/my.cnf

I've done none of those things.  My only experience with Mysql was installing a preconfigured Xampp set-up back in 2002, when I only used Windows...(Lord have mercy on my soul.)

So it's safe to assume I've done nothing but install mysql from gslapt.  Any step by step would be appreciated.

[stretchedthin]

First is mysql started? Post the contents of /etc/my.cnf

I don't seem to have an /etc/my.cnf.  I have my-huge.conf, my-large.cnf, my-medium.cnf, and my-small.cnf. 
I think these are sample files and mysql still needs some set-up before it is good to go. I'm going to do a little digging on my own and see what google can tell me.  If anyone can give a step by step and save me the trouble that would be appreciated.

[retired1af]

First of all, we need to start the sql service....

service mysql start

Once the server is started, you should be able to run:

mysql -u root -p  < /usr/share/mythtv/database/mc.sql

However, there's a lot more to running sql. How deep do you really want to get into it?

[stretchedthin]

Only as deep as I need to for now.  Which I was hoping was ankle deep, but is starting to look a little more like mid thigh.
I'm trying to follow this tut here from the how to's http://forum.vectorlinux.com/index.php?topic=7158.0

Basically I just want to get far enough to launch the command required for mythtv...
mysql -u root -p  < /usr/share/mythtv/database/mc.sql
and then I should be ready to start mythtv-setup

[stretchedthin]

Here is what I'm getting...
root:# service mysql start
service mysql is not active.

From the error mentioned earlier ...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

It looks like there should be some contents in the directory /var/run/mysql/ but when I check mine it is empty.  No 'mysql.sock' or anything else for that matter.

[stretchedthin]

When I type...

root:# service -a

I get the following....
Services level    2    3    4    5
bluetooth*        -    -    -    -   
cron*             -    on   -    on   
cups*             on   on   on   /sbin/service: line 100: [: /etc/rc.d/rc5.d/S39cups: binary operator expected
-   
firewall          -    -    -    -   
fuse*             -    -    -    -   
gpm*              on   -    -    -   
gslaptd*          -    -    on   -   
inetd*            -    on   -    on   
lm_sensors*       -    -    -    -   
portmap*          -    -    -    -   
samba*            -    -    on   -   
sshd*             -    on   on   on   
wicd*             on   on   on   on   
wifi-radar*       -    -    -    -   

I don't see a mysql service option at this run level.  Don't know what to make of this.

[retired1af]

I'm going to have to dig into this a bit, and I'll get back to you sometime tomorrow on it. I'm used to MYSQL in a server environment (CentOS) and the standard stuff that I would use on the server isn't working so hot on the notebook. Lemme dig into the differences and figure out how to get the server started, and I'll post the steps once I have it figured out.

[stretchedthin]

Awesome, that is greatly appreciated.

[stretchedthin]

I've found a thread that may help...http://forum.vectorlinux.com/index.php?topic=7162.msg48964#msg48964

Before you invest to much time I'll play with this and let you know where I run into roadblocks.
Ken

[stretchedthin]

retired1af, I found what I needed it's here http://www.basicconfig.com/linuxservers/setup_configure_mysql_slackware
Thanks for being willing to dig into this for me, but I think I'm good now.

[retired1af]

Good deal.