تەشنا تېخنىكا كۇلۇبى

ئەسسالام ئەلەيكۇم، بەك چۈشىنىشلىك بوپتۇ. ئىشقىلىپ ماڭا ھەزىم بوپ كەتتى…. :ھا ھا:

ئەسسالامۇ – ئەلەيكۇم، ئاداش! mysql مۇنداق cmd ئارقىلىق باشقۇرۇپ باقماپتىكەنمەن، راستىنلا قولايلىق ئېكەن. دېگىنىڭلا بويىچە ئويناپ باقتىم، نەتىجىسى تۆۋەندىكىدەك: :ھا ھا:

E:>cd Apachemysqlbin
E:Apachemysqlbin>mysql -u root

mysql: Unknown OS character set 'cp720'.
mysql: Switching to the default character set 'latin1'.
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 4
Server version: 5.5.32 MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bbs                |
| bbs2               |
| cdcol              |
| cms                |
| destoon            |
| job                |
| mb                 |
| my_chat            |
| mysql              |
| performance_schema |
| phpcmc             |
| phpmyadmin         |
| soz                |
| sozqaldurush       |
| test               |
| webauth            |
| wp-cn              |
| wp_ug              |
| zh_wordpress       |
+--------------------+
20 rows in set (0.00 sec)

mysql> create database teshna;
Query OK, 1 row affected (0.00 sec)

mysql> drop database teshna;
Query OK, 0 rows affected (0.08 sec)

mysql> drop database soz;
Query OK, 0 rows affected (0.00 sec)

mysql> drop database cdcol;
Query OK, 1 row affected (0.10 sec)

mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------+
| Variable_name            | Value                           |
+--------------------------+---------------------------------+
| character_set_client     | latin1                          |
| character_set_connection | latin1                          |
| character_set_database   | latin1                          |
| character_set_filesystem | binary                          |
| character_set_results    | latin1                          |
| character_set_server     | latin1                          |
| character_set_system     | utf8                            |
| character_sets_dir       | E:Apachemysqlsharecharsets |
+--------------------------+---------------------------------+
8 rows in set (0.00 sec)

mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------+
| Variable_name            | Value                           |
+--------------------------+---------------------------------+
| character_set_client     | latin1                          |
| character_set_connection | latin1                          |
| character_set_database   | utf8                            |
| character_set_filesystem | binary                          |
| character_set_results    | latin1                          |
| character_set_server     | latin1                          |
| character_set_system     | utf8                            |
| character_sets_dir       | E:Apachemysqlsharecharsets |
+--------------------------+---------------------------------+
8 rows in set (0.00 sec)

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.32, for Win32 (x86)

Connection id:          4
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.32 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 30 min 54 sec

Threads: 1  Questions: 1282  Slow queries: 0  Opens: 10558  Flush tables: 1  Ope
n tables: 0  Queries per second avg: 0.691
--------------

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.32    |
+-----------+
1 row in set (0.00 sec)
mysql>

مەن windows ئىشلەتكەنلەرگە IIS 8.0 ياكى Microsoft WebMatrix نى تەۋسىيە قىلاي، كىيىنكىسى بەك بەلەن چۈشۈرۈپ قاچىلىسىڭىز، سىز ئىزدىگەن نەرسىنىڭ ھەممىسى بار. ئىشلەش مۇھىتنى(php,Jsp,Asp.net,Mysql,Oracle,MSSql دىگەندەك) ئاپتۇماتىك قۇرۇپ بىرىدۇ. ھەم نۇرغۇن سىستىما تەمىلىگەن. لېكىن يامان يىرى، IIS Express بىلەن تەمىنلىگەن، شۇڭا چۈشۈرۈپ قاچىلىۋېلىپ IIS ئالماشتۇرۇپ ئىشلەتسىڭىز بۇلىدۇ.

بىلوگىڭىزمۇ خېلى قىززىپتۇ جۇمۇ، ھارمىغايسىلەر دوستلار.