linux下安装mysql

1.     编译安装（cmake-2.8.10.1.tar.gz）

1)    解压缩 

[root@promote software]#tar -zxvf cmake-2.8.10.1.tar.gz 

生成cmake-2.8.10.1

2)    进入cmake-2.8.10.1

[root@promote software]# cd cmake-2.8.10.1

[root@promote software]# yum -y install gcc
[root@promote software]#yum -y install gcc-c++
[root@promote software]#yum -y install ncurses-devel

[root@promote software]# mkdir /home/mysqlcmake

[root@promote cmake-2.8.10.1]# ./configure --prefix=/home/mysqlcmake/cmake_exe

[root@promote cmake-2.8.10.1]#make       

[root@promote cmake-2.8.10.1]#make install

[root@promote cmake-2.8.10.1]#export PATH=/home/mysqlcmake/cmake_exe/bin:$PATH 

3)    安装成功cmake编译器

2.     安装配置mysql（mysql-5.6.4-m7.tar.gz）

1)    创建用户组和用户

# groupadd mysql

# useradd mysql

2)    创建mysql安装目录

# make clean
# rm -f  CMakeCache.txt

# rm -rf /etc/my.cnf（由于是删除了系统自带的mysql，重新安装需要删除my.cnf）

# mkdir /usr/local/mysql

# mkdir /usr/local/mysql/data

3)    解压缩

[root@promote software]# tar -zxvf mysql-5.6.4-m7.tar.gz

              生成mysql-5.6.4-m7

              进入mysql-5.6.4-m7

              [root@promote software]# cd mysql-5.6.4-m7

               [root@promote mysql-5.6.4-m7]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DINSTALL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1

               如何出现以下错误：

需再次执行：

[root@promote cmake-2.8.10.1]#export PATH=/home/mysqlcmake/cmake_exe/bin:$PATH 

              [root@promote mysql-5.6.4-m7]# make

               [root@promote mysql-5.6.4-m7]# make install

4)    设置权限

#chown -R mysql:mysql /usr/local/mysql           

#chmod -R 775 /usr/local/mysql

[root@promote mysql-5.6.4-m7]# cd /usr/local/mysql

[root@promote mysql]# chown –R mysql .

[root@promote mysql]# chgrp –R mysql .

[root@promote mysql]#chmod +x /usr/local/mysql

 [root@promote mysql]#chown -R mysql:mysql data

[root@promote mysql]# visudo

在“root    ALL=(ALL)              ALL  ”

这一行下面加上:  

 “ mysql     ALL=(ALL)          ALL    ”    

赋予它root用户所有的权限

5)  复制配置文件

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

6)  修改my.cnf配置

打开如下注释：

innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data

innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

        [mysqld]添加：
              datadir=/usr/local/mysql/data
              default-storage-engine=MyISAM
              log-error = /usr/local/mysql/mysql_error.log  
              pid-file = /usr/local/mysql/mysql.pid  
              user = mysql  
              tmpdir = /tmp

3.     启动MySQL

设置环境变量：

# vi /root/.bash_profile

在PATH=$PATH:$HOME/bin添加参数为：

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/lib

#source /root/.bash_profile

手动启动MySQL（启动mysql无需切换至mysql用户，直接在root用户下进行手动启动即可，也可以在mysql用户下启动）： 

# cd /usr/local/mysql/

# /usr/local/mysql/bin/mysqld_safe &

启动日志写在此文件下：/usr/local/mysql/data/localhost.err

关闭MySQL:

[root@promote mysql]# mysqladmin -u root -p shutdown

配置开机自启动（此项未验证）

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
# chmod +x /etc/init.d/mysql
# chkconfig --list
# update-rc.d mysql defaults  (/sbin/chkconfig --add mysql ; /sbin/chkconfig mysql on)
# chkconfig --list mysql

1)  安装默认数据表(数据库需处于启动状态)

切换到mysql用户

# su – mysql

# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

可以通过以下命令增加root用户的密码：

/usr/local/mysql/bin/mysqladmin -u root password '8888'

4.     测试MySQL是否启动

查看端口是否运行
       netstat -tnl | grep 3306

     检查进程

5.    登录mysql

使用root用户登录

输入mysql -u root –p

输入密码

看到以上信息表示mysql已安装成功。

客户端如果需要远程操作mysql数据库，需要对该数据库进行授权才能连接：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '8888' WITH GRANT OPTION;

以上为root用户使用密码8888从任何主机连接到mysql服务器。