LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 03-03-2010, 06:39 PM   #1
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 970

Rep: Reputation: 44
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:

Code:
nohup: redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
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:

Code:
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!

Thanks!
 
Old 03-03-2010, 06:55 PM   #2
Chuck56
Member
 
Registered: Dec 2006
Location: Colorado
Distribution: Slackware
Posts: 421

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

Code:
# 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, 07:10 PM   #3
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 970

Original Poster
Rep: Reputation: 44
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.!
 
  


Reply


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
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2) peteyperson Linux - Server 2 03-04-2009 01:16 PM
mysql & slack 12 danpadams Slackware 3 07-06-2007 04:21 PM
How to install & run Java and Mysql on Mandrake 10.1. 2455 Linux - General 1 08-12-2005 10:04 AM
Problems with MySQL in Slack 10 Philter Slackware 3 12-31-2004 08:15 AM
slack, webmin, & mySQL e1000 Slackware 3 01-26-2004 11:19 AM


All times are GMT -5. The time now is 07:20 PM.

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