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

平台：

RHEL 5 CentOS 5

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

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

[root@localhost ~]#

groupadd mysql

[root@localhost ~]#

usera

dd -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 /us

r/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 mysql

data

[root@localhost mysql]#

chgrp -R mysql .

[root@localhost

mysql

]#

/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