Jcat
          寵辱不驚,閑看庭前花開花落~~
          posts - 173,comments - 67,trackbacks - 0
          重裝完系統,mysql不需要重裝,直接當綠色版使用,還更干凈

          //啟動MYSQL
          cd $MYSQL_HOME/bin
          D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>mysqld --console??????
          110616? 1:26:26 [Note] Plugin 'FEDERATED' is disabled.
          InnoDB: The log sequence number in ibdata files does not match
          InnoDB: the log sequence number in the ib_logfiles!
          110616? 1:26:26? InnoDB: Database was not shut down normally!
          InnoDB: Starting crash recovery.
          InnoDB: Reading tablespace information from the .ibd files...
          InnoDB: Restoring possible half-written data pages from the doublewrite
          InnoDB: buffer...
          110616? 1:26:26? InnoDB: Started; log sequence number 0 44233
          110616? 1:26:27 [Note] Event Scheduler: Loaded 0 events
          110616? 1:26:27 [Note] mysqld: ready for connections.
          Version: '5.1.53-community'? socket: ''? port: 3306? MySQL Community Server (GPL
          )

          //簡單使用

          mysql> show databases;
          +--------------------+
          | Database?????????? |
          +--------------------+
          | information_schema |
          | mysql????????????? |
          | test?????????????? |
          +--------------------+
          3 rows in set (0.03 sec)

          mysql> use mysql
          Database changed

          mysql> show tables;
          +---------------------------+
          | Tables_in_mysql?????????? |
          +---------------------------+
          | columns_priv????????????? |
          | db??????????????????????? |
          | event???????????????????? |
          | func????????????????????? |
          | general_log?????????????? |
          | help_category???????????? |
          | help_keyword????????????? |
          | help_relation???????????? |
          | help_topic??????????????? |
          | host????????????????????? |
          | ndb_binlog_index????????? |


          登陸
          D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>mysql.exe -uroot
          創建數據庫
          mysql> create database testdb;




          posted on 2011-06-16 01:40 Jcat 閱讀(945) 評論(1)  編輯  收藏 所屬分類: Database

          FeedBack:
          # re: 啟動綠色版MYSQL
          2011-06-16 01:44 | sure_dandan
          霸霸!  回復  更多評論
            
          主站蜘蛛池模板: 满洲里市| 抚顺县| 灵宝市| 吴桥县| 敦煌市| 茂名市| 青龙| 阿鲁科尔沁旗| 龙川县| 行唐县| 七台河市| 哈密市| 古浪县| 宜都市| 西充县| 上饶县| 武义县| 葫芦岛市| 通化县| 通州市| 农安县| 左贡县| 个旧市| 柳河县| 曲麻莱县| 广平县| 桓台县| 靖边县| 建平县| 六盘水市| 潞城市| 栖霞市| 安龙县| 长阳| 双鸭山市| 胶州市| 东台市| 海阳市| 沛县| 塘沽区| 屯留县|