MySQL Study之--Mysql启动失败“mysql.host”

POOPE

MySQL Study之--Mysql启动失败“mysql.host”

　　
系统环境：
操作系统：RedHat EL55
DB Soft：  Mysql 5.6.4-m7
　　

　　通过源码包安装mysql后，在启动mysqld时出现错误：
　　[root@rh55 mysql]# bin/mysqld_safe &
[1] 15846
[root@rh55 mysql]# 150610 17:04:36 mysqld_safe Logging to '/usr/local/mysql/data/mysql/rh55.err'.
150610 17:04:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/mysql
150610 17:04:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql/rh55.pid ended

[1]+  Done                    bin/mysqld_safe
　　

　　查看mysql日志：
　　
[root@rh55 mysql]# more /usr/local/mysql/data/mysql/rh55.err
　　查看mysql配置文件:
[root@rh55 ~]# cat /etc/my.cnf

[mysqld]  
port      = 3306  
socket      = /tmp/mysql.sock  
skip-external-locking  
key_buffer_size = 16M  
max_allowed_packet = 1M  
table_open_cache = 64  
sort_buffer_size = 512K  
net_buffer_length = 8K  
read_buffer_size = 256K  
read_rnd_buffer_size = 512K  
myisam_sort_buffer_size = 8M  
datadir=/usr/local/mysql/data/mysql

　　解决方案：
[root@rh55 mysql]# scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
　　
启动mysql server：

[root@rh55 mysql]# bin/mysqld_safe &
[1] 16199
[root@rh55 mysql]# 150610 17:08:22 mysqld_safe Logging to '/usr/local/mysql/data/mysql/rh55.err'.
150610 17:08:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/mysql

验证启动成功：
[root@rh55 mysql]# netstat -an |grep 3306
tcp        0      0 :::3306                     :::*                        LISTEN