把 c:mysqlmy-example.cnf copy 为 c:my.cnf
要修改的自己去看看吧,很简单的
把 c:mysqllibcygwinb19.dll copy 到 winntsystem32
启动 mysql
c:mysqlinmysqld-shareware --install
net start mysql
启动啦
更改 root 的 password
c:mysqlinmysql mysql
mysql> update user set password=password(''your password'') where user=''root'';
mysql> quit
c:mysqlinmysqladmin reload
去看看行了没有?
c:mysqlinmysqlshow
在这里应该显示:
+-----------+
| databases |
+-----------+
| mysql |
| test |
+-----------+
看到这些信息这一步就ok了
再来:
c:mysqlinmysqlshow --user=root --password=your password mysql
在这里应该显示:
database: mysql
+--------------+
| tables |
+--------------+
| columns_priv |
| db |
| host |
| tables_priv |
| user |
+--------------+
看见就ok了。
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 |
+----+------+-----------+----+---------+------+-------+------------------+
没有问题就ok了,有问题就来找我吧
