MySQL installation tutorial under Centos7_Mysql-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

MySQL installation tutorial under Centos7_Mysql

微波

Jun 28, 2017 pm 03:45 PM

centos7mysql

This article mainly introduces the MySQL installation tutorial under Centos7 in detail. It has certain reference value and interested friends can refer to it. Here is the

MySQL installation tutorial for your reference. The specific content is as follows

1. Download

Go to the official website to download the Yum source: Address

2. Installation

rpm -ivh mysql57-community-release-el7-11.noarch.rpm
yum install MySQL-community-server

3. Connection settings

• No password for initial installation
mysql -u root

•Set password
set password for 'root'@'localhost' =password('password');

#If the following error is reported

#Exit Mysql connection runs the following command
mysql_upgrade -uroot -p

Updatepassword again Prompt successful

•Set up remote connection

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

The above is the detailed content of MySQL installation tutorial under Centos7_Mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

CentOS7怎么安装Mysql并设置开机自启动Jun 02, 2023 pm 08:36 PM

centos7不带mysql数据库了，默认的数据库是mariadb（mysql的一个分支）。可以按照以下步骤手动安装mysql数据库。1.下载rpm安装文件wgethttp://repo.mysql.com/mysql-community-release-el7.rpm2.执行rpm安装rpm-ivhmysql-community-release-el7.rpm依赖解析完成后，出现下列选项：dependenciesresolved=================================

centos7怎么查看php安装目录？三种方法分享Mar 22, 2023 am 10:38 AM

如果你正在使用 CentOS 7 操作系统，需要查看 PHP 安装目录以便定位配置文件、扩展等相关信息，那么就需要了解一些相关命令和技巧。下面，我们将为您介绍一些方法来查看 CentOS 7 上的 PHP 安装目录。

怎么在CentOS7中使用Nginx和PHP7-FPM安装NextcloudMay 24, 2023 pm 08:13 PM

先决条件64位的centos7服务器的root权限步骤1-在centos7中安装nginx和php7-fpm在开始安装nginx和php7-fpm之前，我们还学要先添加epel包的仓库源。使用如下命令：yum-yinstallepel-release现在开始从epel仓库来安装nginx：yum-yinstallnginx然后我们还需要为php7-fpm添加另外一个仓库。互联网中有很个远程仓库提供了php7系列包，我在这里使用的是webtatic。添加php7-fpmwebtatic仓库：rpm

CentOS7如何安装Nginx并配置自动启动May 14, 2023 pm 03:01 PM

1、官网下载安装包选择适合linux的版本，这里选择最新的版本，下载到本地后上传到服务器或者centos下直接wget命令下载。切换到/usr/local目录，下载软件包#cd/usr/local#wgethttp://nginx.org/download/nginx-1.11.5.tar.gz2、安装nginx先执行以下命令，安装nginx依赖库,如果缺少依赖库，可能会安装失败，具体可以参考文章后面的错误提示信息。#yuminstallgcc-c++#yuminstallpcre#yumins

CentOS7下怎么部署php7.1和开启MySQL扩展May 28, 2023 pm 03:01 PM

简单安装(yum方式)安装软件源添加epel源[root@opstrip.comopt]#rpm--import/etc/pki/rpm-gpg/rpm-gpg-key*[root@opstrip.comopt]#rpm-uvhhttp://mirrors.rit.edu/fedora/epel//7/x86_64/e/epel-release-7-9.noarch.rpm添加remi源[root@opstrip.comopt]#rpm-uvhhttp://rpms.remirepo.net/e

Centos7改系统时区方法有哪些Mar 03, 2023 am 10:47 AM

Centos7修改系统时区的两种方法：1、使用timedatectl命令，可设定和修改时区信息，语法“timedatectl set-timezone 时区标识”；2、修改用户目录下的“.bash_profile”文件，在文件末尾追加“TZ='时区标识'; export TZ”即可。

如何在 CentOS 7 中安装并配置 Java 环境变量？Apr 22, 2023 pm 04:28 PM

安装环境：Centos764位Jdk1.864位Xshell免费版win10*64位一、先进来，你需要检查自己的openjdk是否卸载(或者判断是否存在，因为一般centos都会预装openjdk):在xshell或rpm-qa|grepjdk中输入rpm-qa|grepjavarpm-qa|grepjava第二，如果有一个对应的openjdk，并且显示了一个响应列表，那么就需要卸载它。在xshell中输入rpm-e-nodepstzdata-文件名(这个文件名是你查看的openjdk文件列表中

centos7使用rpm安装mysql5.7的方法May 27, 2023 am 08:05 AM

1.下载4个rpm包mysql-community-client-5.7.26-1.el7.x86_64.rpmmysql-community-common-5.7.26-1.el7.x86_64.rpmmysql-community-libs-5.7.26-1.el7.x86_64.rpmmysql-community-server-5.7.26-1.el7.x86_64.rpm想要用迅雷进行下载得先找到对应的rpm下载路径首先浏览器打开mysql官网：在打开的界面，按键盘f12打开开发者工具

See all articles