Timeout error occurred trying to start MySQL Daemon.

saman_artorious · Post by **saman_artorious** » 2008/10/21 12:18:58

Hi
I am new to linux and try to set up LAMP (linux apache mysql...).
I have already installed Apache server on my system and started it with this command: etc/init.d/httpd start
i have intalled the latest version of mysql as well(mysqlserver mysql ...)but when i try to start MySQL for the first time
with the following command
etc/init.d/mysqld start
I receive the following error
Timeout error occurred trying to start MySQL Daemon.

uname -a
Linux localhost.localdomain 2.6.18-8.el5 #1 SMP Thu Mar 15 19:57:35 EDT 2007 i686 i686 i386 GNU/Linux

could you please help me!
regards

gerald_clark · Post by **gerald_clark** » 2008/10/21 13:19:03

Where did you get them , and how did you install them?
Stick with the packages that come with CentOS, or use one of the recommended
repositories. You are much more likely to get help if the readers are familiar
with the packages you installed.

http://www.centos.org/modules/newbb/viewforum.php?forum=47

saman_artorious · Post by **saman_artorious** » 2008/10/21 14:35:20

I have already installed the following packages using yum
rpm -qa | grep 'mysql*'
mysql-server-5.0.45-7.el5
perl-DBD-mysql-4.008-1.el5.rf
mysql-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
mysql-devel-5.0.45-7.el5

i already have mysqld in etc/init.d
but i couldn't find mysql there,
i'm i have mysql installed on my system as shown above

should you have more queries please contact me

gerald_clark · Post by **gerald_clark** » 2008/10/21 15:05:44

What is in the error log?
/var/log/mysqld.log

saman_artorious · Post by **saman_artorious** » 2008/10/21 17:17:07

InnoDB: Apply batch completed
081019 13:21:25 InnoDB: Started; log sequence number 0 43655
081019 13:21:25 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 mysqld ended

the same error is produced recursively
(081019 13:21:24 mysqld started
081019 13:21:24 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...
081019 13:21:24 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
081019 13:21:24 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
081019 13:21:25 InnoDB: Started; log sequence number 0 43655
081019 13:21:25 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
081019 13:21:25 mysqld ended)

(thanks for helping)

gerald_clark · Post by **gerald_clark** » 2008/10/21 17:41:45

Error 13 means that mysql does not own or have privileges for its
files and directories.
chown -R mysql.mysql /var/lib/mysql

saman_artorious · Post by **saman_artorious** » 2008/10/21 18:13:00

etc/init.d/mysqld start
Starting MySQL: [ OK ]

Bingo
I would appreciate

saman_artorious · Post by **saman_artorious** » 2008/10/24 11:19:58

Dear Sir
if you remember, last time i was told about error number 13 and this command fixed my problem.but, later i faced another problem in which i am going to tell you step by step:
1.By default the root password is empty for the mysql database. It is a good idea to change the mysql root password to a new one from a security point of view. So,
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('newpassword') WHERE user='root';
mysql> FLUSH PRIVILEGES; (AS i remember there were two root users in mysql db!)

2.(later) mysql -u root -p
when i enter my password i receive
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
AND without entering the password i would not be able to see the MYSQL database and
use it!

3. i uninstalled mysql and installed it again with yum, I solved error number 13 with the command
i was told
4.when i want to set root password with
mysqladmin -u root password 'vincent'
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'
i receive the same error.
my pass is wrong somehow, as i understood, and i can't see the mysql db because of my
limited priviliges.

*******************************************************
******************************************************
mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)

HERE IS WHAT IS WRITTEN INSIDE user.MYD (my pass:vincent is correct)
^E^@4^@#^@^@^@^@^@^@^@??^C localhost^Droot^Gvincent^B^B^B^B^B^B^B^B^B^B^E^@@^@/^@^@^@^@^@^@^@ä?^C^Ulocalhost.localdomain^Droot^Gvincent^B^B^B^B^B^B^B^B^B^B^A^@5?^C^Ulocalhost.localdomain^@^@^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^@)?^C localhost^@^@^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^A^G^@^Q^B^B^B^B^B^B^B^B^B^B^B^B^B^B^B^B^A^G^@^Q^B^B^B^B^B^B^B^B^B^B^B^B^B^B^B^B^
*****************************************************
*****************************************************

do you have any idea?
(thanks for you help)

gerald_clark · Post by **gerald_clark** » 2008/10/24 13:09:50

If you un-installed and then installed again, you probably don't have a passwd.
Read the MySQL manual. There is a section on starting with passwords disabled so you can reset
root's password.
The manual is also online at mysql.com.

gsk3b · Post by **gsk3b** » 2008/11/01 06:17:41

well, I got the same error:

Timeout error occurred trying to start MySQL Daemon.

The content of /var/log/mysqld.log:

[quote]081101 11:53:55 mysqld started
081101 11:53:56 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys$
but it should contain at least 476 error messages.
Check that the above file is the right version for this program!
081101 11:53:56 [ERROR] Aborting

081101 11:53:56 mysqld ended

081101 11:56:33 mysqld started
081101 11:56:33 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys$
but it should contain at least 476 error messages.
Check that the above file is the right version for this program!
081101 11:56:33 [ERROR] Aborting

081101 11:56:33 mysqld ended[/quote]

However, I don't know what causes the problem though. anyone could help me? thanks

I'm on Centos 5.2

CentOS