安装介质:Percona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz
安装环境:Linux umbidb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
安装步骤:
建立数据安装目录:/mysql /
建立数据数据目录:/mysqldb/data/
解压
将安装介质拷贝到/mysql /,进行解压缩,重命名为mysql,操作命令
tar –zxvfPercona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz
Mv Percona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz mysql
2、配置修改
echo "/mysql /mysql/lib" >> /etc/ld.so.conf.d/libc.conf
echo "/mysql /mysql/lib/mysql" >> /etc/ld.so.conf.d/libc.conf
/sbin/ldconfig
cp /mysql/mysql/share/mysql/my-medium.cnf /etc/my.cnf
3、添加用户和组
groupadd mysql
useradd -g mysql mysql
4、改属主和属组
chown -R mysql:mysql /mysql/mysql/ //将basedir的用户和组改为mysql
5、初始化数据库
/mysql/mysql/bin/mysql_install_db --user=mysql --basedir=/mysql/mysql --datadir=/mysql/data
6、设置mysql启动脚本
cp /mysql/mysql/share/mysql/mysql.server /etc/init.d/rc.mysql
chmod 755 /etc/init.d/rc.mysql
ldconfig
7、启动数据库
/etc/init.d/rc.mysql start
update user set password=PASSWORD('123') WHERE USER='root';//修改ROOT密码
grant all on *.* to root@'%' identified by '123' with grant option;
安装环境:Linux umbidb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
安装步骤:
建立数据安装目录:/mysql /
建立数据数据目录:/mysqldb/data/
解压
将安装介质拷贝到/mysql /,进行解压缩,重命名为mysql,操作命令
tar –zxvfPercona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz
Mv Percona-Server-5.1.56-rel12.7-224-Linux-x86_64.tar.gz mysql
2、配置修改
echo "/mysql /mysql/lib" >> /etc/ld.so.conf.d/libc.conf
echo "/mysql /mysql/lib/mysql" >> /etc/ld.so.conf.d/libc.conf
/sbin/ldconfig
cp /mysql/mysql/share/mysql/my-medium.cnf /etc/my.cnf
3、添加用户和组
groupadd mysql
useradd -g mysql mysql
4、改属主和属组
chown -R mysql:mysql /mysql/mysql/ //将basedir的用户和组改为mysql
5、初始化数据库
/mysql/mysql/bin/mysql_install_db --user=mysql --basedir=/mysql/mysql --datadir=/mysql/data
6、设置mysql启动脚本
cp /mysql/mysql/share/mysql/mysql.server /etc/init.d/rc.mysql
chmod 755 /etc/init.d/rc.mysql
ldconfig
7、启动数据库
/etc/init.d/rc.mysql start
update user set password=PASSWORD('123') WHERE USER='root';//修改ROOT密码
grant all on *.* to root@'%' identified by '123' with grant option;