Linux Mysql֪ʶѧϰƪ

2014-11-24 17:28:44 ¡¤ ×÷Õß: ¡¤ ä¯ÀÀ: 0

1.²é¿´Linux ÊÇ·ñ°²×°ÁËMysql


[root@localhost zhoulinghong]# rpm -qa |grep MySQL


MySQL-server-community-5.1.22-0.rhel4


ÒѾ­°²×°ÁË¡£


2.Linux ϰ²×°mysql£¨rpm£©


[root@localhost zhoulinghong]# rpm -ivh MySQL-server-community-5.1.22-0.rhel4.i386.rpm


warning: MySQL-server-community-5.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5


error: Failed dependencies:


perl(DBI) is needed by MySQL-server-community-5.1.22-0.rhel4.i386


Suggested resolutions:


perl-DBI-1.40-5.i386.rpm


ºÇºÇ£¬³ö´íÁË¡£LinuxµÄ±×¶Ë¾Í³öÏÖÁË¡£°²×°Èí¼þµÄʱºòÏ໥ÒÀÀµÌ«Ç¿ÁË¡£¡£¡£¿´µ½ÉÏÃæ´íÎóÐÅÏ¢ÊÇȱÉÙperl-DBI-1.40-5.i386.rpm°ü¡£Ã»Óа취ֻÄܰ²×°ÁË


3.°²×°ÒÀÀµ°ü


[root@localhost mnt]# mount /dev/cdrom /mnt/cdrom


¹ÒÔØ³É¹¦ÒÔºó¡£×ªµ½ /mnt/cdrom/RedHat/RPMSĿ¼ÏÂÃæ¾ÍÓÐperl-DBI-1.40-5.i386.rpm Õâ¸ö°üÁË¡£


[root@localhost RPMS]# rpm -ivh perl-DBI-1.40-5.i386.rpm


warning: perl-DBI-1.40-5.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e


Preparing... ########################################### [100%]


1:perl-DBI ########################################### [100%]


°²×°³É¹¦¡£


OK£¬µ½ÏÖÔÚµÄÒÀÀµ°üÒ²°²×°ÍêÁË£¬¾Í¿ÉÒÔ°²×°mysqlÁË¡££¨×¢Ò⣺ÒòΪ´ó¼ÒµÄ»·¾³²»Ò»Ñù£¬Öмä¿ÉÄÜÓÐÆäËûµÄÒÀÀµ°üÐèÒª°²×°£¬·½·¨ÕÕÉÏÃæ¾ÍºÃÁË¡££©


4.°²×°Mysql


[root@localhost zhoulinghong]# rpm -ihv MySQL-server-community-5.1.22-0.rhel4.i386.rpm


warning: MySQL-server-community-5.1.22-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5


Preparing... ########################################### [100%]


1:MySQL-server-community ########################################### [100%]


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !


To do so, start the server, then issue the following commands:


/usr/bin/mysqladmin -u root password 'new-password'


/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'


See the manual for more instructions.


Please report any problems with the /usr/bin/mysqlbug script!


The latest information about MySQL is available on the web at


http://www.mysql.com


Support MySQL by buying support/licenses at http://shop.mysql.com


Notes regarding SELinux on this platform:


=========================================


The default policy might cause server startup to fail because it is


not allowed to access critical files. In this case, please update


your installation.


The default policy might also cause inavailability of SSL related


features because the server is not allowed to access /dev/random


and /dev/urandom. If this is a problem, please do the following:


1) install selinux-policy-targeted-sources from your OS vendor


2) add the following two lines to /etc/selinux/targeted/src/policy/domains/program/mysqld.te:


allow mysqld_t random_device_t:chr_file read;


allow mysqld_t urandom_device_t:chr_file read;


3) cd to /etc/selinux/targeted/src/policy and issue the following command:


make load


Starting MySQL[ OK ]


Giving mysqld 2 seconds to start


ºÜÃ÷ÏÔ£¬°²×°³É¹¦ÁË¡£Èç¹û°²×°Ê§°ÜÁ˾ÍÐ¶ÔØÒ»´ÎÔÚ°²×°Ò»Ï¾ͻù±¾Ã»ÓÐʲôÎÊÌâÁË¡£