redhat7安装mysql-server(mysqld)
来源:互联网 发布:淘宝登录名可以修改吗 编辑:程序博客网 时间:2024/06/05 05:34
折腾…………原文地址:
http://sharadchhetri.com/2014/07/31/how-to-install-mysql-server-5-6-on-centos-7-rhel-7/
--------------
In this tutorial we will learn, how to install MySQL Server 5.6 on CentOS 7 / RHEL 7 . In our previous post, we have installed MySQL Server 5.6 on CentOS 6.x/RHEL 7.x.
In 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.
yum install wget
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
Install mysql-community-release-el7-5.noarch.rpm package
Install this downloaded rpm package by using rpm command.
rpm -ivh mysql-community-release-el7-5.noarch.rpm
After the installation of this package. We will get two new yum repo related to MySQL
[root@localhost ~]# ls -1 /etc/yum.repos.d/mysql-community*/etc/yum.repos.d/mysql-community.repo/etc/yum.repos.d/mysql-community-source.repo[root@localhost ~]#
Installing MySQL Server
By using yum command, now we will install MySQL Server 5.6 . All dependencies will be installed itself.
yum install mysql-server
How to start/stop/restart MySQL Server
Now MySQL Server is installed on your system.
To start MySQL Service, run command
systemctl start mysqld
To stop MySQL Service, run command
systemctl stop mysqld
To restart MySQL Service, run command
systemctl restart mysqld
To get status of MySQL Service, run command
systemctl status mysqld
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.
mysql_secure_installation
In another method,you can log into MySQL server database and reset the password in secure way.
mysql -u root
You will see mysql prompt like this mysql> . Use the below given commands to reset root’s password.
mysql> use mysql;mysql> update user set password=PASSWORD("GIVE-NEW-ROOT-PASSWORD") where User='root';mysql> flush privileges;mysql> quit
- redhat7安装mysql-server(mysqld)
- redhat7.0 mysql安装
- RedHat7下安装MySQL
- Redhat7.1快速安装MYSQL
- mysql.server,mysqld_safe,mysqld启动区别(转载收藏)
- 错误: MySQL server through socket '/var/run/mysqld/mysqld.sock‘
- Stopping MySQL database server: mysqld failed!
- redhat7.1 安装mysql 5.7.10
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- Starting MySQL database server: mysqld. Stopping MySQL database server: mysqld failed!)
- linux 下安装 MySQL 经常出现各种问题终极解决方法 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.pid
- 04-MySQL-Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- Mysql运行的STOPPING server from pid file /var/run/mysqld/mysqld.pid错误
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- 最佳启动Acitivity
- iOS 后台 播放h5 视频、音频 解决方案
- 处理机调度避免死锁之银行家算法
- 【HTTP协议系列4】服务器日志之X_Forwarded_For
- STL迭代器简介
- redhat7安装mysql-server(mysqld)
- Keil编译错误error:L6050U
- ios面向切面AOP(下) swift版本
- sicily 1209. Sequence Sum Possibi
- Java中使用AES加密的简单示例
- 3Sum Closest
- opencv实现图像细化效果
- iOS 从allCount个元素中取出myCount个元素的所有排列组合
- oracle11g 查看空表及数据库导出报“ EXP-00003: 未找到段 (0,0)