（4）linux下安装配置Mysql

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();