Red Hat enterprise linux 5 mysql°²×°²½Öè

Ò»¡¢°²×°·þÎñÆ÷¶Ë
£¨1£©¡¢ÔÚÓÐÁ½¸örmpÎļþµÄĿ¼ÏÂÔËÐÐÈçÏÂÃüÁ
[root@test1 local]# rpm -ivh MySQL-server-5.0.26-0.i386.rpm
ÏÔʾÈçÏÂÐÅÏ¢£º
warning: MySQL-server-5.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing……¡¡¡¡¡¡¡¡¡¡¡¡¡¡########################################### [100%]
1:MySQL-server¡¡¡¡¡¡¡¡¡¡########################################### [100%]
¡¡¡¡……£¨Ê¡ÂÔÏÔʾ£©
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h test1 password 'new-password'
Starting mysqld daemon with databases from /var/lib/mysql
¡¡Èç³öÏÖÈçÉÏÐÅÏ¢£¬·þÎñ¶Ë°²×°Íê±Ï¡£
£¨2£©¡¢²âÊÔ·þÎñ¶Ë°²×°ÊÇ·ñ³É¹¦£¬¿ÉÔËÐÐnetstat¿´Mysql¶Ë¿ÚÊÇ·ñ´ò¿ª£¬Èç´ò¿ª±íʾ·þÎñÒѾ­Æô¶¯£¬°²×°³É¹¦¡£MysqlĬÈϵĶ˿ÚÊÇ3306¡£
[root@test1 local]# netstat -nat
ÏÔʾÈçÏÂÐÅÏ¢£º
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address¡¡¡¡¡¡¡¡¡¡ Foreign Address¡¡¡¡¡¡¡¡ State
tcp¡¡¡¡0¡¡¡¡0 0.0.0.0:3306¡¡¡¡¡¡¡¡ 0.0.0.0:*¡¡¡¡¡¡¡¡¡¡ LISTEN
ÉÏÃæÏÔʾ¿ÉÒÔ¿´³öMySQL·þÎñÒѾ­Æô¶¯¡£
¶þ¡¢°²×°¿Í»§¶Ë
ÔËÐÐÈçÏÂÃüÁ
[root@test1 local]# rpm -ivh MySQL-client-5.0.26-0.i386.rpm
warning: MySQL-client-5.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing……¡¡¡¡¡¡¡¡########################################### [100%]
1:MySQL-client¡¡ ########################################### [100%]
ÏÔʾ°²×°Íê±Ï¡£
Èý¡¢µÇ¼MySQL
£¨1£©¡¢MySQLĬÈÏÓû§ÊÇroot£¬ÓÉÓÚ³õʼûÓÐÃÜÂ룬µÚÒ»´Î½øʱֻÐè¼üÈëmysql¼´¿É¡£
[root@test1 local]# mysql
³öÏÖÁË“mysql>”Ìáʾ·û£¬¹§Ï²Ä㣬°²×°³É¹¦£¡
£¨2£©¡¢Ôö¼ÓÁËÃÜÂëºóµÄµÇ¼¸ñʽÈçÏ£º
mysql -u root -p
Enter password: (ÊäÈëÃÜÂë)
ËÄ¡¢Ð޸ĵǼÃÜÂë
/usr/bin/mysqladmin -u root password 'new-password'
Îå¡¢Æô¶¯ÓëÍ£Ö¹
£¨1£©¡¢Æô¶¯
[root@test1 init.d]# /etc/init.d/mysql start
£¨2£©¡¢Í£Ö¹
/usr/bin/mysqladmin -u root -p shutdown
£¨3£©¡¢×Ô¶¯Æô¶¯
/sbin/chkconfig mysql on
Áù¡¢¿ªÆôÔ¶³ÌÁ¬½Ó
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysq