1.安装MySQL
1.1上传MYSQL二进制软件包到指定的目录
# cd /home/oldboy/tools/
# rz -y(上传MYSQL数据库的二进制软件包到该目录下)
1.2 创建mysql用户和组
# useradd mysql -s /sbin/nologin -M
1.4 解压数据库软件包并初始化数据库
# tar xf mysql-5.5.32-linux2.6-x86_64.tar.gz
# mv mysql-5.5.32-linux2.6-x86_64 /application/mysql
或者(# ln -s /home/oldboy/tools/mysql-5.5.32-linux2.6-x86_64/
/application/mysql)
# cd /application/mysql/
# mkdir /application/mysql/data
# chown -R mysql.mysql /application/mysql/data
# ./scripts/mysql_install_db --user=mysql --basedir=/application/mysql/ -- datadir=/application/mysql/data/
# cp support-files/mysql.server /etc/init.d/mysqld
# cp support-files/my-small.cnf /etc/my.cnf
# chmod +x /etc/init.d/mysqld
# vim /etc/init.d/mysqld
#修改mysql配置文件如下内容
basedir=/application/mysql
datadir=/application/mysql/data
#保存退出后，重新启动MYSQL数据库
# killall mysqld
# /etc/init.d/mysqld start
1.5 给数据库设置管理员密码
# /application/mysql//bin/mysqladmin -u root password 'wpaccp123'
# mysql -uroot -pwpaccp123
1.6 配置MYSQL启动命令的环境变量
# echo "PATH=/application/mysql/bin:$PATH" >>/etc/profile
# . /etc/profile
或者：(# cp /application/mysql/bin/* /usr/local/sbin/)
1.7 数据库优化
# mysql -uroot -pwpaccp123
mysql> drop database test;
mysql> select user,host from mysql.user
mysql> drop user ''@'wpaccp';
mysql> drop user 'root'@'wpaccp';
mysql> drop user ''@'localhost'
mysql> drop user 'root'@'::1';
mysql> select user,host from mysql.user
提示：如果使用drop命令无法删除用户记录，需要使用delete命令在mysql.user表下删除某项记录
1.8 安装过程中出现的常见错误
故障1:当使用mysql命令登陆进MYSQL数据库时，出现以下错误
ERROR 2002 (HY000): Can't connect to local Mysql server through socket '/var/lib/mysql/mysql.sock'
解决办法：
从故障的显示信息上看，是没有指定MYSQL的配置文件
# cp support-files/my-small.cnf /etc/my.cnf
# /etc/init.d/mysqld start
故障2:当执行./scripts/mysql_install_db --user=mysql --basedir=/application/mysql/ -- datadir=/application/mysql/data/
这个命令时，出现以下故障现象
......
/application/mysql/bin/mysqld: error while loading share libraries:
libaio.so.1:cannot open share object file:No such file or directory
......
解决办法
# find / -name "libaio.so.1"
# yum install libaio-devel -y
故障3:当执行/etc/init.d/mysqld start后,出现以下故障现象
Starting MySQL.. ERROR! The server quit without updating PID file
(/application/mysql/data/client.pid)
解决办法：
1)初始化有问题，最好重新初始化数据库
2)启动时，用来不同的程序启动
3)没有配置文件
方法一：
# /application/mysql/bin/mysqld_safe &
# mysqladmin shutdown
故障4:当执行./scripts/mysql_install_db --user=mysql --basedir=/application/mysql/ -- datadir=/application/mysql/data/
时出现以下故障现象
......
ERROR: 1004 Can't reate file '/tmp/#sql61d_1_0.frm'(errno:13)
解决方法：
# chmod -R 4777 /tmp
故障5 当执行mysql -u root -p mysql命令登陆数据库时出现以下故障现象
ERROR 1045 (28000): Access denied for user 'root'@localhost (using password YES)
解决办法：
初始化DB不正常
# rm -rf /application/mysql/data/
# cd /application/mysql/
# ./scripts/mysql_install_db --user=mysql --basedir=/application/mysql/ -- datadir=/application/mysql/data/
故障6:当执行./mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data命令初始化数据库时.报错
[root@mysql-db2 scripts]# ./mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
FATAL ERROR: please install the following Perl modules before executing ./mysql_install_db:
Data::Dumper
解决办法:
[root@mysql-db2 scripts]# yum -y install autoconf
