Mysql数据库学习心得(2)

80酷酷网    80kuku.com

  

 

(二)在Windows2000下的安装

  1。安装时选默认目录:c:mysql

  2。把c:mysqlmy-example.cnf copy为c:my.cnf,并把c:mysqlibgwinb19.dll copy到winntsystem32。

  3。启动mysql的方法是:

    c:mysqlinmysqld-shareware --install

    net start mysql

  这么简单,就可以启动了。

  4。更改超级用户(root)的密码:

    C:mysqlinmysql mysql

    mysql> UPDATE user SET password=PASSWORD('your password')swheresuser='root';

    mysql> QUIT

    C:mysqlinmysqladmin reload

    使用命令C:mysqlinmysqlshow去看看检测一下。在这里应该显示:

    +-----------+

    | Databases |

    +-----------+

    | mysql |

    | test |

    +-----------+

    看到这些信息这一步就证明没问题了

    再来:

    C:mysqlinmysqlshow --user=root --password=your password mysql

    在这里应该显示:

    Database: mysql

    +--------------+

    | Tables |

    +--------------+

    | columns_priv |

    | db |

    | host |

    | tables_priv |

    | user |

    +--------------+

    一切搞定!

  5。C:mysqlinmysqladmin version status proc

  应该可以看到这些版本信息的:

   mysqladmin Ver 8.0 Distrib 3.22.32, for Win95/Win98 on i586

   TCX Datakonsult AB, by Monty

   Server version 3.22.32-shareware-debug

   Protocol version 10

   Connection localhost via TCP/IP

   TCP port 3306

   Uptime: 1 hour 29 min 30 sec

   Threads: 1 Questions: 72 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 0 Memory in use: 16423K Max memory      used: 16490K

   Uptime: 5370 Threads: 1 Questions: 72 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 0 Memory in use: 16423K     Max memory used: 16490K

    +----+------+-----------+----+---------+------+-------+------------------+

    | Id | User | Host | db | Command | Time | State | Info |

    +----+------+-----------+----+---------+------+-------+------------------+

    | 35 | ODBC | localhost | | Query | 0 | | show processlist |

    +----+------+-----------+----+---------+------+-------+------------------+

  接着,用show databases命令可以将安装的数据库列出来:

    mysql> show databases;

  你就可以看到:

    +----------+

    | Database |

    +----------+

    | mysql |

    | test |

    +----------+

    2 rows in set (0.00 sec)

  如果一切正常的话,那说明MySQL可以完全工作了!如果要退出程序,输入:exit

    mysql> exit;

    Bye

 



分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: