Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 03-03-2010, 07:39 PM   #1
Registered: Nov 2008
Posts: 985

Rep: Reputation: Disabled
Question MySQL & Slack 12.2 problems with getting the thing to run...

Hi! I installed MySQL 5.1.44 on my laptop and at first (2 days ago) it worked perfectly. I then decided to install the same thing on my server that also runs slack 12.2... it never worked. I initially followed the instructions step by step in the MySQL manuals and website, tried to get help from google, etc, but still doesnt work.

Basically, when I run /etc/rc.d/rc.mysqld start, I get:

nohup: redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/
100303 19:28:10 mysqld ended
This is it.... .../mysql/support-files/mysql.server starts successfully.

The only "error" I've found in the whole system is in the /var/lib/mysql/localnfs1.err log file... It says:

100303 19:29:10  mysqld started
100303 19:29:10 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100303 19:29:10 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100303 19:29:10 [ERROR] /usr/libexec/mysqld: unknown variable 'table_open_cache=256'
100303 19:29:10  mysqld ended
Any Idea of whats going on?

Now it doesnt run anymore on my laptop.... Sounds like my computers are possessed!

Old 03-03-2010, 07:55 PM   #2
Registered: Dec 2006
Location: Colorado
Distribution: Slackware
Posts: 469

Rep: Reputation: 70
Did you read the comments at the top of /etc/rc.d/rc.mysqld?

# Before you can run MySQL, you must have a database.  To install an initial
# database, do this as root:
#   mysql_install_db --user=mysql
# Note that the mysql user must exist in /etc/passwd, and the created files
# will be owned by this dedicated user.  This is important, or else mysql
# (which runs as user "mysql") will not be able to write to the database
# later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
That needs to be done otherwise MySQL doesn't work.
Old 03-03-2010, 08:10 PM   #3
Registered: Nov 2008
Posts: 985

Original Poster
Rep: Reputation: Disabled
Chuck56, of course I did the mysql_install_db --user=mydql thing...! Also, the mysql user is in the /etc/passwd file => mysql:x:27:27:MySQL:/var/lib/mysql:/bin/false

Problem persist.!


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
slack, webmin, & mySQL e1000 Slackware 5 04-28-2015 10:45 AM
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2) peteyperson Linux - Server 2 03-04-2009 02:16 PM
mysql & slack 12 danpadams Slackware 3 07-06-2007 05:21 PM
How to install & run Java and Mysql on Mandrake 10.1. 2455 Linux - General 1 08-12-2005 11:04 AM
Problems with MySQL in Slack 10 Philter Slackware 3 12-31-2004 09:15 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 08:47 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration