[CentOS] OFF Topic: mysql installation problem
mouss
mouss at netoyen.net
Thu Feb 14 21:39:31 UTC 2008
Ed Morrison wrote:
> 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
# yum install mysql mysql-server php-mysql
....
# ls -a /var/lib/mysql
. ..
# rpm -qf /etc/my.cnf
mysql-libs-5.0.54-1.el4.centos
# service mysqld start
Initializing MySQL database: [ OK ]
Starting MySQL: [ OK ]
[root at sushi lib]# ls mysql
ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test
what I don't see in your setup is mysql-libs.
>
> [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
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
More information about the CentOS
mailing list