How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
来源:互联网 发布:远程端口是什么 编辑:程序博客网 时间:2024/05/22 01:38
the article address : http://sharadchhetri.com/2014/07/31/how-to-install-mysql-server-5-6-on-centos-7-rhel-7/
n CentOS 7/ RHEL 7 , now MariaDB is introduced as a defualt database. Still many Organisations/Company would like to continue with MySQL. Whereas System Admin who earlier worked on MySQL can easily work on MariaDB. MariaDB is a community-developed fork of the MySQL relational database management system.
MariaDB’s lead developer is Michael “Monty” Widenius, the founder of MySQL and Monty Program AB. He had previously sold his company, MySQL AB, to Sun Microsystems for US$1 billion. MariaDB is named after Monty’s younger daughter, Maria. (Reference taken from Wikipedia)
Install MySQL Server 5.6 on CentOS 7 / RHEL 7
Follow the given below steps to install MySQL Server 5.6 .
You must be login with root user in system
Download the Yum Repo package of MySQL Server 5.6
Download the rpm package, which will create a yum repo file for MySQL Server installation.
Install mysql-community-release-el7-5.noarch.rpm package
Install this downloaded rpm package by using rpm command.
After the installation of this package. We will get two new yum repo related to MySQL
Installing MySQL Server
By using yum command, now we will install MySQL Server 5.6 . All dependencies will be installed itself.
How to start/stop/restart MySQL Server
Now MySQL Server is installed on your system.
To start MySQL Service, run command
To stop MySQL Service, run command
To restart MySQL Service, run command
To get status of MySQL Service, run command
Reset MySQL root password
On fresh installation of MySQL Server. The MySQL root user password is blank.
For good security practice, we should reset the password MySQL root user.
On newly installed MySQL Server, we generally recommend to use the command script. You have to just follow the instructions.
In another method,you can log into MySQL server database and reset the password in secure way.
You will see mysql prompt like this mysql> . Use the below given commands to reset root’s password.
- How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
- How to Install LAMP (Apache 2.4, MySQL 5.6, and PHP 5.4) on CentOS/RHEL 7
- Install MySQL Server 5.6 on CentOS 7 / RHEL 7
- How to Install PHP 7 on CentOS/RHEL 7.1 & 6.7
- How to Install Tomcat 7.0.68 Server on CentOS/RHEL 7/6/5
- How to Install MySQL on CentOS 7
- How To Install MySQL on CentOS 7
- How To Install Zabbix Server On CentOS 7
- How To Install Node.js on a CentOS 7 server
- How to Install GUI (Gnome 3) Using CD/DVD on RHEL/CentOS 7
- How to Install Subversion (SVN) 1.8.15 on CentOS/RHEL 7/6/5
- How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22
- How To Install Docker on CentOS 7
- How To Install Openfire On CentOS 7
- How to Install Pip on CentOS 7
- How to Install TestLink on CentOS 7
- How to Install Apache OpenOffice on RHEL/CentOS
- How to Setup DNS ( Bind ) Server on CentOS, RHEL 6
- C++,rand,srand随机数
- 图 - 生成树和最小生成树 - 最小生成树
- LightOj 1020 博弈
- 如何学好C++语言
- [4] 算法之路 - 插入排序之Shell间隔与Sedgewick间隔
- How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
- 《windows核心编程系列》谈谈windows线程栈
- C++程序设计之四书五经(上篇)
- unity3d ios平台优化图形性能
- Java移位操作符
- C++程序设计之四书五经(下篇)
- 发几个比较重要的链接
- HBase如何实现多条件查询
- TCP/IP之四书五经