mysql configuration

integrale16 · 10-22-2010, 12:22 PM

Hello,

do I have to do a basic configuration / initialisation of mysql, like described in the following link, before I can use it?

http://www.basicconfig.com/linuxserv...ysql_slackware

The background is, that I want to use mythtv and therefore I need a working mysql.
When I tried to create the needed database, as described in the file README.SLACKWARE (included in mythtv.Slackbuild package from slackbuilds.org) with the following command, I got an error:
# mysql -u root -p < /usr/share/mythtv/database/mc.sql

The error message was:
ERROR 1146 (42S02) at line 3: Table 'mysql.servers' doesn't exist

--
integrale

PS: I don't remember that I ever did a basic configuration but mysql was already used by joomla, and it worked right out of the box.

kirukan · 10-22-2010, 12:41 PM

This means you are trying to restore the database which is already exist...

Quote:

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

Before this just check whether the mysql running on server

Quote:

#ps aux | grep mysql

integrale16 · 10-22-2010, 03:38 PM

Thanks for your reply, but it doesn't exactly answer my question.

Do I have to do a basic configuration / initialisation of mysql, like described in the link above, before I can use it?

--
integrale

T3slider · 10-22-2010, 03:44 PM

Read /etc/rc.d/rc.mysqld -- the comments at the top of the file should explain the necessary procedure.

Code:

# ps aux | grep mysql

as suggested by kirukan would tell you if mysql is running or not -- it cannot run unless it has been setup properly in the first place, so if it is running then you likely do not have to set it up beyond 'restoring' the tables from mythtv. If it is not running, then see /etc/rc.d/rc.mysqld, follow those steps, then get mysql running, and then restore the tables for mythtv.

lssanjose · 10-22-2010, 04:46 PM

Following those instructions to the letter on that page, has helped me to get mysql running flawlessly.

tuxrules · 10-22-2010, 04:48 PM

Quote:

Originally Posted by integrale16

Do I have to do a basic configuration / initialisation of mysql, like described in the link above, before I can use it?

Slackware doesn't come with any mysql database installed (not even the default one). You can to install them first before you can create any new databases. As T3slider said, read rc.mysqld

For mythtv, here's what I do.

As root:

Code:

mysql_install_db --user=mysql
/etc/rc.d/rc.mysqld start
mysql_secure_installation
mysql -u root -p # log into mysql server
CREATE DATABASE mythconverg;
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'localhost' IDENTIFIED BY 'mythtv-passwd' WITH GRANT OPTION;