MySQL 5 on Linux手动安装方法.docVIP

MySQL 5 on Linuxê??ˉ°2×°·?·¨ 1. ????mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz￡?í???ICC°?±?￡???3?±èGCC???üìá??10-20% 2. ?′??μ?/usr/local/￡??a?1￡otar zxvf mysql-standard-5.x....tar.gz 3. ìí?óó??§oí×émysql￡o groupadd mysql useradd -g mysql mysql 4. ′′?¨·?o?á??ó￡o/usr/local # ln -s mysql-standard-5.x... mysql 5. cd mysql￡?μ±?°???????a/usr/local/mysql/ 6. ??????2?3?ê??ˉê????a￡o./scripts/mysql_install_db --user=mysql 7. éè??è¨??￡o /usr/local/mysql # chown -R root . /usr/local/mysql # chown -R mysql data /usr/local/mysql # chgrp -R mysql 8. ?ù???èòa′′?¨2￠????/etc/my.cnf￡?2???????￡o [mysqld] # éè????è??aINNODB±í￡??§3?ê???￡o default-storage-engine=INNODB # éè????è?μ?×?·??ˉ￡o default-character-set=utf8 # ??ó?bdb￡o skip-bdb 9. ???ˉMySQL￡o /usr/local/mysql/bin # ./mysqld_safe --user=mysql 10. 3?ê??ˉroot?úá?￡o /usr/local/mysql/bin # ./mysqladmin -u root -p password password-of-root Enter password: ê?è??é?úá?￡??±?ó°′Enter 11. ò?rootμ???′′?¨ê????a￡o /usr/local/mysql # ./mysql -u root -p Enter password: password-of-root ′′?¨ò?????ó??§￡o mysql create user test identified by test-password; ′′?¨ò?????ê????a￡o mysql create database testdb; ?3óètestó??§′ólocalhost·??êtestdbμ?è¨??￡o mysql grant all on testdb.* to test@localhost; í￡?1MySQL·????÷￡o /usr/local/mysql/bin # ./mysqladmin -u root -p shutdown Enter password: password-of-root STOPPING server from pid file /usr/local/mysql/data/debian.pid xxx mysqld ended 1. ????mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz￡?í???ICC°?±?￡???3?±èGCC???üìá??10-20% 2. ?′??μ?/usr/local/￡??a?1￡otar zxvf mysql-standard-5.x....tar.gz 3. ìí?óó??§oí×émysql￡o groupadd mysql useradd -g mysql mysql 4. ′′?¨·?o?á??ó￡o/usr/local #ln -s mysql-standard-5.x... mysql 5. cd mysql￡?μ±?°???????a/usr/local/mysql/ 6. ??????2?3?ê??ˉê????a￡o./scripts/mysql_install_db --user=mysql 7. éè??è¨??￡o /usr/local/mysql #chown -R root . /usr/local/mysql #chown -R mysql data /usr/local/mysql #chgrp -R mysql 8. ?ù???èòa′′?¨2￠????/etc/my.cnf￡?2???????￡o [mysqld] # éè???