mysql二进制方式_MySQL二进制方式安装

平台：RHEL 5 CentOS 5

软件包：mysql-5.0.45-linux-i686.tar.gz

1、建立mysql组名和mysql用户名

[root@localhost ~]#groupadd mysql

[root@localhost ~]#useradd -g mysql -s /sbin/nologin mysql

2、安装mysql

[root@localhost ~]# cd /home/software

[root@localhost software]#tar zvf /home/software/mysql-5.0.45-linux-i686.tar.gz

[root@localhost software]#mv mysql-5.0.45-linux-i686 /usr/local/mysql

[root@localhost software]# cd /usr/local/mysql

[root@localhost mysql]#cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

设置：安装完以后要初始化数据库【重点】

[root@localhost mysql]#chown -R root .

[root@localhost mysql]#chown -R mysqldata

[root@localhost mysql]#chgrp -R mysql .

[root@localhostmysql]#/usr/local/mysql/scripts/mysql_install_db --user=mysql//重点

3、设置自启动

[root@localhost mysql]#cp /usr/local/mysql/support-files/mysql.server/etc/rc.d/init.d/mysqld

[root@localhost mysql]#chmod 755 /etc/rc.d/init.d/mysqld

[root@localhost mysql]#chkconfig -level 2345 /etc/rc.d/init.d/mysqld on

4、启动mysql服务

[root@localhost mysql]#/usr/local/mysql/bin/mysqld_safe --user=mysql&

5、修改root用户的初始化密码

[root@localhost mysql]#./bin/mysqladmin -uroot password'rs'

6、进入mysql

[root@localhost ~]# /usr/local/mysql/bin/mysql -uroot -p

Enter password://输入密码

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.0.45 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

授权用户访问权限

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

SET PASSWORD FOR 'dev'@'localhost' = OLD_PASSWORD('dev');

SET PASSWORD FOR 'dev'@'%' = OLD_PASSWORD('dev');

7、修改data目录为/var/mysqldata/data

[root@localhost ~]# mkdir /var/mysqldata

[root@localhost ~]# chgrp mysql /var/mysqldata -R

[root@localhost ~]# cp -R -p /usr/local/mysql/data /var/mysqldata

[root@localhost ~]# vi /etc/my.cnf

[client]

default-character-set=utf8

[mysqld]

basedir=/usr/local/mysql

datadir=/var/mysqldata/data

default-character-set=utf8

#log-slow-queries=/var/mysqldata/log_slowquery.txt

long_query_time = 2

skip-name-resolve

#log-bin=mysql-bin

#server-id = 1