mysql 5.5安装手记

#准备工作
yum install -y gcc gcc-c++ libtool autoconf automake imake libxml2-devel expat-devel ncurses-devel cmake bison 

#添加mysql用户、组
groupadd mysql 
useradd -r -g mysql mysql 
mkdir /usr/local/mysql/        #创建mysql安装目录
mkdir /data/mysql               #创建数据存放目录

#配置编译安装mysql
tar zxvf mysql-5.5.13.tar.gz
cd mysql-5.5.13
cmake . \                                        #开始编译 
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \      #安装到/usr/local/mysql目录 
-DMYSQL_DATADIR=/data/mysql \                  #数据存放到/data/mysql目录 
-DMYSQL_UNIX_ADDR=/data/mysql/mysqld.sock \    #sock存放到/data/mysql目录 
-DWITH_INNOBASE_STORAGE_ENGINE=1 \             #innoDB引擎
-DENABLED_LOCAL_INFILE=1 \ 
-DDEFAULT_CHARSET=utf8 \                       #字符集
-DDEFALUT_CHARSETS=all \                       #支持所有字符集
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ 
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \ 
-DWITH_PARTITION_STORAGE_ENGINE=1 \ 
-DDEFAULT_COLLATION=utf8_general_ci \          #字符集校验
-DMYSQL_USER=mysql \ 
-DEXTRA_CHARSETS=all \ 
-DMYSQL_TCP_PORT=3306 \ 
-DWITH_DEBUG=0
make
make install

#改变目录权限
chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql

chown -R mysql /data/mysql
chgrp -R mysql /data/mysql

scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --ldata=/data/mysql #初始化数据库

chown -R root /usr/local/mysql

#可选
cp support-files/my-medium.cnf /etc/my.cnf   #复制配置文件 

cp support-files/mysql.server /etc/init.d/mysqld    #复制启动脚本
chmod 755 /etc/init.d/mysqld

#将mysql的启动服务添加到系统服务中  
chkconfig --add mysqld                              #添加系统服务 
chkconfig mysqld on                                 #添加开机启动
chkconfig --levels 245 mysqld off
或
echo "/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/data/mysql/ &" >> /etc/rc.loacl

export PATH=$PATH:/usr/local/mysql/bin    #添加环境变量 
echo ‘PATH=$PATH:/usr/local/mysql/bin‘ >> /etc/profile 

#启动mysql
service mysqld start/stop 
或
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/data/mysql/ & 适用于没有自启动文件的

#启动mysql，看是否成功  
netstat -tnl|grep 3306 

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/mysql//bin/mysqladmin -u root password ‘new-password‘
/usr/local/mysql//bin/mysqladmin -u root -h localhost password ‘new-password‘

Alternatively you can run:
/usr/local/mysql//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql/ ; /usr/local/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/mysql//scripts/mysqlbug script!

shell> groupadd mysql
shell> useradd -r -g mysql mysql
# Beginning of source-build specific instructions
shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> cmake .
shell> make
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server

    use mysql;
    update user set password=password(‘123456‘) where user=‘root‘
    flush privileges;

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/mysql//bin/mysqladmin -u root password ‘new-password‘
/usr/local/mysql//bin/mysqladmin -u root -h localhost password ‘new-password‘

Alternatively you can run:
/usr/local/mysql//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql/ ; /usr/local/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/mysql//scripts/mysqlbug script!