mysqld: Too many arguments (first extra is 'start').-蒲公英云

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

小灰灰 2022-05-24 14:17 270阅读 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’)
[2]. ECS Linux Mysql启动提示“Too many arguments (first extra is ‘start’)”错误的分析解决
[3]. Mac OS X下完全卸载MySQL

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

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.*