Redhat下MySQL5.5.20安装配置

￡神魔★判官ぃ 2022-06-14 04:46 239阅读 0赞

mysql 最新的版本都需要cmake编译安装，估计以后的版本也会采用这种方式，所以特地记录一下安装步骤及过程，以供参考。  
注意：此安装是默认Redhat下已经安装了最新工具包，比如GNU make, GCC, Perl, libncurses5-dev，如果在编译安装过程中发现有缺失的工具包，先yum install 单独下载安装再继续即可。  
  
一. linux用 wget 下载需要的软件，保存到目录 /usr/local/src 下

wget ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.20.tar.gz

wget http://www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz

wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz

二. 安装 cmake  
cd /usr/local/src  
tar zxvf  cmake-2.8.7.tar.gz  
cd  cmake-2.8.7.tar.gz  
./bootstrap  
gmake  
gmake install  
cd ../  
  
tar zxvf bison-2.5.tar.gz  
cd bison-2.5  
./configure  
make  
make install  
cd ../

三. 编译安装 MySQL 5.5.20  
groupadd –g 1000 mysql  
useradd –u 1000 –g mysql mysql  
tar xvf mysql-5.5.20.tar.gz  
cd mysql-5.5.20/  
/usr/local/bin/cmake .

\-DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql \\   
\-DMYSQL\_UNIX\_ADDR=/tmp/mysql.sock \\  
\-DDEFAULT\_CHARSET=utf8 \\  
\-DDEFAULT\_COLLATION=utf8\_general\_ci \\  
\-DWITH\_EXTRA\_CHARSETS:STRING=utf8,gbk \\  
\-DWITH\_MYISAM\_STORAGE\_ENGINE=1 \\  
\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\  
\-DWITH\_MEMORY\_STORAGE\_ENGINE=1 \\  
\-DWITH\_DEBUG=0 \\  
\-DWITH\_READLINE=1 \\  
\-DENABLED\_LOCAL\_INFILE=1 \\  
\-DMYSQL\_DATADIR=/home/mysql/data \\  
\-DMYSQL\_USER=mysql  
  
\-- Could NOT find Curses (missing: CURSES\_LIBRARY CURSES\_INCLUDE\_PATH)   
CMake Error at cmake/readline.cmake:82 (MESSAGE):  
Curses library not found.  Pleaseinstall appropriate package,  
removeCMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name islibncurses5-dev, on Redhat and derivates it is ncurses-devel.  
Call Stack (most recent call first):  
cmake/readline.cmake:117 (FIND\_CURSES)  
cmake/readline.cmake:213(MYSQL\_USE\_BUNDLED\_READLINE)  
CMakeLists.txt:250 (MYSQL\_CHECK\_READLINE)  
  
yum install ncurses-devel  
rm CMakeCache.txt  
\-- 这里重新开始做cmake操作即可  
make  
make install  
chmod +w /usr/local/mysql  
chown -R mysql:mysql /usr/local/mysql  
ln -s /usr/local/mysql/lib/libmysqlclient.so.18/usr/lib/libmysqlclient.so.18  
mkdir -p /usr/local/mysql/data  
chown -R mysql:mysql /usr/local/mysql/data  
ln -s /usr/local/mysql/data /home/mysql/data  
mkdir -p /var/mysql/log/  
chown -R mysql:mysql /var/mysql/  
cd support-files/  
cp my-large.cnf /etc/my.cnf  
cp mysql.server /etc/init.d/mysqld  
  
四. 配置启动MySQL 5.5.20  
1. 若有需要请先修改 mysql 的配置 my.cnf  
vi /etc/my.cnf

\[mysqld\] 下添加  
basedir = /usr/local/mysql      
datadir = /usr/local/mysql/data

2.my.cnfmysql 初始化安装  
/usr/local/mysql/scripts/mysql\_install\_db \\  
\--defaults-file=/etc/my.cnf \\  
\--basedir=/usr/local/mysql \\  
\--datadir=/usr/local/mysql/data \\  
\--user=mysql  
  
3. 将 mysql 加入开机启动  
chmod +x /etc/init.d/mysqld  
vi /etc/init.d/mysqld （编辑此文件，查找并修改以下变量内容：）  
basedir=/usr/local/mysql  
datadir=/usr/local/mysql/data  
chkconfig --add mysqld  
chkconfig --level 345 mysqld on  
  
4. 启动 mysql  
service mysqld start  
  
5. 配置访问帐号taxioncall

/usr/local/mysql/bin/mysqladmin -uroot password pw  
/usr/local/mysql/bin/mysql -uroot -p  
mysql>use mysql;  
mysql> GRANT ALL PRIVILEGES ON \*.\* TO taxioncall@'%' IDENTIFIED BY 'pw' with GRANT OPTION;

mysql>update user set password=password('pw');  --所有用户都密码更新

mysql>FLUSH   PRIVILEGES;  
mysql>quit;