1、下载
下载地址:http://dev.mysql.com/downloads/mysql/5.6.html#downloads
下载版本:我这里选择的5.6.33,通用版,linux下64位
也可以直接复制64位的下载地址,通过命令下载:wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
2、解压
#解压
[root@localhost ~]# tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
#复制解压后的mysql目录
[root@localhost ~]# cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql
文件目录如下:
[root@localhost ~]# cd /usr/local/mysql/
[root@localhost mysql]# ls
bin COPYING data docs include lib man mysql-test README scripts share sql-bench support-files
3、添加用户组合用户
#添加用户组
groupadd mysql
#添加用户mysql 到用户组mysql
useradd -g mysql mysql
4、安装
在data目录下新建一个mysql的目录,用于存储mysql的数据文件。
[root@localhost mysql]# cd /usr/local/mysql/
[root@localhost mysql]# mkdir ./data/mysql
修改当前目录拥有者为mysql用户,cp拷贝过来的是是root:root,全部改成mysql:mysql
[root@localhost mysql]# ll
总用量 48
drwxr-xr-x. 2 root root 4096 6月 22 09:42 bin
-rw-r--r--. 1 root root 17987 6月 22 09:42 COPYING
drwxr-xr-x. 4 root root 31 6月 22 09:53 data
drwxr-xr-x. 2 root root 55 6月 22 09:42 docs
drwxr-xr-x. 3 root root 4096 6月 22 09:42 include
drwxr-xr-x. 3 root root 4096 6月 22 09:42 lib
drwxr-xr-x. 4 root root 30 6月 22 09:42 man
drwxr-xr-x. 10 root root 4096 6月 22 09:43 mysql-test
-rw-r--r--. 1 root root 2496 6月 22 09:42 README
drwxr-xr-x. 2 root root 30 6月 22 09:42 scripts
drwxr-xr-x. 28 root root 4096 6月 22 09:42 share
drwxr-xr-x. 4 root root 4096 6月 22 09:42 sql-bench
drwxr-xr-x. 2 root root 136 6月 22 09:42 support-files
[root@localhost mysql]# chown -R mysql:mysql ./
[root@localhost mysql]# ll
总用量 48
drwxr-xr-x. 2 mysql mysql 4096 6月 22 09:42 bin
-rw-r--r--. 1 mysql mysql 17987 6月 22 09:42 COPYING
drwxr-xr-x. 4 mysql mysql 31 6月 22 09:53 data
drwxr-xr-x. 2 mysql mysql 55 6月 22 09:42 docs
drwxr-xr-x. 3 mysql mysql 4096 6月 22 09:42 include
drwxr-xr-x. 3 mysql mysql 4096 6月 22 09:42 lib
drwxr-xr-x. 4 mysql mysql 30 6月 22 09:42 man
drwxr-xr-x. 10 mysql mysql 4096 6月 22 09:43 mysql-test
-rw-r--r--. 1 mysql mysql 2496 6月 22 09:42 README
drwxr-xr-x. 2 mysql mysql 30 6月 22 09:42 scripts
drwxr-xr-x. 28 mysql mysql 4096 6月 22 09:42 share
drwxr-xr-x. 4 mysql mysql 4096 6月 22 09:42 sql-bench
drwxr-xr-x. 2 mysql mysql 136 6月 22 09:42 support-files
安装数据库,执行如下命令
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
到此,mysql数据库安装完毕!
5、启动mysql服务和添加开机启动mysql服务:
把启动脚本放到开机初始化目录,并且把配置文件放到/etc/my.cnf
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# cp support-files/my-default.cnf /etc/my.cnf
启动mysql服务
[root@localhost init.d]# service mysql start
6、添加至环境变量,方便可以在任何地方执行mysql命令
[root@localhost etc]# export PATH=$PATH:/usr/local/mysql/bin
[root@localhost etc]# source /etc/profile
7、修改mysql的root用户密码
root用户初始密码为空的:
执行命令:
[root@localhost mysql]# ./bin/mysqladmin -uroot password 'huangbaokang'
这样就把默认的空密码改成了huangbaokang
8、可能遇到的问题
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
-bash: ./scripts/mysql_install_db: /usr/bin/perl: 坏的解释器: 没有那个文件或目录
解决:安装perl环境
yum -y install perl perl-devel
再次执行报了如下:
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
Data::Dumper
需要执行如下yum install
[root@localhost mysql]# yum install -y perl-Module-Install.noarch
启动服务如果报了如下错:
[root@localhost init.d]# service mysql start
Starting MySQL.touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chmod: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chown: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 129: /var/log/mariadb/mariadb.log: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 166: /var/log/mariadb/mariadb.log: No such file or directory
touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chown: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
chmod: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 129: /var/log/mariadb/mariadb.log: No such file or directory
ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
这个是因为你没有指定他的配置文件的话,他会默认找到/etc/my.cnf 这个配置文件,因为我们修改了mysql的数据存储目录。
[root@localhost mysql]# cp support-files/my-default.cnf /etc/my.cnf
并且配置datadir
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/mysql
保存之后再次运行Success!
[root@localhost etc]# service mysql start
Starting MySQL.. SUCCESS!
专业墙纸贴纸厨房用具装饰出售,本人网店经营,访问即是爱
博客对你有用记得访问下哦,增加下访问量,如有需要可以下单购买哦^_^。店铺地址https://item.taobao.com/item.htm?id=570637716145