Slackware This Forum is for the discussion of Slackware Linux.
|
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
02-19-2006, 07:38 AM
|
#1
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Rep:
|
MySQL problem
Hi there,
I'm trying to use mysql server, but there are some problems...
typing 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...
|
|
|
02-19-2006, 07:56 AM
|
#2
|
Senior Member
Registered: Oct 2005
Location: Lithuania
Distribution: Hybrid
Posts: 2,247
Rep:
|
Did you create mysql user and everything else what was told in readme?
|
|
|
02-19-2006, 08:00 AM
|
#3
|
LQ Newbie
Registered: Aug 2003
Location: KunMing China
Distribution: Slackware
Posts: 5
Rep:
|
issue "su -",then input your password,then
#su mysql
$mysql_install_db
then
$/etc/rc.d/rc.mysqld start
|
|
|
02-19-2006, 08:32 AM
|
#4
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Original Poster
Rep:
|
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.
|
|
|
02-19-2006, 08:40 AM
|
#5
|
Senior Member
Registered: Dec 2004
Location: In my house.
Distribution: Ubuntu 10.10 64bit, Slackware 13.1 64-bit
Posts: 2,649
Rep:
|
Did you read the comments in /etc/rc.d/rc.mysqld?
|
|
|
02-19-2006, 09:09 AM
|
#6
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Original Poster
Rep:
|
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.
|
|
|
02-19-2006, 09:14 AM
|
#7
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Original Poster
Rep:
|
actually there isn;t any "host.frm" on my pc..
|
|
|
02-19-2006, 02:14 PM
|
#8
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Original Poster
Rep:
|
plz if anybody has an idea about this...
|
|
|
02-19-2006, 11:27 PM
|
#9
|
Senior Member
Registered: Oct 2005
Location: Lithuania
Distribution: Hybrid
Posts: 2,247
Rep:
|
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.
|
|
|
02-19-2006, 11:32 PM
|
#10
|
LQ Newbie
Registered: Jan 2006
Location: Uki NSW
Distribution: Knoppix
Posts: 2
Rep:
|
Using Knoppix, single HD, /home on separate partition. Package manager reports installed. Cannot open it. Expecting Windows Access like screen. Retrain me please.
Rob.
|
|
|
02-20-2006, 05:44 AM
|
#11
|
LQ Newbie
Registered: Aug 2003
Location: KunMing China
Distribution: Slackware
Posts: 5
Rep:
|
I think your "mysql_install_db" didn't work!
Check your mysql directory,the owner of the directory must be "mysql"
|
|
|
02-20-2006, 07:21 AM
|
#12
|
Senior Member
Registered: Dec 2004
Location: In my house.
Distribution: Ubuntu 10.10 64bit, Slackware 13.1 64-bit
Posts: 2,649
Rep:
|
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.
|
|
|
02-20-2006, 03:36 PM
|
#13
|
Member
Registered: Nov 2005
Location: ath.gr
Distribution: Slackware 11.0 / 2.6.19.1 /Linux Mint
Posts: 124
Original Poster
Rep:
|
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! 
|
|
|
All times are GMT -5. The time now is 10:01 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|