Timeout error occurred trying to start MySQL Daemon.

Installing, Configuring, Troubleshooting server daemons such as Web and Mail

Timeout error occurred trying to start MySQL Daemon.

Postby 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
saman_artorious
 
Posts: 73
Joined: 2008/09/19 19:03:37

Timeout error occurred trying to start MySQL Daemon.

Postby 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/vie ... p?forum=47
gerald_clark
 
Posts: 9480
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: Timeout error occurred trying to start MySQL Daemon.

Postby 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
saman_artorious
 
Posts: 73
Joined: 2008/09/19 19:03:37

Re: Timeout error occurred trying to start MySQL Daemon.

Postby gerald_clark » 2008/10/21 15:05:44

What is in the error log?
/var/log/mysqld.log
gerald_clark
 
Posts: 9480
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: Timeout error occurred trying to start MySQL Daemon.

Postby 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)
saman_artorious
 
Posts: 73
Joined: 2008/09/19 19:03:37

Re: Timeout error occurred trying to start MySQL Daemon.

Postby 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
gerald_clark
 
Posts: 9480
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: Timeout error occurred trying to start MySQL Daemon.

Postby saman_artorious » 2008/10/21 18:13:00

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


Bingo
I would appreciate
saman_artorious
 
Posts: 73
Joined: 2008/09/19 19:03:37

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Postby 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)
saman_artorious
 
Posts: 73
Joined: 2008/09/19 19:03:37

Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Postby 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.
gerald_clark
 
Posts: 9480
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Postby 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:

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


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

I'm on Centos 5.2
gsk3b
 
Posts: 11
Joined: 2006/10/13 22:41:16

Next

Return to CentOS 5 - Server Support

Who is online

Users browsing this forum: Bing [Bot] and 0 guests