[Linux]centos7 fix yum install mysql-server no packages available

1 . Download MySQL repo source[[email protected] ~]# wget http://2. Install mysql-community-release-el7-5.noarch.rpm Package[Email protected] ~]# RPM-IVH mysql-community-release-el7-5. noarch.rpm3 . View the installed MYSQ source[[email protected] ~]

MySQL Basics Six

1 categories of variable 1.1 variables System variables: Global variables: Session Variables: Custom variables: User variables: Local variables: 1.2 Basic introduction to System

Configure MySQL master and slave under Docker

Configure MySQL master-slave under native DockerInstall the Docker MySQL container first$ docker pull MySQL:5.6Pull two identical versions of MySQLStart MySQL separately and set the root user password to admin:// Master MySQL 3307:3306-d-e

MySQL 5.6 Multi-instance deployment

1. Install MySQL# useradd-s/sbin/nologin-m MySQL# TAR-XVF Mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz-c/usr/local# mv Mysql-5.6.41-linux-glibc2.12-x86_64 MySQL# Chown-r Mysql:mysql/usr/local/mysql2. Configure the multi-instance profile directory#

Initializing MySQL database encountered some problems

The MySQL database was initialized with a hint of Perl and data missing::d umperYou need to install two packages at this time,Yum Install PerlYum Install autoconfPrompt InnoDB database file size error when initializing MySQL database 2018-08-28 18:01

MySQL Slow query

Turn on slow query logAdd two configuration parameters under the [mysqld] line in the configuration file my.cnf or My.iniSlow_query_log = on #开启慢查询long_query_time=1 #设置慢查询时间 1 s Slow_query_log_file="d:/phpstudy/mysql/data/slow_query.log"

MySQL server creation and deletion

MySQL server is the most popular database management system.A database is a warehouse that organizes, stores, and manages data according to its structure.MySQL database is the data in the form of a table, each behavior record name, each column

MySQL Development Advanced Series 30 Database binary package (installation specified path, directory description)

I. Specifying a pathIn the previous article, the binary package was unzipped, all put in the/usr/local/mysql directory, at the time of installation to specify the base directory and data directory,--basedir=/usr/local/mysql--datadir=/usr/local/mysql/

Problem solving method required to Usr/local/mysql directory when MySQL starts

Before I installed the MySQL database, because my MySQL is not installed in the standard/usr/local/mysql directory, but installs in the/usr/local/development/ The mysql-5.5.25 directory causes the error to report that the/usr/local/mysql directory

User Rights Management for MySQL server

--Authorize a user (Zhangsan) password 123, you can do all the operations on all the libraries, all the tables.Mysql> Grant All on * * to [e-mail protected] '% ' identified by ' 123 ';Query OK, 0 rows affected (0.17 sec)-The refresh takes effect,

MYSQL replicates the record and inserts it into the current table

Example tablecreate table tb_demo( id int unsigned auto_increment primary key, title varchar(50) not null default '', contents text, add_time int unsigned default 0);Inserting test datainsert into tb_demo (title,contents,add_time) values ('#1

Four features and isolation levels for "Mysql" transactions

Four types of features:Atomicity (atomicity): All operations in a transaction are treated as a collation, either complete or all rolled back.Consistency (consistency): The data in the database is logically consistent before and after the operation.

MySQL compilation installation

Compiling the installation database (MySQL)First download the MySQL tar package,www.mysql.com DownloadI'm using mysql5.6.41 's tar package.Put the bag in the/usr/local directory.useradd -s /sbin/nologin mysql 创建mysql用户mkdir -p /data/mysql/data

MySQL's aggregation function

The syntax for the aggregation operation is as follows:--SELECT [field1,field2,...... fieldn] Fun_name-From TableName--[WHERE where_contition]--[GROUP by Field1,field2,...... fieldn--[with ROLLUP]]--[Having where_contition]--The following

MySQL Error: Cause:com.mysql.jdbc.PacketTooBigException

error message:Error Updating database. Cause:com.mysql.jdbc.PacketTooBigException:Packet for query is too large (5872 > 1024). You can change this value on the server by setting the Max_allowed_packet ' variable.Workaround:Go to MySQLEnter show

MySQL Common commands

Basic command:1 command to add '; ' Indicates the end of the command -2mysql> statusCheck current login information, MySQL version information -3Mysql> Helpfrequently used help commands -4Mysql> select version ();MySQL version information -5Mysql>

MySQL design table structure data type selection

Choose the right data typeWhen using MySQL to create a data table, you will encounter a problem, how to choose the appropriate data type for the field. For example, to create an employee information table, each field can be defined in many different

CentOS7 installing MySQL

1 Download and install the official MySQL Yum RepositoryDownload Install Yum Repository  Wget-i-C http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmYum Installation  Yum-y Install mysql57-community-release-el7-10.noarch.rpmStart

MySQL Spatial Data Simple operation

In the project to do, you draw the area graph, and store it up, there is the need for updates, the storage file is not, think of the database now support the spatial database.MySQL is now used to continue to use MySQL to store and manage spatial

MySQL Series (12)--index push-down optimization

The index condition push (ICP) is an optimization of how MySQL uses an index to retrieve rows from a table. Without an ICP, the storage Engine traverses the index to find rows in the base table and returns them to the MySQL server, which evaluates

Total Pages: 3233 1 .... 1531 1532 1533 1534 1535 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.