1),进入mysql官网http://downloads.mysql.com/archives/community/下载编译好的二进制安装包。
2),在目录/usr/local下,执行命令:tar -zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz解压安装包。
3),添加系统mysql用户组及用户
执行命令:groupadd mysql和useradd -r -g mysql mysql。
4),(1)执行命令: cd /usr/local 进入安装MySQL软件目录;
(2)执行命令:mv mysql-5.6.16-linux-glibc2.5-x86_64 mysql重命名解压后的文价夹为mysql;
(3)执行命令:cd /usr/local/mysql 进入mysql安装目录;
(4)执行命令: chown -R mysql:mysql ./修改当前目录拥有者为mysql用户;
(5)执行命令: ./scripts/mysql_install_db--user=mysql 安装数据库;
(6)执行命令: chown -R root:root ./ 修改当前目录拥有者为root用户;
(7)执行命令: chown -R mysql:mysql ./data修改当前data目录拥有者为mysql用户;
5、启动mysql服务并添加开机启动mysql服务.
(1)执行命令:cd /usr/local/mysql/support-files;
(2)执行命令cp my-medium.cnf /etc/my.cnf;cp mysql.server/etc/init.d/mysqld 或执行命令cp my-default.cnf/etc/my.cnf;cp mysql.server /etc/init.d/mysqld;
(3)修改/etc/my.cnf和/etc/init.d/mysqld文件内容,将文件内容中所有的默认配置路径/usr/local/mysql替换为mysql的安装目录;
(4)执行命令:service mysqld start启动mysql服务;
5)执行命令:ps -ef|grep mysql 看到mysql服务说明启动成功,如图:
7、把mysql客户端放到默认路径
执行命令:ln -s /usr/local/mysql/bin/mysql/usr/local/bin/mysq
8、配置mysql远程访问权限
(1)执行命令:/usr/local/mysql/bin/mysql -u root -p,输入登录密码,进入mysql;
(2)执行命令:use mysql; 注意这里分号也是命令的一部分;
(3)创建远程登录用户并授权:
创建用户,create user test identified by '123456';
添加权限,grant all privileges on *.* to 'test'@'%'identified by '123456' with grant option;
刷新权限,flush privileges ;
出现执行scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqldb命令时一直报错:
Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at scripts/mysql_install_db line 42.BEGIN failed--compilation aborted at scripts/mysql_install_db line 42.
原因是Fedora 19中yum的prel包中没有Dumper.pm文件。这时候只要执行以下命令就可以手动下载Dumper.pm文件
yum install 'perl(Data::Dumper)'