今天到 http://dev.mysql.com/downloads/mysql/5.1.html#win32 下載 MySQL 5.1.34來安裝,
可 參攷1. 步驟如下:
(安裝目錄: d:\mysql, 修改密碼: 123456)
d:\mysql\bin>mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';
mysql> FLUSH PRIVILEGES;
d:\mysql\bin>mysql -u root -p
現在在Windows Server 2003 或 2008的環境卻會出錯,
1.MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost', http://www.linuxidc.com/Linux/2008-08/15067.htm
MySQL is a relational database management system (RDBMS) which has more than 6 million installations. The program runs as a server providing multi-user access to a number of databases.
The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase. On April 20th, 2009 Oracle Corp., which develops and sells the proprietary Oracle database, announced a deal to acquire Sun Microsystems.