C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p -e "SELECT * FROM TEST limit 5;select * from test where id=1000" mytest Enter password: ****** +------+------+---------------------+---------------------+ | ID | MC | DT | RQ | +------+------+---------------------+---------------------+ | 1000 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 999 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 998 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 997 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 996 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | +------+------+---------------------+---------------------+ +------+------+---------------------+---------------------+ | ID | MC | DT | RQ | +------+------+---------------------+---------------------+ | 1000 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 1000 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | | 1000 | test | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | +------+------+---------------------+---------------------+
mysqladmin是用于管理功能的客户程序
mysqlcheck执行表维护操作
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqlcheck -uroot -p mytest Enter password: ****** mytest.aaa OK mytest.customer OK mytest.mytable OK mytest.sys_tests OK mytest.test OK mytest.test1 OK mytest.test_isam OK
C:\Program Files\MySQL\MySQL Server 5.0\bin>set user=TEST
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -p mytest Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 5.0.27-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select user(); +----------------+ | user() | +----------------+ | TEST@localhost | +----------------+ 1 row in set (0.06 sec)
d、使用选项设置程序变量
shell> mysql --max_allowed_packet= 2097152 shell> mysql --max_allowed_packet=2M
WINDOWS下执行二进制安装后WINDOWS服务中默认的调用的是mysqld-nt服务器,我们可以在WINDOWS的MySql服务的属性中看到: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file ="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL
我们也可以不用WINDOWS的默认MYSQL服务器,而启用mysqld服务器来 启动MYSQL:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld --console 070608 14:12:04 [Warning] Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 070608 14:12:05 InnoDB: Started; log sequence number 0 956199 070608 14:12:05 [Note] mysqld: ready for connections. Version: '5.0.27-community' socket: '' port: 3306 MySQL Community Edition (GP L)
如果省略--console选项,服务器向数据目录(默认为C:\Program Files\MySQL \MySQL Server 5.1\data)中的错误日志写入诊断输出。错误日志文件的扩展名为.err。
C:\Program Files\MySQL\MySQL Server 5.0\bin> mysqld --verbose –help
在MYSQL数据库中查看各个变量设置:
mysql> SHOW VARIABLES; mysql> SHOW VARIABLES LIKE 'key_buffer_size'; +-----------------+----------+ | Variable_name | Value | +-----------------+----------+ | key_buffer_size | 32505856 | +-----------------+----------+ 1 row in set (0.06 sec)
mysql> show variables like 'sort_buffer%'; +------------------+----------+ | Variable_name | Value | +------------------+----------+ | sort_buffer_size | 10485760 | +------------------+----------+ 1 row in set (0.09 sec)
mysql> show variables like 'sort_buffer%'; +------------------+---------+ | Variable_name | Value | +------------------+---------+ | sort_buffer_size | 5242880 | +------------------+---------+ 1 row in set (0.00 sec)