MYSQL5.5.48编译安装

在http://dev.mysql.com/downloads/mysql/页面选择Source Code下载mysql-5.5.48.tar.gz

如果不是选择Source Code在安装的时候会报如下错误&＃xff1a;

CMake Error: The source directory “*” does not appear to contain CMakeLists.txt.

Specify –help for usage, or press the help button on the CMake GUI.

1.安装所需相关库文件&＃xff1a;

# yum install -y gcc gcc-c&＃43;&＃43; gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* cmake make

2.安装过程

&＃xff08;1&＃xff09;创建目录、用户和权限

# mkdir -p /usr/local/mysql        #建立mysql安装目录

# mkdir -p /usr/local/mysql/data   #建立mysql数据库目录

# groupadd mysql                   #添加mysql组

# useradd -g mysql mysql           #添加一个mysql用户并加入到mysql组中

# chown -R mysql.mysql /usr/local/mysql/data/   #将/data/mysql目录的所有权赋予mysql组中的mysql用户

&＃xff08;2&＃xff09;安装mysql

上传mysql-5.5.48.tar.gz至/usr/local/src/

进入目录&＃xff1a;# cd /usr/local/src/

# tar -zxvf mysql-5.5.48.tar.gz

# cd mysql-5.5.48

# cmake -DCMAKE_INSTALL_PREFIX&＃61;/usr/local/mysql -DMYSQL_UNIX_ADDR&＃61;/usr/local/mysql/data/mysql.sock -DDEFAULT_CHARSET&＃61;utf8 -DDEFAULT_COLLATION&＃61;utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING&＃61;all -DWITH_MYISAM_STORAGE_ENGINE&＃61;1 -DWITH_INNOBASE_STORAGE_ENGINE&＃61;1 -DWITH_MEMORY_STORAGE_ENGINE&＃61;1 -DWITH_READLINE&＃61;1 -DENABLED_LOCAL_INFILE&＃61;1 -DMYSQL_DATADIR&＃61;/usr/local/mysql/data/ -DMYSQL_USER&＃61;mysql -DMYSQL_TCP_PORT&＃61;3306

# make && make install

# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf     #如果你的机器的内存较大&＃xff0c;可以复制My-huge.cnf文件

# chmod 755 scripts/mysql_install_db

# scripts/mysql_install_db  --user&＃61;mysql  --basedir&＃61;/usr/local/mysql --datadir&＃61;/usr/local/mysql/data/    ##初始化数据库

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql    #设置开机启动mysql

# chmod 755 /etc/init.d/mysql

# chkconfig mysql on     #开机启动

# echo &＃39;export PATH&＃61;/usr/local/mysql/bin:$PATH&＃39; >> /etc/profile         #将mysql的安装路径加入PATH

# source /etc/profile #使配置立即生效

# /etc/init.d/mysql start      #启动mysql&＃xff08;如启动后不能登录&＃xff0c;则重启系统&＃xff09;

# netstat -nat | grep 3306          #查看3306端口是否打开

&＃xff08;3&＃xff09;防火墙开放3306端口

# vim /etc/sysconfig/iptables

添加

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

重启防火墙服务

&＃xff08;4&＃xff09;设置和修改root用户密码

mysql修改&＃xff0c;可在mysql命令行执行如下&＃xff1a;

[root&＃64;localhost ~]# mysql -u root -p    //首次登录可使用[root&＃64;localhost ~]# mysql

mysql> use mysql;

mysql> update user set password&＃61; password ("root") where user&＃61;&＃39;root&＃39;;

mysql>  update user set password&＃61; password ("root");&＃xff08;用这句&＃xff09;

&＃xff08;5&＃xff09;开启允许远程连接

mysql> select &＃96;Host&＃96;,&＃96;User&＃96; from user;

mysql> update user set &＃96;Host&＃96; &＃61; &＃39;%&＃39; where &＃96;User&＃96; &＃61; &＃39;root&＃39; limit 1;

mysql> quit

注意在mysql 命令行形式下一定要输入";"

重启一下mysql服务&＃xff0c;

# /etc/init.d/mysql restart