RHEL下安装MySQL.doc

RHEL下安装MySQL1.到mysql的网站(必须到官方网站下载,防止数据被修改,纂改过)下载四个必须rpm 安装包:/downloads/mysql/5.0.html#linux-rhel5-ia64-rpmsMySQL-client-5.1.16-0.glibc23.i386.rpmMySQL-devel-5.1.16-0.glibc23.i386.rpmMySQL-server-5.1.16-0.glibc23.i386.rpmMySQL-shared-5.1.16-0.glibc23.i386.rpm2. 通过ssh远程控制工具传到服务器上,放在适当的目录下(如:/opt/mysql/mysql5.1.16)3.进入目录(/opt/mysql/mysql5.1.16)下安装msyql:rpm 文件是Red Hat公司开发的软件安装包，rpm可让Linux在安装软件包时免除许多复杂的手续。该命令在安装时常用的参数是 ivh ,其中i表示将安装指定的rmp软件包，V表示安装时的详细信息，h表示在安装期间出现#符号来显示目前的安装过程。这个符号将持续到安装完成后才停止。rootqudee mysql5.1.16# rpm ivh MySQL-client-5.1.16-0.glibc23.i386.rpmrootqudee mysql5.1.16# rpm ivh MySQL-devel-5.1.16-0.glibc23.i386.rpmrootqudee mysql5.1.16# rpm ivh MySQL-shared-5.1.16-0.glibc23.i386.rpmrootqudee mysql5.1.16# rpm ivh MySQL-server-5.1.16-0.glibc23.i386.rpm显示如下信息warning: MySQL-server-5.1.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5Preparing. # 100%1:MySQL-server # 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 password new-passwordSee the manual for more instructions.NOTE: If you are upgrading from a MySQL = 3.22.10 you should runthe /usr/bin/mysql_fix_privilege_tables. Otherwise you will not beable to use the new GRANT command!Please report any problems with the /usr/bin/mysqlbug script!The latest information about MySQL is available on the web atSupport MySQL by buying support/licenses atStarting MySQL.失败4.查看已安装的包rootqudee mysql5.1.20# rpm -qa | grep -i mysql或者 rootqudee mysql5.1.20# rpm -qa | grep mysqlMySQL-devel-5.1.20-0.glibc23MySQL-shared-5.1.20-0.glibc23MySQL-client-5.1.20-0.glibc23MySQL-server-5.1.20-0.glibc235.查看rootqudee /# locate mysql.server 的路径/usr/share/man/man1/mysql.server.1.gz/usr/share/mysql/mysql.server复制并更名 rootqudee /#cp /usr/share/mysql/mysql.server /etc/init.d/mysqld6.查看rootqudee /# locate f 的路径/usr/share/doc/MySQL-server-5.1.16/f/usr/share/mysql/f复制并更名rootqudee /#cp /usr/share/mysql/f /etc/f7.启动服务:service mysqld startStarting MySQL OK 启动成功!恭喜8.编辑vi /etc/f 这个文件,设置字符集,支持国际化.default-character-set=utf8 /在此添加字符集# Here follows entries for some specific programs# The MySQL servermysqld port = 3306#socket = /var/lib/mysql/mysql.sockskip-lockingkey_buffer = 384Mmax_allowed_packet = 1Mtable_cache = 512sort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 8Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size = 32Mdefault-character-set=utf8 /在此添加字符集# Try number of CPUs*2 for thread_concurrencythread_concurrency = 16先按Esc, 再同时按Shift + ; 再输入wq! (推出并保存)呵呵! 字符集就配置好了9.MySQL默认的数据文件存储目录为/var/lib/mysql。假如要把目录移到/qudeedata/dbdata/mysql5.1.16下需要进行下面几步：(1)、/qudeedata/dbdata目录下建立mysql5.1.16目录cd /qudeedata/dbdatamkdir mysql5.1.16(2)、把MySQL服务进程停掉：service mysqld stop(3)、把/var/lib/mysql整个目录移到/qudeedata/dbdata/mysql5.1.16mv /var/lib/mysql/qudeedata/dbdata/mysql5.1.16这样就把MySQL的数据文件移动到了/qudeedata/dbdata/mysql5.1.16 下(4)、编辑MySQL的配置文件/etc/f为保证MySQL能够正常工作，需要指明mysql.sock文件的产生位置。修改socket=/var/lib/mysql/mysql.sock一行中等号右边的值为：/qudeedata/dbdata/mysql5.1.16/mysql/mysql.sock 。操作如下：命令: vi f (用vi工具编辑f文件，找到下列数据修改之)# The MySQL servermysqldport= 3306#socket = /var/lib/mysql/mysql.sock（原内容，为了更稳妥用#注释此行）socket = /qudeedata/dbdata/mysql5.1.16/mysql/mysql.sock（加上此行）(5)、修改MySQL启动脚本/etc/rc.d/init.d/mysqld最后，需要修改MySQL启动脚本/etc/rc.d/init.d/mysqld，把其中datadir=/var/lib/mysql一行中，等号右边的路径改成你现在的实际存放路径：/qudeedata/dbdata/mysql5.1.16。roottest1 etc# vi/etc/rc.d/init.d/mysqld#datadir=/var/lib/mysql（注释此行）datadir=/qudeedata/dbdata/mysql5.1.16 （加上此行）10、自动启动1）察看mysql是否在自动启动列表中rootqudee /#chkconfig list2）把MySQL添加到你系统的启动服务组里面去rootqudee /#chkconfig addmysql11.测试通过命令是否能够启动,停止,重启结果:rootqudee /# service mysqld startStarting MySQL OK rootqudee /# service mysqld restartShutting down MySQL. OK Starting MySQL OK rootqudee /# service mysqld stopShutting down MySQL. OK rootqudee /# /etc/init.d/mysqld startStarting MySQL OK rootqudee /# /etc/init.d/mysqld restartShutting down MySQL.