Mysql数据库学习心得(2)
来源:互联网 发布:数码暴龙网络侦探v字头 编辑:程序博客网 时间:2024/05/14 19:29
(二)在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 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 |