mysql之一安装(单实例)

一、安装mysql

//安装编译环境gcc和依赖包
# yum install -y gcc gcc-c++ gcc-g++ autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*

//创建tools目录
# mkdir -p /home/oldboy/tools

//进入tools目录
# cd  /home/oldboy/tools

将mysql-5.5.32.tar.gz  cmake-2.8.8.tar.gz放到/home/oldboy/tools目录下

//解压cmake
# tar xf cmake-2.8.8.tar.gz

//进入cmake-2.8.8
# cd cmake-2.8.8

//编译cmake、安装gmake
# ./configure  &&  gmake &&  gmake install

//返回上级目录
# cd ..

//创建用户
# useradd mysql -s /sbin/nologin -M

//解压mysql
# tar xf mysql-5.5.32.tar.gz

//进入mysql目录。并执行以下命令
# cd mysql-5.5.32

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

//安装mysql
# make && make install

//创建软连接(如果是多实例操作到此即可)
# ln -s /application/mysql-5.5.32/ /application/mysql

//退出mysql目录
# cd ..

 

二、配置mysql

//创建配置文件
# cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf -y

//编辑环境变量
# echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile

//即时生效
# source /etc/profile

//用户赋权
# chown -R mysql.mysql /application/mysql/data/

//目录赋权
# chmod -R 1777 /tmp/

 

三、初始化mysql

//进入初始化目录
# cd /application/mysql/scripts/

//初始化mysql
# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

//进入目录
# cd /home/oldboy/tools/mysql-5.5.32

//创建开机自启动文件
# cp support-files/mysql.server /etc/init.d/mysqld

//文件夹赋权
# chmod +x /etc/init.d/mysqld

 

四、登录mysql

//启动mysql服务
# /etc/init.d/mysqld start

//进入mysql
# mysql

//查看是否有空用户
mysql> select user,host from mysql.user;

//删除空用户
mysql> delete from mysql.user where user='';

//删除::1用户
mysql> delete from mysql.user where host='::1';

//删除test库
mysql> drop database test;

//退出mysql
mysql> quit

 

五、设置密码

//添加密码
# /application/mysql//bin/mysqladmin -u root password 'tab123'

//设置开机启动
# chkconfig mysqld on

//测试是否可以进入，密码是否正确
# mysql -uroot -ptab123