centos安装mysql5.6

前端之家收集整理的这篇文章主要介绍了centos安装mysql5.6前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

1.下载去MysqL官方网站下载安装包

http://dev.MysqL.com/downloads/MysqL/5.6.html#downloads


因为centos源码属于redhat所以这里选择Red Hat, 下面根据自己系统的版本选择对应的tar包,我的系统是64位 所以选择

Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86,64-bit),RPM Bundle 这个版本

下载需要有oracle账号,怎么注册这里就不描述了

2.检查是否已安装,grep的-i选项表示匹配时忽略大小写

[root@JUSHENG-WEB]#rpm -qa|grep -i MysqL


可见已经安装了库文件,应该先卸载,不然会出现覆盖错误。注意卸载时使用了--nodeps选项,忽略了依赖关系:

a)卸载MysqL

[root@JUSHENG-WEB]#rpm -e MysqL-community-server-5.7.17-1.el6.x86_64--nodeps

[root@JUSHENG-WEB]#rpm -eMysqL-community-client-5.7.17-1.el6.x86_64--nodeps


b)删除MysqL服务

[root@localhost local]# chkconfig --list | grep -i MysqL
[root@localhost local]# chkconfig --del MysqL

c)删除分散MysqL文件

[root@localhost local]# whereis MysqL 或者find / -name MysqL

MysqL: /usr/lib/MysqL /usr/share/MysqL

清空相关MysqL的所有目录以及文件
rm -rf /usr/lib/MysqL
rm -rf /usr/share/MysqL

rm -rf /usr/my.cnf

接着还要做一件事情

#cd /var/lib 检查该目录下是否存在MysqL文件夹 如果存在删掉,否者MysqL不会正常安装(这个很重要)

3,将下载的文件上传到/usr/local目录下 使用

#tar -xvf MysqL-5.6.35-1.el6.x86_64.rpm-bundle.tar 命令解压 注意这里使用-zxvf的话可能会报错

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error is not recoverable: exiting now

这个错误的大概意思是压缩文件被人为的改过名称,比如:最初压缩的并非.gz,被人为的修改了后缀,这时可以去掉后缀再解压,如:文件FMIS2600DMP.tar.gz,去掉gz后缀,再用tar -xvf 解压


解压后可以得到这7个文件,如下:

其中只有MysqL-server-5.6.35-1.el6.x86_64.rpm和MysqL-client-5.6.35-1.el6.x86_64.rpm这两个文件是我们需要的

[JUSHENG-WEB]# rpm -ivh MysqL-server-5.6.35-1.el6.x86_64.rpm


