本文主要是介绍mysqld: Too many arguments (first extra is 'start').,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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] Aborting2018-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
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').的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!