(二)在Windows2000下的安装MySQL(Linux)MySQL 9.6.0是面向Linux平台的2026年创新版本,核心架构迎来重大革新。其将外键约束与级联操作从InnoDB引擎层上移至SQL层,确保所有数据变更均被完整记录至Binlog,彻底解决了CDC(变更数据捕获)与主从复制中的数据不一致难题。此外,该版本引入container_aware启动选项以原生适配容器环境,并对审计日志进行了组件化重构,为追求极致数据一致性与云原生体验的开发者提供了全新选择。下载1。安装时选默认目录:c:mysql 2。把c:mysqlmy-example.cnfcopy为c:my.cnf,并把c:mysqlibgwinb19.dll copy到winntsystem32。
3。启动mysql的方法是:c:mysqlinmysqld-shareware --install netstartmysql这么简单,就可以启动了。
4。更改超级用户(root)的密码:C:mysqlinmysqlmysql mysql> UPDATE user SET password=PASSWORD('your password')swheresuser='root';mysql> QUIT C:mysqlinmysqladminreload使用命令C:mysqlinmysqlshow去看看检测一下。在这里应该显示:+-----------+| Databases |+-----------+|mysql||test|+-----------+看到这些信息这一步就证明没问题了再来:C:mysqlinmysqlshow--user=root --password=your passwordmysql
在这里应该显示:
Database:mysql+--------------+| Tables |+--------------+|columns_priv||db||host||tables_priv||user|+--------------+一切搞定!
5。C:mysqlinmysqladminversion status proc应该可以看到这些版本信息的:mysqladminVer8.0Distrib3.22.32, for Win95/Win98 on i586 TCX xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" / DatakonsultAB, by Monty Server version 3.22.32-shareware-debug Protocol version 10 Connectionlocalhostvia 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 | | showprocesslist|+----+------+-----------+----+---------+------+-------+------------------+接着,用show databases命令可以将安装的数据库列出来:mysql> show databases;
你就可以看到:
+----------+| Database |+----------+|mysql||test|+----------+2 rows in set (0.00 sec)如果一切正常的话,那说明MySQL可以完全工作了!如果要退出程序,输入:exit mysql> exit;Bye
