执行mysql出错
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)出错后调用 service mysqld status 状态为“运行中”调用service mysqld restart 居然重新初始化数据库(我自己的数据库被删除),不知道怎么回事,请高手帮助,谢谢。MySQL データベースを初期化中: Installing MySQL system tables...
OK
Filling help tables...
OKTo start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h update01 password 'new-password'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)出错后调用 service mysqld status 状态为“运行中”调用service mysqld restart 居然重新初始化数据库(我自己的数据库被删除),不知道怎么回事,请高手帮助,谢谢。MySQL データベースを初期化中: Installing MySQL system tables...
OK
Filling help tables...
OKTo start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h update01 password 'new-password'
没有找到mysql.frm, 但找到了一些其他文件
[root@localhost mysql]# pwd
/var/lib/mysql/mysql
[root@localhost mysql]# ls
columns_priv.frm help_relation.MYI slow_log.CSV
columns_priv.MYD help_topic.frm slow_log.frm
columns_priv.MYI help_topic.MYD tables_priv.frm
db.frm help_topic.MYI tables_priv.MYD
db.MYD host.frm tables_priv.MYI
db.MYI host.MYD time_zone.frm
event.frm host.MYI time_zone_leap_second.frm
event.MYD ndb_binlog_index.frm time_zone_leap_second.MYD
event.MYI ndb_binlog_index.MYD time_zone_leap_second.MYI
func.frm ndb_binlog_index.MYI time_zone.MYD
func.MYD plugin.frm time_zone.MYI
func.MYI plugin.MYD time_zone_name.frm
general_log.CSM plugin.MYI time_zone_name.MYD
general_log.CSV proc.frm time_zone_name.MYI
general_log.frm proc.MYD time_zone_transition.frm
help_category.frm proc.MYI time_zone_transition.MYD
help_category.MYD procs_priv.frm time_zone_transition.MYI
help_category.MYI procs_priv.MYD time_zone_transition_type.frm
help_keyword.frm procs_priv.MYI time_zone_transition_type.MYD
help_keyword.MYD servers.frm time_zone_transition_type.MYI
help_keyword.MYI servers.MYD user.frm
help_relation.frm servers.MYI user.MYD
help_relation.MYD slow_log.CSM user.MYI
[root@localhost mysql]# mysql -V
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
从表象上看service mysqld restart 在某条件下,调用了mysql_install_db脚本,那这个条件是什么?是丢失了那些文件?