rainman
阿熊
元老
发贴: 5644
积分: 454
|
于 2003-03-11 04:27
安装选默认目录就可以了 c:\mysql 把 c:\mysql\my-example.cnf copy 为 c:\my.cnf 要修改的自己去看看吧,很简单的 把 c:\mysql\lib\cygwinb19.dll copy 到 winnt\system32 启动 mysql c:\mysql\bin\mysqld-shareware --install net start mysql 启动啦 更改 root 的 password
C:\mysql\bin\mysql mysql mysql> UPDATE user SET password=PASSWORD('your password') WHERE user='root'; mysql> QUIT C:\mysql\bin\mysqladmin reload
去看看行了没有? C:\mysql\bin\mysqlshow 在这里应该显示: +-----------+ | Databases | +-----------+ | mysql | | test | +-----------+ 看到这些信息这一步就OK了
再来: C:\mysql\bin\mysqlshow --user=root --password=your password mysql 在这里应该显示: Database: mysql +--------------+ | Tables | +--------------+ | columns_priv | | db | | host | | tables_priv | | user | +--------------+ 看见就OK了。
C:\mysql\bin\mysqladmin 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 | +----+------+-----------+----+---------+------+-------+------------------+
|