请问mysqld与mysql命令区别？

[tang_123_]

我安装了mysql5.0，安装后bin目录下只有mysql.exe,网上写的bin目录下有mysqld.exe，请问它们有什么区别？

[wwwwb]

mysql - it's a commandline (administration) tool
命令行工具
mysqld - it's a server daemon. this is the database server main binary (executable)
启动MYSQL服务

[zuoxingyu]

· mysqld

SQL后台程序(即MySQL服务器)。要想使用客户端程序，该程序必须运行，因为客户端通过连接服务器来访问数据库。参见5.3节，“mysqld：MySQL服务器”。

· mysql

交互式输入SQL语句或从文件以批处理模式执行它们的命令行工具。参见8.3节，“mysql：MySQL命令行工具”。


参考手册上面有详细的说明。

[iihero_]

mysqld 是服务端程序
mysql是命令行客户端程序

[ACMAIN_CHM]

接触一个新的软件时，首先看看它的帮助文档。

[Quote]4.3.1. mysqld — The MySQL Server
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.

When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients.

The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:

shell> mysqld --verbose --help

MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics.

For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, “The MySQL Server”. For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL.

[/Quote]

[Quote]

4.5.1. mysql — The MySQL Command-Line Tool
mysql is a simple SQL shell (with GNU readline capabilities). It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options.

If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before displaying it. This is done by returning the result set using the mysql_use_result() C API function in the client/server library rather than mysql_store_result().

Using mysql is very easy. Invoke it from the prompt of your command interpreter as follows:

shell> mysql db_name

Or:

shell> mysql --user=user_name --password=your_password db_name

Then type an SQL statement, end it with “;”, \g, or \G and press Enter.

Typing Control-C causes mysql to attempt to kill the current statement. If this cannot be done, or Control-C is typed again before the statement is killed, mysql exits. Previously, Control-C caused mysql to exit in all cases.

You can execute SQL statements in a script file (batch file) like this:

shell> mysql db_name < script.sql > output.tab

4.5.1.1. mysql Options
Table 4.2. mysql Options


[/Quote]

[feixianxxx]

呵呵 mysqld是关于服务器端的程序
mysql是mysql自带的客户端程序 一般都在cmd或者终端下操作

你可以看看配置文件 里面有 [mysql] 和[mysqld] 分别下面有些配置参数

[用户昵称不能为空]

[Quote=引用 3 楼 iihero 的回复:]

mysqld 是服务端程序
mysql是命令行客户端程序
[/Quote]

谢谢哦

[tang_123_]

谢谢大家的回答。

现在，我在控制台下输入mysqld --verbose --help;显示不是内部或外部命令，怎么回事呀。

[lzl8146]

那就用mysqld的全路径试试，或者把mysqld所在的目录设置下环境变量。