1.检查以前版本并卸载:
①搜索原先版本,命令:
# rpm -qa | grep mysql (注意大小写,如果mysql 不行就换MySQL)
②将搜索出的包名卸载,命令: #rpm -e –nodeps mysql-5 [...]
2..创建用户及组
①创建组: # groupadd mysql ②创建用户 # useradd –g mysql
3.上传文件
①进入cd /tmp/目录: # cd /tmp/
②上传: # rz mysql-5.1.53.tar.gz
③解压: # tar -zxvf mysql-5.1.53.tar.gz
④进入mysql-5.1.53: # mysql-5.1.53
4.编译前准备:
进入cd /tmp/mysql-5.1.53目录
输入命令: # ./configure --prefix=/usr/local/mysql --with-charset=utf8--with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-unix-socket-path=/usr/local/mysql/mysql.sock --enable-assembler --with-charset=utf8 --with-extra-charsets=utf8 --with-plugins=innobase,myisam
5.编译安装:
①进入cd /tmp/mysql-5.1.53目录: # cd /tmp/mysql-5.1.53
②编译: # make
③安装: # make install
6.设置权限权限
进入cd /usr/local/目录
①设置权限,命令: # chown -R mysql:mysql mysql
②初始化数据库,命令: # ./usr/local/mysql/bin/mysql_install_db --user=mysql
③ 复制文件,命令: # cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
④创建套字节文件,命令: #vi /usr/local/mysql/mysql.sock
⑤初次启动,根目录下执行命令:
# /usr/local/mysql/bin/mysqld_safe &
⑥切换用户:# pkill mysql
⑦启动mysql ,进入 cd /usr/local/mysql/bin/目录,
命令: # ./mysqld_safe --socket=/usr/local/mysql/mysql.sock
⑧登录mysql,命令: # /usr/local/mysql/bin/mysql -u root -p
⑨创建mysql账户,账户名:admin密码:admin分配权限
GRANT ALL PRIVILEGES ON *.* TO admin@"%" IDENTIFIED BY 'admin' WITH GRANT OPTION;0