LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 06-26-2004, 02:02 PM   #1
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Rep: Reputation: 15
Starting MySQL on fresh Slack install


After reading several posts on this and other forums, I still have yet to successfully get the mySQL server up and running. I can only assume it's because I'm looking at installs for RedHat (which most tutorials go through) and not a Slackware specific tutorial. Most things I read have different directories, etc. which I can deal with, but the one I'm reading now says to change permissions on /usr/local/mysql/data, and after searching, there is no data folder under a mysql folder on the entire drive. I know RPM installs do automatic things and have also discovered that the mySQL user is already setup on my install. What I don't know is what comes after mysql_install_db. I'll post commands and error logs though, so maybe someone can point me in the right direction.

bash-2.05b# /usr/bin/mysqld_safe &
[1] 2549
bash-2.05b# Starting mysqld daemon with databases from /var/lib/mysql
040625 23:23:36 mysqld ended

Here is the error file.

bash-2.05b# cat Rage.err
040625 23:19:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040625 23:19:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040625 23:19:21 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040625 23:19:21 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040625 23:19:22 InnoDB: Started
040625 23:19:22 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040625 23:19:22 Aborting

040625 23:19:22 InnoDB: Starting shutdown...
040625 23:19:24 InnoDB: Shutdown completed
040625 23:19:24 /usr/libexec/mysqld: Shutdown Complete

040625 23:19:24 mysqld ended

040625 23:23:06 mysqld started
040625 23:23:06 InnoDB: Started
040625 23:23:06 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040625 23:23:06 Aborting

040625 23:23:06 InnoDB: Starting shutdown...
040625 23:23:09 InnoDB: Shutdown completed
040625 23:23:09 /usr/libexec/mysqld: Shutdown Complete

040625 23:23:09 mysqld ended

040625 23:23:34 mysqld started
040625 23:23:34 InnoDB: Started
040625 23:23:34 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040625 23:23:34 Aborting

040625 23:23:34 InnoDB: Starting shutdown...
040625 23:23:36 InnoDB: Shutdown completed
040625 23:23:36 /usr/libexec/mysqld: Shutdown Complete

040625 23:23:36 mysqld ended

040626 13:12:54 mysqld started
040626 13:12:55 InnoDB: Started
040626 13:12:55 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040626 13:12:55 Aborting

040626 13:12:55 InnoDB: Starting shutdown...
040626 13:12:57 InnoDB: Shutdown completed
040626 13:12:57 /usr/libexec/mysqld: Shutdown Complete

040626 13:12:57 mysqld ended
 
Old 06-26-2004, 02:20 PM   #2
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,552

Rep: Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872
did you read the comment in /etc/rc.d/rc.mysqld ? Did you chown -R mysql /var/lib/mysql ?
Did you try install script like /usr/bin/mysql_secure_installation ?
 
Old 06-26-2004, 02:33 PM   #3
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Original Poster
Rep: Reputation: 15
ok, did the chown and tried running the script, here's what I got

/usr/bin/mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): *entered password*
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
 
Old 06-26-2004, 02:34 PM   #4
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,552

Rep: Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872
try /etc/rc.d/rc.mysqld start before
Quote:
Enter current password for root (enter for none):
This is root password for mysql not the same as system

Last edited by keefaz; 06-26-2004 at 02:36 PM.
 
Old 06-26-2004, 03:58 PM   #5
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Original Poster
Rep: Reputation: 15
Quote:
Originally posted by keefaz
try /etc/rc.d/rc.mysqld start
I get a permission denied here logged as root

Quote:
This is root password for mysql not the same as system
I haven't set a mysql root password as far as I know.
 
Old 06-26-2004, 04:05 PM   #6
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,552

Rep: Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872Reputation: 872
Quote:
I get a permission denied here logged as root
chmod +x /etc/rc.d/rc.mysqld then, but if you don't want mysqld runinng automatically at boot, do /usr/bin/mysqld_safe & by hand
 
Old 06-26-2004, 04:35 PM   #7
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Original Poster
Rep: Reputation: 15
wow, with that one command it's up and running. Thanks so much, didn't want to have nothing to show for 4 hours of searching and reading today.
 
Old 06-26-2004, 04:44 PM   #8
subnet_rx
Member
 
Registered: Oct 2001
Distribution: Ubuntu 9.10
Posts: 148

Original Poster
Rep: Reputation: 15
btw, would this mean it's running mysql as root or the mysql user?
 
  


Reply



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
fresh install of mysql but... bshearer *BSD 12 07-20-2005 09:56 PM
Slack 10 - No Sound After Fresh Install IamI Slackware 8 06-16-2005 08:30 PM
fresh slack 10.1 install (2.4.29) on a D915GEV MB coocoopuff Slackware 1 05-30-2005 12:41 PM
Fresh Debian install locks while starting up Imek Debian 1 10-02-2004 07:36 AM
Starting mysql in slack 10 kmoffat Slackware 1 07-11-2004 04:07 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 02:41 PM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration