linux下安装MySQL5.6(RPM方式)_MySQL

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了linux下安装MySQL5.6(RPM方式)_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5419字，纯文字阅读大概需要8分钟。

内容图文

1、准备对应的安装文件下载页面：http://dev.mysql.com/downloads/mysql/找到对应的版本及所需的文件进行下载，如果下载的为tar文件，请使用tar解压本人在Oracle Edelivery 下载，所以为V44331-01.zip#安装环境[root@linux1 Mysql_src]# cat /etc/issueEnterprise 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.rpmPreparing...                ########################################### [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 1625987A 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/leshamiwhich 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 andwill 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.rpmPreparing...                ########################################### [100%]   1:MySQL-client-advanced  ########################################### [100%][root@linux1 Mysql_src]# rpm -ivh MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpmPreparing...                ########################################### [100%]   1:MySQL-devel-advanced   ########################################### [100%] 4、初始化MySQL及密码 [root@linux1 Mysql_src]# service mysql startStarting 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 -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 2Server version: 5.6.17-enterprise-commercial-advancedmysql> 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 changedmysql> 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 mysqlmysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off如果没有的话使用chkconfig mysql on 设置自启动

内容总结

以上是互联网集市为您收集整理的linux下安装MySQL5.6(RPM方式)_MySQL全部内容，希望文章能够帮你解决linux下安装MySQL5.6(RPM方式)_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---