Comments - MariaDB 5.2.13 Release Notes

11 years, 3 months ago openiduser7

Just tried installing 5.2.13 118 build on fresh CentOS 6.3 and seems mysql system tables incorrectly set user/group permissions to root instead of mysql preventing mysql server from starting. Changing to mysql user/group allowed mysql to start up.

ls -lah /var/lib/mysql/mysql/
total 968K
drwx--x--x 2 mysql mysql 4.0K Dec  1 11:42 .
drwxr-xr-x 4 mysql mysql 4.0K Dec  1 11:43 ..
-rw-rw---- 1 root  root  8.7K Dec  1 11:42 columns_priv.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 columns_priv.MYD
-rw-rw---- 1 root  root  4.0K Dec  1 11:42 columns_priv.MYI
-rw-rw---- 1 root  root  9.4K Dec  1 11:42 db.frm
-rw-rw---- 1 root  root   880 Dec  1 11:42 db.MYD
-rw-rw---- 1 root  root  5.0K Dec  1 11:42 db.MYI
-rw-rw---- 1 root  root   10K Dec  1 11:42 event.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 event.MYD
-rw-rw---- 1 root  root  2.0K Dec  1 11:42 event.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 func.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 func.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 func.MYI
-rw-rw---- 1 root  root    35 Dec  1 11:42 general_log.CSM
-rw-rw---- 1 root  root     0 Dec  1 11:42 general_log.CSV
-rw-rw---- 1 root  root  8.6K Dec  1 11:42 general_log.frm
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 help_category.frm
-rw-rw---- 1 root  root   21K Dec  1 11:42 help_category.MYD
-rw-rw---- 1 root  root  3.0K Dec  1 11:42 help_category.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 help_keyword.frm
-rw-rw---- 1 root  root   87K Dec  1 11:42 help_keyword.MYD
-rw-rw---- 1 root  root   16K Dec  1 11:42 help_keyword.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 help_relation.frm
-rw-rw---- 1 root  root  8.8K Dec  1 11:42 help_relation.MYD
-rw-rw---- 1 root  root   18K Dec  1 11:42 help_relation.MYI
-rw-rw---- 1 root  root  8.6K Dec  1 11:42 help_topic.frm
-rw-rw---- 1 root  root  412K Dec  1 11:42 help_topic.MYD
-rw-rw---- 1 root  root   20K Dec  1 11:42 help_topic.MYI
-rw-rw---- 1 root  root  9.3K Dec  1 11:42 host.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 host.MYD
-rw-rw---- 1 root  root  2.0K Dec  1 11:42 host.MYI
-rw-rw---- 1 root  root  8.6K Dec  1 11:42 ndb_binlog_index.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 ndb_binlog_index.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 ndb_binlog_index.MYI
-rw-rw---- 1 root  root  8.4K Dec  1 11:42 plugin.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 plugin.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 plugin.MYI
-rw-rw---- 1 root  root  9.8K Dec  1 11:42 proc.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 proc.MYD
-rw-rw---- 1 root  root  2.0K Dec  1 11:42 proc.MYI
-rw-rw---- 1 root  root  8.7K Dec  1 11:42 procs_priv.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 procs_priv.MYD
-rw-rw---- 1 root  root  4.0K Dec  1 11:42 procs_priv.MYI
-rw-rw---- 1 root  root  8.7K Dec  1 11:42 servers.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 servers.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 servers.MYI
-rw-rw---- 1 root  root    35 Dec  1 11:42 slow_log.CSM
-rw-rw---- 1 root  root     0 Dec  1 11:42 slow_log.CSV
-rw-rw---- 1 root  root  8.8K Dec  1 11:42 slow_log.frm
-rw-rw---- 1 root  root  8.8K Dec  1 11:42 tables_priv.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 tables_priv.MYD
-rw-rw---- 1 root  root  4.0K Dec  1 11:42 tables_priv.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 time_zone.frm
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 time_zone_leap_second.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 time_zone_leap_second.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 time_zone_leap_second.MYI
-rw-rw---- 1 root  root     0 Dec  1 11:42 time_zone.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 time_zone.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 time_zone_name.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 time_zone_name.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 time_zone_name.MYI
-rw-rw---- 1 root  root  8.5K Dec  1 11:42 time_zone_transition.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 time_zone_transition.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 time_zone_transition.MYI
-rw-rw---- 1 root  root  8.6K Dec  1 11:42 time_zone_transition_type.frm
-rw-rw---- 1 root  root     0 Dec  1 11:42 time_zone_transition_type.MYD
-rw-rw---- 1 root  root  1.0K Dec  1 11:42 time_zone_transition_type.MYI
-rw-rw---- 1 root  root   11K Dec  1 11:42 user.frm
-rw-rw---- 1 root  root   276 Dec  1 11:42 user.MYD
-rw-rw---- 1 root  root  2.0K Dec  1 11:42 user.MYI
 
11 years, 3 months ago Sergei Golubchik

we don't build 5.2 rpms for CentOS 6. Did you use CentOS5 builds? 32-bit or 64-bit ?

 
11 years, 3 months ago Sergei Golubchik

I've just tried to install CentOS 5 64-bit MariaDB 5.2.13-118 RPMs on CentOS 6 and all table files were owned by the mysql user, not root.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.