linux下安装和配置mysql

a、查看是否安装了mysql：rpm -qa|grep -i mysqlb、如果已经安装了就删除：rpm -e mysql-libs-5.1.52-1.el6_0.1.x86_64   --nodeps拷贝文件到/usr/local/src，进入目录1、安装服务端/usr/local/src# rpm -ivh MySQL-server-5.5.25a-1.rhel5.x86_64.rpm  --nodeps --force2、安装客户端/usr/local/src# rpm -ivh MySQL-client-5.5.25a-1.rhel5.x86_64.rpm --nodeps --force完成，查看安装目录 # find / -name mysql -print3、启动mysql# /etc/init.d/mysql start测试是否启动成功# netstat -nat4、新安裝的數據庫默認的root 用戶是沒有密碼，所以我們第一步就是為其設置自已密碼權，设置密码# /usr/bin/mysqladmin -u root password 'pajrgj'/usr/bin/mysqladmin -u root password 'admin'5、登录验证# mysql -u root -p520134显示:验证存储引擎mysql>  show engines;退出：mysql> quit;6:停止mysql:# /etc/init.d/mysql stop7 修改my.cnf文件如果/etc/目录下没有my.cnf配置文件，到/usr/share/mysql/下找到 *.cnf文件，拷贝其中一个到/etc/并改名为my.cnf)中。命令如下： # cp /usr/share/mysql/my-medium.cnf　/etc/my.cnf用附件文件代替直接上传到/etc移动备份/var/lib/mysql的ib_logfile0、ib_logfile1到bak# mkdir /var/lib/mysql/bak# mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/bak/# mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/bak/8 启动mysql9 远程访问，注意密码mysql>  GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' identified by 'pajrgj'; mysql > GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'pajrgj' WITH GRANT OPTION;10 登录，建立数据库mysql> create database jrgj default character set utf8 collate utf8_general_ci;11 恢复数据库# mysql -u root -ppajrgj jrgj < /usr/local/src/jrgj.sql