LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-18-2005, 07:24 AM   #1
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Rep: Reputation: 30
MySQL start problem!!


i have installed MySQL and i cant start it... ( maybe i wrong something,somewhere ) )

i receive that when i try to start it..

Failed to start database :
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

what and where must i type to start it..!!!
 
Old 06-18-2005, 10:56 AM   #2
comprookie2000
Gentoo Developer
 
Registered: Feb 2004
Location: Fort Lauderdale FL.
Distribution: Gentoo
Posts: 3,291
Blog Entries: 5

Rep: Reputation: 58
What distro, how did you install, post the readme or install file.
 
Old 06-20-2005, 04:49 PM   #3
Not now, John!
Member
 
Registered: Jul 2004
Distribution: LFS 5.1
Posts: 161

Rep: Reputation: 30
Try running mysql_install_db but backup /var/lib/mysql first!
 
Old 06-20-2005, 08:45 PM   #4
Warmduvet
Member
 
Registered: Jun 2004
Location: New Zealand
Posts: 60

Rep: Reputation: 15
Try service mysqld start


this might help

http://www.techspot.com/vb/all/windo...ra-Core-3.html
 
Old 06-22-2005, 04:52 PM   #5
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Original Poster
Rep: Reputation: 30
nope dont w0rx... same error again!
 
Old 06-22-2005, 05:47 PM   #6
Warmduvet
Member
 
Registered: Jun 2004
Location: New Zealand
Posts: 60

Rep: Reputation: 15
Have you got apt? (debian package managing utility) or yum, try to upgrade. apt has a fix command that will repair a program. othewise uninstall and try again using apt or yum.


WD
 
Old 06-23-2005, 02:41 AM   #7
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Original Poster
Rep: Reputation: 30
yes i have it...with apt i have installed the mysql-server ...
the problem is that it cant START!!!...

i am running on FC3
 
Old 06-23-2005, 03:16 AM   #8
Warmduvet
Member
 
Registered: Jun 2004
Location: New Zealand
Posts: 60

Rep: Reputation: 15
if your running fc3 then you have yum, try removing the mysql package and then use yum:

yum install mysql

I'm running fc3 and used yum rather than RH package manager, and everything was aok.

WD
 
Old 06-23-2005, 03:49 AM   #9
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Original Poster
Rep: Reputation: 30
Quote:
Originally posted by Warmduvet
if your running fc3 then you have yum, try removing the mysql package and then use yum:

yum install mysql

I'm running fc3 and used yum rather than RH package manager, and everything was aok.

WD
no i Using apt-get not yum ( i dont have it on machine.. )

and the package is installed!!!.....but the sql server dont start..
 
Old 06-23-2005, 06:46 AM   #10
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Original Poster
Rep: Reputation: 30
thats showed on error log...

050623 12:45:23 mysqld started
050623 12:45:23 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
050623 12:45:23 mysqld ended

what to do now?

and that....

[root@ihtiman-shells mysql-test]# mysql-test-run
-bash: mysql-test-run: command not found
[root@ihtiman-shells mysql-test]# ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
Installing Slave Databases
running ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST RESULT
-------------------------------------------------------
alias [ pass ]
alter_table [ pass ]
analyse [ pass ]
ansi [ pass ]
archive [ pass ]
auto_increment [ pass ]
backup [ pass ]
bdb-alter-table-1 [ skipped ]
bdb-alter-table-2 [ skipped ]
bdb-crash [ skipped ]
bdb-deadlock [ skipped ]
bdb [ skipped ]
bdb_cache [ skipped ]
bench_count_distinct [ pass ]
bigint [ pass ]
binary [ pass ]
blackhole [ skipped ]
bool [ pass ]
bulk_replace [ pass ]
case [ pass ]
cast [ pass ]
check [ pass ]
comments [ pass ]
compare [ pass ]
connect [ pass ]
consistent_snapshot [ pass ]
constraints [ pass ]
count_distinct [ pass ]
count_distinct2 [ pass ]
count_distinct3 [ pass ]
create [ pass ]
create_select_tmp [ pass ]
csv [ skipped ]
ctype_big5 [ pass ]
ctype_collate [ pass ]
ctype_cp1250_ch [ pass ]
ctype_cp1251 [ pass ]
ctype_cp932 [ pass ]
ctype_create [ pass ]
ctype_latin1 [ pass ]
ctype_latin1_de [ pass ]
ctype_latin2 [ pass ]
ctype_many [ pass ]
ctype_mb [ pass ]
ctype_recoding [ pass ]
ctype_sjis [ pass ]
ctype_tis620 [ pass ]
ctype_uca [ pass ]
ctype_ucs [ pass ]
ctype_ucs_binlog [ pass ]
ctype_ujis [ pass ]
ctype_utf8 [ pass ]
date_formats [ pass ]
delayed [ pass ]
delete [ pass ]
derived [ pass ]
dirty_close [ pass ]
distinct [ pass ]
drop [ pass ]
drop_temp_table [ pass ]
empty_table [ pass ]
endspace [ pass ]
errors [ pass ]
exampledb [ skipped ]
explain [ pass ]
flush [ pass ]
flush_block_commit [ pass ]
flush_table [ pass ]
foreign_key [ pass ]
fulltext [ pass ]
fulltext2 [ pass ]
fulltext_cache [ pass ]
fulltext_distinct [ pass ]
fulltext_left_join [ pass ]
fulltext_multi [ pass ]
fulltext_order_by [ pass ]
fulltext_update [ pass ]
fulltext_var [ pass ]
func_compress [ fail ]

Errors are (from /root/mysql-standard-4.1.12-pc-linux-gnu-i686/mysql-test/var/log/mysqltest-time) :
/root/mysql-standard-4.1.12-pc-linux-gnu-i686/bin/mysqltest: At line 46: query 'select compress(repeat('aaaaaaaaaa', IF('', 10, 10000000))) is null' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)

Aborting: func_compress failed in default mode. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

master not cooperating with mysqladmin, will try manual kill
./mysql-test-run: line 1422: kill: (10641) - No such process
master refused to die. Sending SIGKILL
./mysql-test-run: line 1426: kill: (10641) - No such process
Master shutdown finished
Slave shutdown finished
[root@ihtiman-shells mysql-test]#

Last edited by skate; 06-23-2005 at 07:06 AM.
 
  


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
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
mysql start problem jelgavchik Linux - Software 15 03-30-2005 08:20 AM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM
mysql start problem TiCkO Linux - Software 3 02-17-2004 11:20 PM
mysql - problem with start and password CharlesButters Linux - General 0 11-09-2001 03:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:38 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