为了账号安全,请及时绑定邮箱和手机立即绑定

Linux mysql安装问题

Linux mysql安装问题

qq_爱做梦的年纪_0 2017-10-17 08:01:22
mysql5.7.19版本Centos6.6http://www.jasonchen.cn/?p=6我通过上面的网站来安装Mysql,基本一样,但是在初始化Mysql后出现了问题[root@localhost bin]# ./mysqld –defaults-file=/etc/my.cnf –datadir=/usr/local/mysql/data –initialize –user=mysql2017-10-17T07:42:43.108645Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2017-10-17T07:42:43.109367Z 0 [Note] ./mysqld (mysqld 5.7.19) starting as process 1886 ...2017-10-17T07:42:43.227807Z 0 [Note] InnoDB: PUNCH HOLE support available2017-10-17T07:42:43.227926Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2017-10-17T07:42:43.227932Z 0 [Note] InnoDB: Uses event mutexes2017-10-17T07:42:43.227947Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier2017-10-17T07:42:43.227955Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32017-10-17T07:42:43.229887Z 0 [Note] InnoDB: Number of pools: 12017-10-17T07:42:43.230315Z 0 [Note] InnoDB: Not using CPU crc32 instructions2017-10-17T07:42:43.258334Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2017-10-17T07:42:43.336461Z 0 [Note] InnoDB: Completed initialization of buffer pool2017-10-17T07:42:43.360833Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2017-10-17T07:42:43.590526Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2017-10-17T07:42:43.734546Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables2017-10-17T07:42:43.734662Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...2017-10-17T07:42:43.985077Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.2017-10-17T07:42:43.986636Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.2017-10-17T07:42:43.986655Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.2017-10-17T07:42:44.008542Z 0 [Note] InnoDB: Waiting for purge to start2017-10-17T07:42:44.059383Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 12103032017-10-17T07:42:44.060037Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool2017-10-17T07:42:44.065028Z 0 [Note] Plugin 'FEDERATED' is disabled.mysqld: Table 'mysql.plugin' doesn't exist2017-10-17T07:42:44.067196Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.2017-10-17T07:42:44.067945Z 0 [ERROR] Too many arguments (first extra is '–defaults-file=/etc/my.cnf').2017-10-17T07:42:44.067972Z 0 [Note] Use --verbose --help to get a list of available options!2017-10-17T07:42:44.067982Z 0 [ERROR] Aborting这有下划线的就是问题,我在网上找了很久,都没成功。以下是我的my.cnf配置文件[mysqld]port=3306basedir=/usr/local/mysqldatadir=/usr/local/mysql/datasocket=/tmp/mysql.sockuser=mysqlexplicit_defaults_for_timestamp=true# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid本人小白,刚接触Linux,有没有大神告诉我,该怎么去改?
查看完整描述

3 回答

?
qq_爱做梦的年纪_0

TA贡献8条经验 获得超1个赞

yum下来的版本才5.1.73.好低啊,

查看完整回答
反对 回复 2017-10-17
?
北溟有鹏

TA贡献1条经验 获得超0个赞

小白还是用rpm包安全方法吧

查看完整回答
反对 回复 2017-10-17
?
是王小二呀

TA贡献88条经验 获得超19个赞

删掉重新装

yum -y install mysql-server
service mysqld start
/usr/bin/mysql_secure_installation


查看完整回答
反对 回复 2017-10-17
  • 3 回答
  • 0 关注
  • 2711 浏览
慕课专栏
更多

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信