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 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