mysqld: Too many arguments (first extra is 'start').

小灰灰 2022-05-24 14:17 138阅读 0赞

### Question ###

Mac上的Mysql启动一个是在Perference上面启动，一个是使用mysql脚本启动。可惜我的mysql脚本被我误删了，于是使用mysqld脚本启动。

出现如下错误

sh-3.2# mysqld start
    2018-05-28T06:12:54.175083Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-05-28T06:12:54.175254Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
    2018-05-28T06:12:54.175295Z 0 [Note] mysqld (mysqld 5.7.13) starting as process 13053 ...
    2018-05-28T06:12:54.177268Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.7.13-osx10.11-x86_64/data/ is case insensitive
    2018-05-28T06:12:54.177300Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
    
    2018-05-28T06:12:54.177328Z 0 [ERROR] Aborting
    
    2018-05-28T06:12:54.177339Z 0 [Note] Binlog end
    2018-05-28T06:12:54.177397Z 0 [Note] mysqld: Shutdown complete

--------------------

### solution ###

查找资料，看过`mysqld start`、`mysqld_safe safe &`和`mysqld --user=mysql`。最后使用`mysqld --user=mysql`启动成功。

另: `mysql`的位置在`/usr/local/mysql/bin`的目录下.

--------------------

### Reference ###

\[1\] [解决mysqld: Too many arguments (first extra is ‘start’)][mysqld_ Too many arguments _first extra is _start]  
\[2\]. [ECS Linux Mysql启动提示“Too many arguments (first extra is ‘start’)”错误的分析解决][ECS Linux Mysql_Too many arguments _first extra is _start]  
\[3\]. [Mac OS X下完全卸载MySQL][Mac OS X_MySQL]

> 1.  
> 
> sudo rm /usr/local/mysql  
> sudo rm -rf /usr/local/mysql\*  
> sudo rm -rf /Library/StartupItems/MySQLCOM  
> sudo rm -rf /Library/PreferencePanes/My\*  
> vim /etc/hostconfig  
> 2.  
> rm -rf ~/Library/PreferencePanes/My\*  
> sudo rm -rf /Library/Receipts/mysql\*  
> sudo rm -rf /Library/Receipts/MySQL\*  
> sudo rm -rf /var/db/receipts/com.mysql.\*

[mysqld_ Too many arguments _first extra is _start]: http://fangzheng1105.blog.163.com/blog/static/515359532014117112118216/
[ECS Linux Mysql_Too many arguments _first extra is _start]: http://www.023dns.com/server_ecs/2253.html
[Mac OS X_MySQL]: https://blog.csdn.net/u012721519/article/details/55002626