用mysqld --no-defaults --verbose --help
查看mysql的相关参数时:
$ mysqld --no-defaults --verbose --help
-bash: mysqld: command not found如果修改成 :
$ mysql --no-defaults --verbose --help
mysql Ver 14.14 Distrib 5.1.51, for pc-linux-gnu (i686) using EditLine wrapper
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
.....
则能正常运行 在mysql中运行 :show variables 也能够正常显示命令的相关内容 请教各位高手 这是为什么
是哪里配置的问题 还是版本的问题?我的mysql的版本是5.1.51,的源码包安装
启动MYSQL服务
· mysql交互式输入SQL语句或从文件以批处理模式执行它们的命令行工具。参见8.3节,“mysql:MySQL命令行工具”。
参考手册上面有详细的说明。
[nicenight@CSDN ~]# echo $PATH
**********:/usr/local/mysql/bin/:*********
[nicenight@CSDN ~]# ls /usr/local/mysql/bin/
comp_err my_print_defaults mysql_convert_table_format mysql_fix_privilege_tables mysql_setpermission replace
isamchk mysql mysqld_multi mysqlhotcopy mysqlshow resolveip
isamlog mysqlaccess mysqld_safe mysqlimport mysql_tableinfo resolve_stack_dump
msql2mysql mysqladmin mysqldump mysql_install mysqltest
myisamchk mysqlbinlog mysqldumpslow mysql_install_db mysql_waitpid
myisam_ftdump mysqlbug mysql_explain_log mysqlmanagerc mysql_zap
myisamlog mysqlcheck mysql_find_rows mysqlmanager-pwgen pack_isam
myisampack mysql_config mysql_fix_extensions mysql_secure_installation perror
[nicenight@CSDN ~]# ls /usr/local/mysql/libexec/
mysqld
[nicenight@CSDN ~]# echo $PATH
**********:/usr/local/mysql/bin/:*********
[nicenight@CSDN ~]# ls /usr/local/mysql/bin/
comp_err my_print_defaults mysql_convert_table_format mysql_fix_privilege_tables mysql_setpermission replace
isamchk mysql mysqld_multi mysqlhotcopy mysqlshow resolveip
isamlog mysqlaccess mysqld_safe mysqlimport mysql_tableinfo resolve_stack_dump
msql2mysql mysqladmin mysqldump mysql_install mysqltest
myisamchk mysqlbinlog mysqldumpslow mysql_install_db mysql_waitpid
myisam_ftdump mysqlbug mysql_explain_log mysqlmanagerc mysql_zap
myisamlog mysqlcheck mysql_find_rows mysqlmanager-pwgen pack_isam
myisampack mysql_config mysql_fix_extensions mysql_secure_installation perror
[nicenight@CSDN ~]# ls /usr/local/mysql/libexec/
mysqld
有没有链接共享下 不知道说的是那个参考手册 或者将参考手册发到我邮箱里也可以的
[email protected]
感谢 ..
$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/mysql/bin:/usr/local/j2sdk/bin:/usr/local/jboss/bin:/usr/local/subversion/bin$ ls /usr/local/mysql/libexec/
mysqld mysqlmanager$ ls /usr/local/mysql/bin
innochecksum my_print_defaults mysqlcheck mysqldump mysqlimport mysqltest replace
msql2mysql mysql mysql_client_test mysqldumpslow mysql_install_db mysql_tzinfo_to_sql resolveip
myisamchk mysqlaccess mysql_config mysql_find_rows mysql_secure_installation mysql_upgrade resolve_stack_dump
myisam_ftdump mysqladmin mysql_convert_table_format mysql_fix_extensions mysql_setpermission mysql_waitpid
myisamlog mysqlbinlog mysqld_multi mysql_fix_privilege_tables mysqlshow mysql_zap
myisampack mysqlbug mysqld_safe mysqlhotcopy mysqlslap perror libexec]$ ls -la
total 8384
drwxr-xr-x 2 mysql mysql 4096 May 30 18:52 .
drwxr-xr-x 17 mysql mysql 4096 Jun 8 16:15 ..
-rwxr-xr-x 1 mysql mysql 7572385 May 30 18:52 mysqld
-rwxr-xr-x 1 mysql mysql 984293 May 30 18:52 mysqlmanager[**@** libexec]$ mysqld --no-defaults --verbose --help
-bash: mysqld: command not foundPATH 变量里的路径没有 mysqld 的目录 mysql 和mysqld的确是不在一个目录下
但是
我即使在这个mysqld 文件的目录下 执行 这条查看相关语句 也是不行的啊
这句命令 mysqld --no-defaults --verbose --help 是官方文档上的呀
怎么不行啊
我即使在
/usr/local/mysql/libexec/mysqld -no-defaults --verbose --help
这个是可以
不过 这是怎么回事呢 是因为没有写全路径 找不到是那个文件夹下的mysqld文件吗可以设置一下吗非常感谢
sudo mysqld_safe --user=mysql &
不是mysqld 呀
明白了 谢谢