专栏首页乐沙弥的世界Linux 5 下安装MySQL 5.6(RPM方式)

Linux 5 下安装MySQL 5.6(RPM方式)

    MySQL在很多领域被广泛使用,尤其是很多互联网企业,诸如腾讯,阿里等等。本文主要介绍在Linux 5下通过rpm方式来安装Mysql,这是比较简单的一种安装方式,具体详见下文。

1、准备对应的安装文件 下载页面:http://dev.mysql.com/downloads/mysql/ 找到对应的版本及所需的文件进行下载,如果下载的为tar文件,请使用tar解压 本人在Oracle Edelivery 下载,所以为V44331-01.zip #安装环境 [root@linux1 Mysql_src]# cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r on an \m #源文件路径 [root@linux1 Mysql_src]# pwd /Mysql_src [root@linux1 Mysql_src]# unzip V44331-01.zip Archive:  V44331-01.zip  extracting: MySQL-embedded-advanced-5.6.17-1.rhel5.i386.rpm   extracting: MySQL-test-advanced-5.6.17-1.rhel5.i386.rpm   extracting: MySQL-shared-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL的共享库  extracting: MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm           # MySQL的库和头文件  extracting: MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL客户端程序  extracting: MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL服务端程序  extracting: MySQL-shared-compat-advanced-5.6.17-1.rhel5.i386.rpm   # RHEL兼容包  extracting: README.txt             

2、MySQL默认安装路径  Directory             Contents of Directory /usr/bin               Client programs and scripts /usr/sbin               The mysqld server /var/lib/mysql         Log files, databases /usr/share/info         Manual in Info format /usr/share/man         Unix manual pages /usr/include/mysql     Include (header) files /usr/lib/mysql         Libraries /usr/share/mysql       Miscellaneous support files, including error messages,                         character set files, sample configuration files, SQL for database installation /usr/share/sql-bench   Benchmarks

3、安装MySQL [root@linux1 Mysql_src]# rpm -ivh MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-server-advanced  ########################################### [100%] 2014-04-15 17:26:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-15 17:26:59 6524 [Note] InnoDB: Using mutexes to ref count buffer pool pages                    ........................... 2014-04-15 17:27:06 6558 [Note] InnoDB: FTS optimize thread exiting. 2014-04-15 17:27:06 6558 [Note] InnoDB: Starting shutdown... 2014-04-15 17:27:08 6558 [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

#  Author : Leshami #  Blog   : http://blog.csdn.net/leshami

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

                  ...........中间省略................ 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@linux1 Mysql_src]# rpm -ivh MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-client-advanced  ########################################### [100%]

[root@linux1 Mysql_src]# rpm -ivh MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm Preparing...                ########################################### [100%]    1:MySQL-devel-advanced   ########################################### [100%]

4、初始化MySQL及密码 [root@linux1 Mysql_src]# service mysql start Starting MySQL..                                           [  OK  ] [root@linux1 Mysql_src]# more /root/.mysql_secret # The random password set for the root user at Tue Apr 15 17:27:05 2014 (local time): lyHfNb87EBXhJDe2

[root@linux1 Mysql_src]# mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.17-enterprise-commercial-advanced

mysql> set PASSWORD=PASSWORD('mysql'); Query OK, 0 rows affected (0.01 sec)

mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | test               | +--------------------+ 4 rows in set (0.03 sec)

5、允许远程登陆 mysql> use mysql; Database changed mysql> select host,user,password from user; +-------------------+------+-------------------------------------------+ | host              | user | password                                  | +-------------------+------+-------------------------------------------+ | localhost         | root | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA | | linux1.orasrv.com | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | | 127.0.0.1         | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | | ::1               | root | *AE207AEF7D22B37183E435AAE64CECF7102A2DB2 | +-------------------+------+-------------------------------------------+ 4 rows in set (0.02 sec)

mysql> update user set password=password('mysql') where user='root'; mysql> update user set host='%' where user='root' and host='localhost'; mysql> flush privileges; mysql> exit

6、配置开机自启动 [root@linux1 Mysql_src]# chkconfig --list mysql mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off 如果没有的话使用chkconfig mysql on 设置自启动

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • MySQL数据库数据迁移到SQLserver

    Leshami
  • MySQL MHA配置常见问题

        MHA在MySQL数据库中被广泛使用,它小巧易用,功能强大,实现了基于MySQL replication架构的自手动主从故障转移,从库重定向到主库并自动...

    Leshami
  • 基于 Linux 安装glibc版mysql 5.7.12

    Leshami
  • Win10安装MySQL5.7.22 解压缩版(手动配置)方法

    1.下载地址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads

    凯哥Java
  • 富文本AttributedString的总结

    AttributedString可以分为NSAttributedString和NSMutableAttributedString两种。 在使用中通过将Attri...

    剑行者
  • OL记载Arcgis Server切片

    在OpenLayers中加载Arcgis Server切片用XYZ图层,Arcgis Server的切片调用地址我们可以看到如下:

    lzugis
  • [Python技巧]是时候用 defaultdict 和 Counter 代替 dictionary 了

    我们在采用 dict 的时候,一般都需要判断键是否存在,如果不存在,设置一个默认值,存在则采取其他的操作,但这个做法其实需要多写几行代码,那么是否有更高效的写法...

    材ccc
  • 12 条用于 Linux的MySQL/MariaDB 安全最佳实践

    英文:tecmint,译文:oschina www.oschina.net/translate/mysql-mariadb-security-best-prac...

    企鹅号小编
  • 重新设置Eclipse的workspace路径

    1. 启动Eclipse/MyEclipse后, 打开"Window -> Preferences -> General -> Startup and Shut...

    ydymz
  • [译]逐步替换Scss

    这是一篇介绍现代 css 核心特性的文章,并且借助 sass 进行横向对比,充分体现了 css 作为一门设计语言的快速发展以及新特性为我们开发者带来的强大生产力...

    心谭博客

扫码关注云+社区

领取腾讯云代金券