里面包含的是MySQL运行所必需的系统信息，因此我们需要将这些数据初始化，如下：
| #修改mysql目录下的所有文件的属主为mysql xpleaf@leaf:/usr/local/mysql$sudochown-Rmysql. #修改mysql目录下的所有文件的属组为mysql xpleaf@leaf:/usr/local/mysql$sudochgrp-Rmysql. #以mysql用户的身份初始化数据 xpleaf@leaf:/usr/local/mysql$sudoscripts/mysql_install_db--user=mysql #修改mysql目录下的所有文件的属主为root xpleaf@leaf:/usr/local/mysql$sudochown-Rroot. #修改mysql目录下的data目录的属主为mysql xpleaf@leaf:/usr/local/mysql$sudochown-Rmysqldata |
请务必按照上面的操作进行，至于详细的是什么意思，为什么要这样做，可以参考官方文档，有非常详细的解释：http://dev.mysql.com/doc/refman/5.6/en/data-directory-initialization.html
（4）启动MySQL
如下：
| xpleaf@leaf:/usr/local/mysql$sudobin/mysqld_safe--user=mysql& [1]8365 xpleaf@leaf:/usr/local/mysql$16030814:13:26mysqld_safeLoggingto'/usr/local/mysql-5.6.28-linux-glibc2.5-x86_64/data/leaf.err'. 16030814:13:26mysqld_safeStartingmysqlddaemonwithdatabasesfrom/usr/local/mysql-5.6.28-linux-glibc2.5-x86_64/data |
确认已经开启MySQL服务：
| xpleaf@leaf:~$sudonetstat-antup|grepmysqld tcp600:::3306:::*LISTEN8455/mysqld |
mysql服务确实已经成功启动了！
（5）测试mysql服务
为了使mysql可以更好地在你的系统上运行，建议进行一定的mysql服务测试，如下：
| xpleaf@leaf:/usr/local/mysql$sudobin/mysqladminversion bin/mysqladminVer8.42Distrib5.6.28,forlinux-glibc2.5onx86_64 Copyright(c)2000,2015,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Serverversion5.6.28 Protocolversion10 ConnectionLocalhostviaUNIXsocket UNIXsocket/tmp/mysql.sock Uptime:8min36sec Threads:1Questions:2Slowqueries:0Opens:67Flushtables:1Opentables:60Queriespersecondavg:0.003 |
成功了！然后我们再进行下面的操作热热身吧：
| #通过mysqladmin关闭mysql服务 xpleaf@leaf:/usr/local/mysql$sudobin/mysqladmin-urootshutdown #启动mysql服务 xpleaf@leaf:/usr/local/mysql$sudobin/mysqld_safe--user=mysql& #查看mysql数据库中默认存在的数据库 xpleaf@leaf:/usr/local/mysql$sudobin/mysqlshow +--------------------+ |Databases| +--------------------+ |information_schema| |mysql| |performance_schema| |test| +--------------------+ #查看mysql数据库（注意此mysql数据库是一个实体，与上面的统称不同）中的数据表 xpleaf@leaf:/usr/local/mysql$sudobin/mysqlshowmysql Database:mysql +---------------------------+ |Tables| +---------------------------+ |columns_priv| |db| |event| |func| |general_log| |help_category| |help_keyword| |help_relation| |help_topic| |innodb_index_stats| |innodb_table_stats| |ndb_binlog_index| |plugin| |proc| |procs_priv| |proxies_priv| |servers| |slave_master_info| |slave_relay_log_info| |slave_worker_info| |slow_log| |tables_priv| |time_zone| |time_zone_leap_second| |time_zone_name| |time_zone_transition| |time_zone_transition_type| |user| +---------------------------+ #查看mysql数据库中的所有user表 xpleaf@leaf:/usr/local/mysql$sudobin/mysql-e"SELECTUser,Host,pluginFROMmysql.user"mysql +------+-----------+-----------------------+ |User|Host|plugin| +------+-----------+-----------------------+ |root|localhost|mysql_native_password| |root|leaf|mysql_native_password| |root|127.0.0.1|mysql_native_password| |root|::1|mysql_native_password| ||localhost|mysql_native_password| ||leaf|mysql_native_password| +------+-----------+-----------------------+ |
