mysql 5.5.10 for linux 安装 操作系统:centos 5.5 mysql:5.5.10 su - 利用 centos 系统自带的 yum 命令安装、升级所需的程序库 sudo -s lang=c yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-develfreetype freetype-devel lib
·mysql 5.5.10  for linux 安装
操作系统:centos 5.5
mysql:5.5.10
su -
利用centos 系统自带的yum命令安装、升级所需的程序库
sudo -s
lang=c
yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-develfreetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-develglib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devele2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel opensslopenssl-devel openldap openldap-devel nss_ldap openldap-clientsopenldap-servers
#先下载cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
安装cmake
#tar –xzvf cmake-2.8.4.tar.gz
#cd cmake-2.8.4
#./configure
#make
#make install
1.创建mysql用户名及组
#groupadd mysql
#useradd -g mysqlmysql
2.下载mysql5.5.10
wget ftp://mirror.switch.ch/mirror/mysql/downloads/mysql-5.5/mysql-5.5.10.tar.gz
#tar –xzvf mysql-5.5.10.tar.gz
#cd mysql-5.5.10.tar.gz
开始编译并安装
#/usr/local/bin/cmake .-dcmake_install_prefix=/usr/local/webserver/mysql/-dmysql_datadir=/usr/local/webserver/mysql/data-dwith_innobase_storage_engine=1 -dmysql_tcp_port=3306-dmysql_unix_addr=/usr/local/webserver/mysql/data/mysql.sock -dmysql_user=mysql-dwith_debug=0
#make && make install
初始化，下列命令使mysql得到对数据库文件的拥有权。mysql_install_db脚本能刷新授权表
# cd /usr/local/mysql
# chown -r mysql .
# chgrp -r mysql .
# scripts/mysql_install_db --user=mysql
# chown -r root .
# chown -r mysql data
可选命令，配置文件位置更改，且内有五种配置模式。
# cp support-files/my-medium.cnf /etc/my.cnf
# bin/mysqld_safe --user=mysql &
可选命令，自启动脚本，可以mysql自动启动。
# cp support-files/mysql.server /etc/init.d/mysql.server
遇到的问题：
----------------------------------------------------------
-- mysql 5.5.9
-- could not find curses (missing: curses_librarycurses_include_path)
cmake error at cmake/readline.cmake:82 (message):
curses library not found. please install appropriatepackage,remove cmakecache.txt and rerun cmake.on debian/ubuntu , package nameis libncurses5-dev,on redhat and derivates it is ncurses-devel.
call stack (most recent call first):
cmake/readline.cmake:126 (find_curses)
cmake/readline.cmake:216 (mysql_use_bundled_libedit)
cmakelists.txt:256(mysql_check_readline)
解决：安装ncurses-devel，并删除当前目录cmakecache.txt(必须删除，否则报错依旧)并重新运行。
开启mysql：
cd . ; ./bin/mysqld_safe &
当然你用root命令开启的时候，应当使用--user参数，这样才是安全的启动方式。
cd . ; ./bin/mysqld_safe --user=mysql &
为root和你的用户名设置密码，这需要在你先启动mysql的基础上，否则会报错，说你没有连接到端口：
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h yourusername password'new-password'
也可一用下命令替代：
./bin/mysql_secure_installation