[root@JUSHENG-WEB src]# rpm -ivh MysqL-server-5.6.35-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MysqL-server ########################################### [100%]
2017-01-10 11:23:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-10 11:23:27 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-01-10 11:23:27 0 [Note] /usr/sbin/MysqLd (MysqLd 5.6.35) starting as process 3342 ...
2017-01-10 11:23:27 3342 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-01-10 11:23:27 3342 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-10 11:23:27 3342 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-10 11:23:27 3342 [Note] InnoDB: Memory barrier is not used
2017-01-10 11:23:27 3342 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-10 11:23:27 3342 [Note] InnoDB: Using Linux native AIO
2017-01-10 11:23:27 3342 [Note] InnoDB: Using cpu crc32 instructions
2017-01-10 11:23:27 3342 [Note] InnoDB: Initializing buffer pool,size = 128.0M
2017-01-10 11:23:27 3342 [Note] InnoDB: Completed initialization of buffer pool
2017-01-10 11:23:27 3342 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-01-10 11:23:27 3342 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-01-10 11:23:27 3342 [Note] InnoDB: Database physically writes the file full: wait...
2017-01-10 11:23:28 3342 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-01-10 11:23:29 3342 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-01-10 11:23:30 3342 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-01-10 11:23:30 3342 [Warning] InnoDB: New log files created,LSN=45781
2017-01-10 11:23:30 3342 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-01-10 11:23:30 3342 [Note] InnoDB: Doublewrite buffer created
2017-01-10 11:23:30 3342 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-10 11:23:30 3342 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-01-10 11:23:30 3342 [Note] InnoDB: Foreign key constraint system tables created
2017-01-10 11:23:30 3342 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-01-10 11:23:30 3342 [Note] InnoDB: Tablespace and datafile system tables created.
2017-01-10 11:23:30 3342 [Note] InnoDB: Waiting for purge to start
2017-01-10 11:23:30 3342 [Note] InnoDB: 5.6.35 started; log sequence number 0
A random root password has been set. You will find it in '/root/.MysqL_secret'.
2017-01-10 11:23:32 3342 [Note] Binlog end
2017-01-10 11:23:32 3342 [Note] InnoDB: FTS optimize thread exiting.
2017-01-10 11:23:32 3342 [Note] InnoDB: Starting shutdown...
2017-01-10 11:23:34 3342 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2017-01-10 11:23:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-10 11:23:34 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-01-10 11:23:34 0 [Note] /usr/sbin/MysqLd (MysqLd 5.6.35) starting as process 3364 ...
2017-01-10 11:23:34 3364 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-01-10 11:23:34 3364 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-10 11:23:34 3364 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-10 11:23:34 3364 [Note] InnoDB: Memory barrier is not used
2017-01-10 11:23:34 3364 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-10 11:23:34 3364 [Note] InnoDB: Using Linux native AIO
2017-01-10 11:23:34 3364 [Note] InnoDB: Using cpu crc32 instructions
2017-01-10 11:23:34 3364 [Note] InnoDB: Initializing buffer pool,size = 128.0M
2017-01-10 11:23:34 3364 [Note] InnoDB: Completed initialization of buffer pool
2017-01-10 11:23:34 3364 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-10 11:23:34 3364 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-10 11:23:34 3364 [Note] InnoDB: Waiting for purge to start
2017-01-10 11:23:34 3364 [Note] InnoDB: 5.6.35 started; log sequence number 1625977
2017-01-10 11:23:35 3364 [Note] Binlog end
2017-01-10 11:23:35 3364 [Note] InnoDB: FTS optimize thread exiting.
2017-01-10 11:23:35 3364 [Note] InnoDB: Starting shutdown...
2017-01-10 11:23:36 3364 [Note] InnoDB: Shutdown completed; log sequence number 1625987


A RANDOM PASSWORD HAS BEEN SET FOR THE MysqL root USER !
You will find that password in '/root/.MysqL_secret'.


You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.


Also,the account for the anonymous user has been removed.


In addition,you can run:


/usr/bin/MysqL_secure_installation


which will also give you the option of removing the test database.
This is strongly recommended for production servers.


See the manual for more instructions.


Please report any problems at http://bugs.MysqL.com/


The latest information about MysqL is available on the web at


http://www.MysqL.com


Support MysqL by buying support/licenses at http://shop.MysqL.com


New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

[root@JUSHENG-WEB]# rpm -ivh MysqL-client-5.6.35-1.el6.x86_64.rpm

[root@JUSHENG-WEB src]# rpm -ivh MysqL-client-5.6.35-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MysqL-client ########################################### [100%]

好了安装完毕

MysqL服务器安装之后虽然配置了相关文件,但并没有自动启动MysqLd服务,需自行启动:

[root@JUSHENG-WEB src]#service MysqL start

Starting MysqL.. SUCCESS!

可通过检查端口是否开启来查看MysqL是否正常启动:

root@JUSHENG-WEB src]#netstat -anp|grep 3306

tcp 00 0.0.0.0:33060.0.0.0:* LISTEN 34693/MysqLd

4.登录

#MysqL -uroot -p 结果无法登录,很多小伙伴们到这里就蒙了怎么没法登录MysqL的root的默认密码不是空的吗 其实仔细看前面安装server的日志信息会发现5.6已经调整了这个问题,安装后它会生成一个初始密码在/root/.MysqL_secret文件

[root@JUSHENG-WEB ~]# cat /root/.MysqL_secret
# The random password set for the root user at Tue Jan 10 11:23:31 2017 (local time): aGwZeky15Z53ZCGq

现在在使用密码登录看看

#MysqL -uroot -paGwZeky15Z53ZCGq ok正常登录


5.修改MysqL的root用户的密码以及打开远程连接

MysqL> use MysqL;
MysqL> desc user;
MysqL> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力
MysqL> update user set Password = password('root') where User='root'; //设置root用户密码
MysqL> select Host,User,Password from user where User='root';
MysqL> flush privileges;
MysqL> exit


6.开放3306端口

#vi /etc/sysconfig/iptables 添加下面这段

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT


#service iptables restart重启防火墙

原文链接:https://www.f2er.com/centos/379092.html

猜你在找的CentOS相关文章