ä¸ãä¸è½½MySQLå®è£
æ件
å®å
¨å®è£
MySQLéè¦ä¸é¢6个æ件ï¼
MySQL-server-community-5.1.26-0.rhel4.i386.rpm
MySQL-client-community-5.1.26-0.rhel4.i386.rpm
MySQL-shared-community-5.1.26-0.rhel4.i386.rpm
MySQL-devel-community-5.1.26-0.rhel4.i386.rpm
MySQL-test-community-5.1.26-0.rhel4.i386.rpm
MySQL-community-debuginfo-5.1.26-0.rhel4.i386.rpm
ä¸è½½å°å为ï¼
http://dev.mysql.com/downloads/mysql/5.1.html#linux-rhel4- x86-32bit-rpmsï¼æå¼æ¤ç½é¡µ(å 为没ææ¾å°Fedoraçæ¬çï¼å°±ç¨Redhat Enterprise 4æ¥ä»£æ¿äºï¼æ²¡æé®é¢)ï¼ä¸è½½ææçéè¦çä¸è¿°rpmæ件ã
äºãMySQLå®è£
rpmæ件æ¯Red Hatå
¬å¸å¼åç软件å®è£
å
ï¼rpmå¯è®©Linuxå¨å®è£
软件å
æ¶å
é¤è®¸å¤å¤æçæç»ã该å½ä»¤å¨å®è£
æ¶å¸¸ç¨çåæ°æ¯ âivh ,å
¶ä¸i表示å°å®è£
æå®çrmp软件å
ï¼V表示å®è£
æ¶ç详ç»ä¿¡æ¯ï¼h表示å¨å®è£
æé´åºç°â#â符å·æ¥æ¾ç¤ºç®åçå®è£
è¿ç¨ãè¿ä¸ªç¬¦å·å°æç»å°å®è£
å®æåæåæ¢ã
1) MySQLå®è£
æå¡å¨ç«¯
å¨æ两个rmpæ件çç®å½ä¸è¿è¡å¦ä¸å½ä»¤ï¼ [root@test1 local]# rpm -ivh MySQL-server*.rpm(*为éé
符ï¼çæäºå¾å¤çè¾å
¥ï¼å¾æ¹ä¾¿-:)))
æ¾ç¤ºå¦ä¸ä¿¡æ¯ï¼Failed dependencies:perl(DBI) is needed by MySQL-server-5.1.26-0.rhel4.i386åºéäº!
å» Googleä¸ï¼åç°å¯è½æ¯è¯¥çæ¬çrpméå¢å äºå¾å¤éå ä¾èµçæ£æ¥ï¼ç¹å«æ¯å¯¹ææperl modulesçä¾èµæ£æ¥ï¼å æ¤ç¨â--nodepsâæ¥å¼ºå¶å®è£
æ¯å®å
¨çï¼ææ£æ¯è¿ä¹åçï¼rpm -ivh MySQL-server*.rpm --nodeps;ç»ææåï¼
Preparing... [100%]
1:MySQL-server [100%]
2) MySQLå®è£
客æ·ç«¯
è¿è¡å¦ä¸å½ä»¤ï¼
[root@test1 local]# rpm -ivh MySQL-client*.rpm
Preparing... [100%]
1:MySQL-client [100%]
å¦ä¸å®è£
å
¶ä»ç4个rpmæ件ï¼åºè¯¥æ²¡æä»ä¹é®é¢ã
ä¸ãMySQLç»å½
MySQLç»å½çå½ä»¤æ¯mysqlï¼ mysql ç使ç¨è¯æ³å¦ä¸ï¼ mysql [-u username] [-h host] [-p[password]] [dbname] username ä¸ password åå«æ¯ MySQLç¨æ·åä¸å¯ç ï¼mysqlçåå§ç®¡çå¸å·æ¯rootï¼æ²¡æå¯ç ï¼æ³¨æï¼è¿ä¸ªrootç¨æ·ä¸æ¯Linuxçç³»ç»ç¨æ·ãMySQLé»è®¤ç¨æ·æ¯ rootï¼ç±äºåå§æ²¡æå¯ç ï¼ç¬¬ä¸æ¬¡è¿æ¶åªéé®å
¥mysqlå³å¯ã
[root@test1 local]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 4.0.16-standard
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>
åºç°äºâmysql>âæ示符ï¼æåä½ ï¼å®è£
æå!
å¢å äºå¯ç åçç»å½æ ¼å¼å¦ä¸ï¼
mysql -u root -p
Enter password: (è¾å
¥å¯ç )
å
¶ä¸-uåè·çæ¯ç¨æ·åï¼-pè¦æ±è¾å
¥å¯ç ï¼å车åå¨è¾å
¥å¯ç å¤è¾å
¥å¯ç ã
å¯æ¯æè¾å
¥mysqlå´åºéäºï¼
åå§å¯ç æ¯ç©ºçï¼æè¾å
¥çä¹æ¯ç©ºçè¿æ¯é误!
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
MySQLå®è£
解å³æ¹æ³ï¼éæ¹å¯ç
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysqld restart
# mysql -uroot -p
Enter password:
mysql>æå®!