linux下mysql_rpm安装.docx

环境：Redhat5.5MySQL-client-5.6.14-1.rhel5.i386.rpmMySQL-server-5.6.14-1.rhel5.i386.rpmMySQL-shared-5.6.14-1.rhel5.i386.rpm1、查看MySQL及相关RPM包，是否安装：rootlocalhost # rpm -qa | grep -i mysqlmysql-libs-5.1.66-2.el6_3.x86_64rootlocalhost # yum -y remove mysql-libs*2、下载Linux对应的RPM包，如：CentOS6.4_64对应的RPM包，如下：MySQL-client-5.6.15-1.el6.x86_64.rpmMySQL-devel-5.6.15-1.el6.x86_64.rpmMySQL-server-5.6.15-1.el6.x86_64.rpm或：MySQL-client-5.6.14-1.rhel5.i386.rpmMySQL-server-5.6.14-1.rhel5.i386.rpmMySQL-shared-5.6.14-1.rhel5.i386.rpm3、安装MySQLrpm -ivh MySQL-*#修改配置文件位置rootlocalhost rpm# cp /usr/share/mysql/f /etc/f4、初始化MySQL及设置密码rootlocalhost rpm# /usr/bin/mysql_install_dbrootlocalhost rpm# service mysql startrootlocalhost rpm# cat /root/.mysql_secret #查看root账号密码# The random password set for the root user at Sun May 1 09:19:38 2016 (local time): Cb34wy5wrootlocalhost # mysql -uroot pqKTaFZnlmysql SET PASSWORD = PASSWORD(123456);#设置密码为123456mysqlexitrootlocalhost # mysql -uroot -p1234565、允许远程登陆mysql use mysql;mysqlselecthost,user,password from user;mysql update usersetpassword=password(123456) where user=root;mysql update usersethost=%where user=rootand host=localhost;mysql flush privileges;mysqlexit6、设置开机自启动rootlocalhost # chkconfig mysql onrootlocalhost # chkconfig -list | grep mysqlmysql0:off 1:off 2:on 3:on 4:on 5:on 6:off7、MySQL的默认安装位置/var/lib/mysql/#数据库目录/usr/share/mysql#配置文件目录/usr/bin#相关命令目录/etc/init.d/mysql#启动脚本8、修改字符集和数据存储路径配置/etc/f文件,修改数据存放路径、mysql.sock路径以及默认编码utf-8.client password = 123456 port = 3306 default-character-set=utf8 mysqld port = 3306 character_set_server=utf8 character_set_client=utf8 collation-server=utf8_general_ci #(注意linux下mysql安装完后是默认：表名区分大小写，列名不区分大小写； 0：区分大小写，1：不区分大小写) lower_case_table_names=1 #(设置最大连接数，默认为 151，MySQL服务器允许的最大连接数16384; ) max_connections=1000 mysql default-character-set = utf8 9、查看字符集show variables like %collation%;show variables like %char%;查看防火墙状态：service iptables status 查看防火墙状态service iptables start 开启防火墙service iptables stop 关闭防火墙service iptables restart 重启防火墙iptables是linux下的防火墙，同时也是服务名称。防火墙开放特定端口：/etc/sysconfig/iptables 添加：