1)创建用户和组
groupadd mysql
useradd mysql -g mysql -M -s /sbin/nologin
2)下载软件
3)编译安装
./configure \
--prefix=/application/mysql5.1.72 \
--with-unix-socket-path=/application/mysql5.1.72/tmp/mysql.sock \
--localstatedir=/application/mysql5.1.72/data \
--enable-assembler \
--enable-thread-safe-client \
--with-mysqld-user=mysql \
--with-big-tables \
--without-debug \
--with-pthread \
--enable-assembler \
--with-extra-charsets=complex \
--with-readline \
--with-ssl \
--with-embedded-server \
--enable-local-infile \
--with-plugins=partition,innobase \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static
创建mysql.install 文件,将上述编译配置复制到文件中,进入到mysql包目录,
编译安装:
cat mysql.install | bash
错误:
checking for termcap functions library... configure: error: No curses/termcap library found
yum安装:
yum install ncurses-devel
make && make install
创建软链接
ln -s /application/mysql5.1.72/ /application/mysql
4)
拷贝配置文件:
cp my-small.cnf /etc/my.cnf
创建msyql数据句文件
mkdir /application/mysql/data -p
授权
chown -R mysql.mysql /application/mysql
初始化数据库
/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql
cp mysql.server.sh /etc/init.d/mysqld
启动mysql
cd /application/mysql ; /application/mysql/bin/mysqld_safe &
cd /application/mysql ; /application/mysql/bin/mysqld_safe —skip-grant-table &忽略授权表,用于修改密码
将mysql 添加到pah路径中
vim /etc/profile
. /etc/profile
命令行执行
mysql
进入到mysql的交互模式
脚本文件启动mysql
cp mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
vi /etc/init.d/mysqld
编辑下面两行:
basedir=/application/mysql/
datadir=/application/mysql/data
杀死mysql 进程
pkill mysqld
5)添加密码
/application/mysql/bin/mysqladmin -u root password 'oldboy123'
登录:
mysql -uroot -poldboy123
select version();
select user();