mysql-5.5.11安装记录

2019独角兽企业重金招聘Python工程师标准>>>

官方网站：wwwmysql.com

版本号: 5.5.11

下载地址：http://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-5.5/mysql-5.5.11.tar.gz

预备环境 cmake 预编译

http://www.cmake.org/cmake/resources/software.html

mysql5.5以后是通过cmake来编译的

通过以下路径下载cmake-2.8.4.tar.gz，也可在http://www.cmake.org网站进行下载

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

# tar zxvf cmake-2.8.4.tar.gz

# cd cmake-2.8.4

# ./configure

# make && make install

安装前最好

#yum install ncurses-devel bison

安装过程

首先解压源代码，然后进行cmake预编译。

make &&make install

然后根据官方文档配置

To install and use a MySQL binary distribution, the basic command

  sequence looks like this:

# Preconfiguration setup
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

chkconfig 添加管理服务后就OK了,

装了这么一次，感觉一点似乎不同，编译一下，用脚本初始化数据库。

详细的安装配置：

1用户添加

2编译mysql-5.5.13

# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/var/mysqldata/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_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/var/mysqldata \

-DMYSQL_USER=mysql \

-DMYSQL_TCP_PORT=3306

# make

# make install

3、复制配置文件

# cp support-files/my-medium.cnf /etc/my.cnf

4、初始化数据库

执行前需赋给scripts/mysql_install_db文件执行权限

# chmod 755 scripts/mysql_install_db

# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ \

--datadir=/var/mysqldata/

注：basedir：mysql安装路径   datadir：数据库文件储存路径

改 mysql root密码

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h centos56 password 'new-password'#改host密码

 下面这句别搞错了，我搞错一次郁闷得只好重新初始化数据

update mysql.user set password=password("new_pass") where user="root";

flush privileges;

转载于:https://my.oschina.net/wenic705/blog/15753