LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 02-19-2006, 07:38 AM   #1
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Rep: Reputation: 15
Unhappy MySQL problem


Hi there,

I'm trying to use mysql server, but there are some problems...

typing
Code:
mysql
this error appears
Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
typing:
Code:
/etc/rc.d/rc.mysqld start
/usr/bin/mysqld_safe: line 162: ./bin/my_print_defaults: cannot execute binary file
root@argos:~/Desktop/mysql-standard-5.0.18-linux-x86_64-glibc23/mysql-standard-5.0.18-linux-x86_64-glibc23# /usr/bin/mysqld_safe: line 167: ./bin/my_print_defaults: cannot execute binary file
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
060219 15:32:42  mysqld ended

so, I just got bored, and downloaded the newest binary files...
when trying to "configure" them, it shows this error message


Code:
3# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

./scripts/mysql_install_db: line 85: ./bin/my_print_defaults: cannot execute binary file
Neither host 'argos' nor 'localhost' could be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
however, resolveip works fine manually..

I dont know if there's any relation between the first two err msgs and the last one...

Thanks in advance...
 
Old 02-19-2006, 07:56 AM   #2
Alien_Hominid
Senior Member
 
Registered: Oct 2005
Location: Lithuania
Distribution: Hybrid
Posts: 2,247

Rep: Reputation: 53
Did you create mysql user and everything else what was told in readme?
 
Old 02-19-2006, 08:00 AM   #3
LeiDan
LQ Newbie
 
Registered: Aug 2003
Location: KunMing China
Distribution: Slackware
Posts: 5

Rep: Reputation: 0
issue "su -",then input your password,then
#su mysql
$mysql_install_db

then
$/etc/rc.d/rc.mysqld start
 
Old 02-19-2006, 08:32 AM   #4
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Original Poster
Rep: Reputation: 15
Alien_Hominid, yes I guess this things are set up, but i rather solve the problems on existing installation...
so I did you told me LeiDan...

Code:
root@argos:~# su mysql
mysql@argos:/root$ mysql_install_db
Installing all prepared tables
ERROR: 1005  Can't create table 'db' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/db.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1005  Can't create table 'host' (errno: 13)
ERROR: 1005  Can't create table 'user' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
060219 16:12:11 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/user.frm' (errno: 13)

[...........................................]

RROR: 1005  Can't create table 'columns_priv' (errno: 13)
ERROR: 1005  Can't create table 'help_topic' (errno: 13)
ERROR: 1005  Can't create table 'help_category' (errno: 13)
ERROR: 1005  Can't create table 'help_relation' (errno: 13)
ERROR: 1005  Can't create table 'help_keyword' (errno: 13)
ERROR: 1005  Can't create table 'time_zone_name' (errno: 13)
ERROR: 1005  Can't create table 'time_zone' (errno: 13)
ERROR: 1005  Can't create table 'time_zone_transition' (errno: 13)
ERROR: 1005  Can't create table 'time_zone_transition_type' (errno: 13)
ERROR: 1005  Can't create table 'time_zone_leap_second' (errno: 13)
Fill help tables
[.........................................]

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h argos password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
mysql@argos:/root$ /etc/rc.d/rc.mysqld start
mysql@argos:/root$ Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
060219 16:12:49  mysqld ended
an about two pages of other similar errors where dots [..] in text....

Id ran that from root before and it d said
Code:
STOPPING server from pid file /var/run/mysql/mysql.pid
again but without all these "can;t find file"...

Last edited by Ellops; 02-19-2006 at 08:33 AM.
 
Old 02-19-2006, 08:40 AM   #5
cwwilson721
Senior Member
 
Registered: Dec 2004
Location: In my house.
Distribution: Ubuntu 10.10 64bit, Slackware 13.1 64-bit
Posts: 2,649
Blog Entries: 1

Rep: Reputation: 68
Did you read the comments in /etc/rc.d/rc.mysqld?
 
Old 02-19-2006, 09:09 AM   #6
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Original Poster
Rep: Reputation: 15
these: ?

Code:
mysql@argos:/usr/libexec$ /usr/libexec/mysqld
060219 17:11:31  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060219 17:11:31  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
060219 17:11:31  InnoDB: Flushing modified pages from the buffer pool...
060219 17:11:31  InnoDB: Started; log sequence number 0 43634
060219 17:11:31 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060219 17:11:31 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060219 17:11:31 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

Last edited by Ellops; 02-19-2006 at 09:10 AM.
 
Old 02-19-2006, 09:14 AM   #7
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Original Poster
Rep: Reputation: 15
actually there isn;t any "host.frm" on my pc..
 
Old 02-19-2006, 02:14 PM   #8
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Original Poster
Rep: Reputation: 15
plz if anybody has an idea about this...
 
Old 02-19-2006, 11:27 PM   #9
Alien_Hominid
Senior Member
 
Registered: Oct 2005
Location: Lithuania
Distribution: Hybrid
Posts: 2,247

Rep: Reputation: 53
Actually I had this error with mysql.pid when I messed up my mysql installation not following the readme (tried installing as root). There could be also conflict between original slackware mysql and this if you forgot to remove original mysql first. I suggest you to try installing everything from scratch.
 
Old 02-19-2006, 11:32 PM   #10
Robert Griffiths
LQ Newbie
 
Registered: Jan 2006
Location: Uki NSW
Distribution: Knoppix
Posts: 2

Rep: Reputation: 0
Using Knoppix, single HD, /home on separate partition. Package manager reports installed. Cannot open it. Expecting Windows Access like screen. Retrain me please.
Rob.
 
Old 02-20-2006, 05:44 AM   #11
LeiDan
LQ Newbie
 
Registered: Aug 2003
Location: KunMing China
Distribution: Slackware
Posts: 5

Rep: Reputation: 0
I think your "mysql_install_db" didn't work!
Check your mysql directory,the owner of the directory must be "mysql"
 
Old 02-20-2006, 07:21 AM   #12
cwwilson721
Senior Member
 
Registered: Dec 2004
Location: In my house.
Distribution: Ubuntu 10.10 64bit, Slackware 13.1 64-bit
Posts: 2,649
Blog Entries: 1

Rep: Reputation: 68
Quote:
Originally Posted by cwwilson721
Did you read the comments in /etc/rc.d/rc.mysqld ?
This file has the steps to setup mysql correctly. This post :
Quote:
Originally Posted by Ellops
these: ?

Code:
mysql@argos:/usr/libexec$ /usr/libexec/mysqld
060219 17:11:31  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060219 17:11:31  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
060219 17:11:31  InnoDB: Flushing modified pages from the buffer pool...
060219 17:11:31  InnoDB: Started; log sequence number 0 43634
060219 17:11:31 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060219 17:11:31 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060219 17:11:31 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
is not the file.

Last edited by cwwilson721; 02-20-2006 at 07:25 AM.
 
Old 02-20-2006, 03:36 PM   #13
Ellops
Member
 
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by cwwilson721
Did you read the comments in /etc/rc.d/rc.mysqld?
Well, sorry, i misunderstood that cuz these steps are the same with the ones LeiDan mentioned and I already had followed them as i said above.


Because I am in a big rush, however, I just made a fresh installation of slack (was about time anyway...), because "somehting" had messed it up....
now works fine,
thanks anyway guys!
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 04:16 PM
MySQL server problem after linking (mysql.sock) ewijaya Linux - General 4 01-19-2004 09:46 AM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 02:02 PM

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

All times are GMT -5. The time now is 10:01 AM.

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