[CentOS] OFF Topic: mysql installation problem

[Ed Morrison]

mouss wrote:
>> But there isn't a my.cnf file in /etc/  
>
> if you want one, you need to create it. the package installs example 
> file that you can use.

In all my other mysql installs there has always been an /etc/my.cnf 
after the installation but you are correct this can be created easily 
enough but I think this represents a bigger problem.
>
>> Nor are there any files in:
>> [root at ftp ~]# ls /var/lib/mysql/
>> mysql  test
>> [root at ftp ~]# ls /var/lib/mysql/mysql/
>>
>
> looks ok. at some time, you'll need to do some post-install tasks to 
> secure the server (mainly, set a password for the root user). see 
> mysql site or google...
>
The same directories on another mysql installation. These files are 
there by "default".  It appears to me this installation is not including 
all the files it should

[root at postman ~]# ls /var/lib/mysql
ibdata1  ib_logfile0  ib_logfile1  mysql  mysql.sock  test

[root at postman ~]# ls /var/lib/mysql/mysql
columns_priv.frm  help_category.frm  help_topic.frm   
time_zone.frm              time_zone_transition.frm
columns_priv.MYD  help_category.MYD  help_topic.MYD   
time_zone_leap_second.frm  time_zone_transition.MYD
columns_priv.MYI  help_category.MYI  help_topic.MYI   
time_zone_leap_second.MYD  time_zone_transition.MYI
db.frm            help_keyword.frm   host.frm         
time_zone_leap_second.MYI  time_zone_transition_type.frm
db.MYD            help_keyword.MYD   host.MYD         
time_zone.MYD              time_zone_transition_type.MYD
db.MYI            help_keyword.MYI   host.MYI         
time_zone.MYI              time_zone_transition_type.MYI
func.frm          help_relation.frm  tables_priv.frm  
time_zone_name.frm         user.frm
func.MYD          help_relation.MYD  tables_priv.MYD  
time_zone_name.MYD         user.MYD
func.MYI          help_relation.MYI  tables_priv.MYI  
time_zone_name.MYI         user.MYI
>> An rpm query shows everything should be installed:
>> [root at ftp ~]# rpm -qa mysql
>> mysql-5.0.54-1.el4.centos
>> [root at ftp ~]# rpm -qa mysql*
>> mysqlclient14-4.1.22-1.el4s1.1
>> mysqlclient10-devel-3.23.58-9.2.c4
>> mysql-5.0.54-1.el4.centos
>> mysqlclient10-3.23.58-4.RHEL4.1
>> mysql-server-5.0.54-1.el4.centos
>> mysqlclient10-3.23.58-9.2.c4
>> mysql-libs-5.0.54-1.el4.centos
>>
>>
>> Trying to start mysql results in:
>> [root at ftp ~]# service mysqld start
>> Timeout error occurred trying to start MySQL Daemon.
>> Starting MySQL:  [FAILED]
>>
>> Thoughts? 
>
> is selinux enabled on your system? check /var/log/messages.
No selinux is not enabled:

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#       enforcing - SELinux security policy is enforced.
#       permissive - SELinux prints warnings instead of enforcing.
#       disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
#       targeted - Only targeted network daemons are protected.
#       strict - Full SELinux protection.
SELINUXTYPE=targeted