mysql安装

 

一、mysql在liunx下源码安装

 

1. 查看cent os版本以及linux内核版本：

[root@localhost opt]# lsb_release -a
LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description:    CentOS release 5.2 (Final)
Release:        5.2
Codename:       Final
[root@localhost opt]# uname -a
Linux localhost.localdomain 2.6.18-92.el5 #1 SMP Tue Jun 10 18:49:47 EDT 2008 i686 i686 i386 GNU/Linux

2.查看是否安装：
[root@localhost ywmTemp]$ rpm -qa | grep mysql

 

3.下载mysql(mysql-5.1.36.zip)并解压：
[root@localhost opt]# unzip mysql-5.1.36.zip

 

4.进入解压后的mysql包目录(mysql-5.1.36)
[root@localhost opt]# cd mysql-5.1.36

 

5.安装配置：
[root@localhost mysql-5.1.36]# ./configure --prefix=/opt/mysql --with-extra-charsets=all

...

Thank you for choosing MySQL!

 

6.make：
[root@localhost mysql-5.1.36]# make

...
Making all in win
...

 

7.make install：
[root@localhost mysql-5.1.36]# make install

...
Making install in win
...

8.配置sh环境中添加MYSQL_HOME，$MYSQL_HOME/bin到path中：
[root@localhost mysql-5.1.36]# vi ~/.bash_profile

 

如：
MYSQL_HOME=/opt/mysql
 
export MYSQL_HOME
 
PATH=$PATH:$HOME/bin:$MYSQL_HOME/bin
 
export PATH

 

9.生效配置sh环境：
[root@localhost mysql-5.1.36]# source ~/.bash_profile

 

10.查看环境是否生效：
[root@localhost mysql-5.1.36]# echo $PATH

 

11.增加mysql配置：
[root@localhost mysql-5.1.36]# vi /etc/my.cnf
 
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8
 
[mysqld]
basedir = /opt/mysql
datadir = /opt/mysql/data
socket = /tmp/mysql.sock
log-error = /opt/mysql/data/alert.log
log_slow_queries = /opt/mysql/data/slow.log
port = 3306
default-character-set = utf8

 

12.添加mysql组、用户、文件目录、并把文件目录赋予用户
[root@localhost mysql-5.1.36]# groupadd mysql
[root@localhost mysql-5.1.36]# useradd -g mysql mysql
[root@localhost mysql-5.1.36]# passwd mysql
New UNIX password: 123456
BAD PASSWORD: it is too simplistic/systematic
Retype new UNIX password: 123456
passwd: all authentication tokens updated successfully.
[root@localhost mysql-5.1.36]# mkdir /opt/mysql/data
[root@localhost mysql-5.1.36]# chown -R mysql.mysql /opt/mysql/data

 

13.su到mysql用户上并安装数据库：
[root@localhost mysql-5.1.36]# su - mysql
[mysql@localhost ~]$ mysql_install_db --user=mysql
Installing MySQL system tables...
...

 

14.启动数据库(<mysql_path>/bin/mysqld_safe --defaults-file=<conf_path>/XXX.cnf --user=XXX&)：

[mysql@localhost ~]$ mysqld_safe &

 

15.参看数据库进程：
[mysql@localhost ~]$ ps -ef | grep mysql

 

16.修改/etc/selinux/config、/etc/sysconfig/selinux中SELINUX为disable(修改后才能mysql客户端连接数据库)：
[root@localhost mysql]# vi /etc/selinux/config

 

17.mysql客户端连接数据库(mysql -h ip -P port -u user -ppassword)：
[mysql@localhost ~]$ mysql -u root

创建用户并授权：grant all on *.* to 'yangwm'@'%' Identified by '123456';

 

18.关闭数据库(<mysql_path>/bin/mysqladmin shutdown -S /tmp/mysql<port>.sock)：

[mysql@localhost ~]$ mysqladmin shutdown -S /tmp/mysql3306.sock

 

 

二、mysql在windows下zip包安装(详细配置参见mysql linux安装),  

1. 配置MYSQL_HOME，%MYSQL_HOME%/bin到path中

2.增加mysql配置my.cnf：

3. 加入到Windows XP的服务中(需在mysql_base/bin下)：

D:/Program Files/mysql-5.5.8-win32/bin> mysqld -install

 

4. 启动mysql服务

D:> net  start mysql

 

5. 停止mysql服务 
D:> net  stop  mysql

6. 移出mysql服务
D:/Program Files/mysql-5.5.8-win32/bin> mysqld --remove

参考资料：

http://dev.mysql.com/doc/refman/5.5/en/binary-installation.html