一、准备工作
注：由于是在一台已经存在并经过多方使用的服务器上安装，所以需要先确认下该台服务器上是否已经安装Mysql
1、groupadd mysql 时提示 mysql 已存在，useradd -g mysql mysql 时也提示已存在，基本上可以确认已经安装过mysql；
切换到mysql下查看mysql进程，结果显示没有则表示当前 mysql 未启动；
输入 mysql start 时出现错误提示：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)， 先不研究这个错误了，准备重新安装mysql。
输入 rpm -qa|grep mysql ，无任何信息显示，表明之前不是以这种方式安装的，则不需要卸载，直接进行新的安装。
2、系统环境确认：
输入命令： uname -a 得到信息如下： Linux localhost.localdomain 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux ，表明系统是32位；
3、下载Mysql 安装包：
从官网（http://www.mysql.com/downloads/mysql/ ）下载相应的安装包（我的是 mysql-5.1.51-linux-i686-glibc23.tar.gz）；
二、安装
1、新建 mysql 组和用户（已建，略过）；
2、用 root 用户给 mysql 安装路径授权，依次执行：
MYSQL_BASE=/opt/mysql mkdir -p $MYSQL_BASE/product/5.1 mkdir -p $MYSQL_BASE/mysqldata/mysqllog mkdir -p /var/run/mysqld/ mkdir -p /etc/mysql chmod -R 777 $MYSQL_BASE chown -R mysql:mysql $MYSQL_BASE chown -R mysql:mysql /etc/mysql chown -R mysql:mysql /var/run/mysqld/
注：以上路径是我准备安装 mysql 的路径，部分路径与实际环境相关
3、切换到mysql 用户，设置 mysql 用户环境变量：编辑 /home/mysql/.bash_profile 文件，增加如下内容：
export MYSQL_BASE=/opt/mysql export BASEDIR=$MYSQL_BASE/product/5.1 export DATADIR=$MYSQL_BASE/mysqldata export LD_LIBRARY_PATH=$BASEDIR/lib:/lib:/usr/lib:/usr/local/lib export TMPDIR=/tmp export PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=$PATH:$BASEDIR/bin:$MYSQL_BASE:$BASEDIR:$LD_LIBRARY_PATH
4、将安装包上传到 mysql 用户主目录下，依次执行：
cd $BASEDIR tar -zxvf /home/mysql/mysql-5.1.51-linux-i686-glibc23.tar.gz cd $BASEDIR cd mysql-5.1.51-linux-i686-glibc23 mv * ../ cd .. rm -r mysql-5.1.51-linux-i686-glibc23
5、开始安装 mysql：
1) 执行：
cd $BASEDIR ./scripts/mysql_install_db --basedir=$BASEDIR --datadir=$DATADIR --user=mysql
出现类似如下文字则表示成功：
Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /opt/mysql/product/5.1/bin/mysqladmin -u root password 'new-password' /opt/mysql/product/5.1/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' Alternatively you can run: /opt/mysql/product/5.1/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /opt/mysql/product/5.1 ; /opt/mysql/product/5.1/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /opt/mysql/product/5.1/mysql-test ; perl mysql-test-run.pl Please report any problems with the /opt/mysql/product/5.1/scripts/mysqlbug script!
2) 切换到 root 用户， 依次执行：
cd /opt/mysql/product/5.1 cp ./support-files/my-medium.cnf /etc/my.cnf cp ./support-files/mysql.server /etc/init.d/mysql chkconfig --add mysql chkconfig --level 345 mysql on
3) 编辑 /etc/my.cnf 文件，找到如下片段：
[mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M
在下面增加：
user = mysql pid-file = /var/run/mysqld/mysqld.pid basedir = /opt/mysql/product/5.1 datadir = /opt/mysql/mysqldata lower_case_table_names = 1 default-storage-engine = INNODB innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:1000M:autoextend innodb_autoextend_increment = 64 innodb_file_per_table = 1 innodb_data_home_dir = /opt/mysql/mysqldata innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 8M innodb_log_file_size = 512M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 40 innodb_lock_wait_timeout = 120 innodb_locks_unsafe_for_binlog = 1 innodb_autoinc_lock_mode = 2
修改 [client] 和 [mysqld] 下的 socket 那行为：
socket = /var/run/mysqld/mysqld.sock
注：Linux环境是区分大小写的，所以要加 lower_case_table_names = 1 这个配置
about lower_case_table_names:
0 - table names are stored as specified and comparisons are case sensitive.
1 - table names are stored in lowercase on disk and comparisons are not case sensitive.
2 - table names are stored as given but compared in lowercase. This option also applies to database names and table aliases.
4) 启动mysql， 用 mysql 用户执行： /etc/init.d/mysql start 显示：
Starting MySQL........................................................[ 确定 ]
则表示启动成功。
执行 ps ux 进行查看，有类似如下进程：
/opt/mysql/product/5.1/bin/mysqld --basedir=/opt/mysql/product/5.1 --datadir=/opt/mysql/mysqldata --user=mysql2 --log-error=/opt/mysql/mysqldata/localhost.localdomain.err --open-files-limit=8192 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
如需关闭数据库，则执行： /etc/init.d/mysql stop
三、初始设置
1、设置数据库root用户密码：
/opt/mysql/product/5.1/bin/mysqladmin -u root password 'new-password' /opt/mysql/product/5.1/bin/mysqladmin -u root -p -h localhost.localdomain password 'new-password'
四、创建数据库
1、新建数据库用户 test ，密码也是 test，依次执行：
mysql -u root -p
mysql> insert into mysql.user(Host,User,Password) values("localhost","test",password("test"));
mysql> flush privileges;
mysql> exit;
2、创建数据库 testdb，并赋予 test 用户操作修改该数据库的权限，依次执行：
mysql -u root -p mysql> create database testdb default character set utf8; mysql> grant all privileges on testdb.* to test@localhost identified by 'test'; mysql> flush privileges; mysql> exit;
3、用 test 用户登录，创建数据表等：
mysql -u test -p mysql> use testdb; ...
至此，基本完成。
评论