[HLUG] How to setup mysql??

[Matt Rhys-Roberts]

Hi Emon,

I too am furious that I've found straightforward mysql literature hard 
to find; last I looked, there were too many contradictory startup guides 
to refer between, so I gave up in disgust. Setting up databases properly 
is a science, if you want the best out of them. Setting up mysql seems 
highly distribution-specific, and relies heavily on correctly set file 
paths, ownerships, permissions, user login details etc. I feel there are 
many layers to this onion and skipping any one of them will catch you out.

Therefore I support any moves to talk about mysql more as a LUG. I'm 
just disappointed by my own ignorance, and would like to start listing 
resources that clear  up the whole installation and operation process in 
plain English.

RSVP
Matt Rhys-Roberts


Emon wrote:

>
> Hi all
>
> I am a newbie running Slackware 10.2 with KDE desktop
>
> I am trying to setup mythtv, so I am also having to setup mysql.
>
> I don't know anything about databases so I am kind of trying to 
> (blindly) follow the instructions in the docs & the file 
> /etc/rc.d/rc.mysqld to get mysql up & running...
>
> My runlevel in /etc/inttab is 4 & this is what I see during startup
>
> *********************
> Starting mysqld daemon with databases from /var/lib/mysql
>                  /usr/sbin/nmbd -D
> Starting gpm:  /usr/sbin/gpm -m /dev/mouse -t imps2
> Starting lirc daemon: lircd & lircmd... Done
> Starting Guarddog...
> STOPPING server from pid file /var/run/mysql/mysql.pid
> 060410 18:04:02  mysqld ended
> Done
> Starting LISa daemon...
> Done
> Starting up X11 session manager...
> This is the LAN Information Server LISa 0.2.3
> It is free software according the GNU General Public License
> Copyright (c) 2000-2003 by Alexander Neundorf
> email: neundorf at kde.org
> running on port 7741
> Have fun !  :-)
> *********************
>
> I am still getting the following error while trying to run mythtv
>
> **********************
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-04-10 18:18:34.505 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-04-10 18:18:34.556 Database not open while trying to save 
> setting: Language
> 2006-04-10 18:18:34.574 Unable to connect to database!
> 2006-04-10 18:18:34.574 Driver error was [1/2002]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to local MySQL server through socket 
> '/var/run/mysql/mysql.sock' (2)
> **********************
>
> So what is it that I am doing wrong??
>
> Thanks
> Emon
>
> BTW I also encountered the following errors while running
>
> mysql at magic-box:~$ mysql_install_db
>
> ********************
> ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
> 060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
> './mysql/help_keyword.frm' (errno: 13)
> 060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
> './mysql/help_keyword.frm' (errno: 13)
> ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
> 060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
> './mysql/help_relation.frm' (errno: 13)
> 060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
> './mysql/help_relation.frm' (errno: 13)
> ********************