MySql安装

a3865571

                               
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 'user'@'localhost' IDENTIFIED BY 'some_pass'
WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'some_pass' WITH
GRANT OPTION;
SET PASSWORD FOR 'user'@'localhost' = OLD_PASSWORD('password');
SET PASSWORD FOR 'user'@'%' = OLD_PASSWORD('password');

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
         long_query_time = 2
         skip-name-resolve
         #log-bin=mysql-bin
        
#server-id = 1
               
               
               
               
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/104003/showart_2050393.html