MySQL compilation, installation, and user management

MySQL compilation, installation, and user management MySQL user password modification:1. mysqladmin-u USERNAME-h HOSTNAME password 'new _ pass'-p2. set password for 'username' @ 'host' = PASSWORD ('new _ pass ');3. UPDATE mysql. user set password =

MySQL backup script for database/table sharding

MySQL backup script for database/table sharding 1. Database shard backup: #! /Bin/sh MYUSER = root MYPASS = 123456 SOCKET =/data/3306/mysql. sock MYLOGIN = "mysql-u $ MYUSER-p $ MYPASS-S $ SOCKET" MYDUMP = "mysqldump-u $ MYUSER-p $ MYPASS-S $ SOCKET-

Troubleshooting OGG-03517 errors

Troubleshooting OGG-03517 errors Environment Introduction: Source end: sybase Database, server Character Set iso_1, data Character Set cp936; Target end: Oracle11g, Character Set AL32UTF8. Replicat process error: ERROR OGG-03517 Conversion from

Installation and deployment MySQL-5.7.13 in CentOS6.7 64-bit environment

Installation and deployment MySQL-5.7.13 in CentOS6.7 64-bit environment System Environment:[Root @ localhost ~] # Cat/etc/RedHat-releaseCentOS release 6.7 (Final)[Root @ localhost tools] # uname-Linux localhost 2.6.32-573.22.1.el6.x86 _ 64 #1 SMP

MySQL Data Types

MySQL Data TypesMySQL Data Type MySQL supports multiple data types, including numeric, date/time, and string. Numeric data type: It can be integer TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT and DOUBLE, or DECIMAL. DATE/TIME type: Includes

MySQL 5.5 upgrades the character set from utf8 to utf8mb4

MySQL 5.5 upgrades the character set from utf8 to utf8mb4Reason for upgrade MySQL supports only three-byte UTF-8 characters by default, and does not support Emoji emoticons (four bytes). If there are four-byte characters, an error is returned. MySQL

Online MySQL backup script

Online MySQL backup script Recently, I am studying database backup and regularly execute the backup task. Here I set the backup script to the crontab command for regular execution. The script content is as follows:[Root @ mysql-db ~] # Cat

What is the 'virtual columns 'of MySQL 5.7?

What is the 'virtual columns 'of MySQL 5.7? MySQL 5.7 introduces a very practical function: Virtual column Generated (Virtual) Columns. For its purpose, we use a scenario to describe it. Suppose there is a table containing a column of the date type.

Troubleshooting of ORA-06502 errors reported by sqlplus Logon

Troubleshooting of ORA-06502 errors reported by sqlplus Logon I recently encountered a sqlplus login error. I was wrong at the beginning of troubleshooting. I had to ask Master dbsnake for such a small problem, it solves the problem like "Mr. Luo

Monitor MySQL Master/Slave synchronization latency

Monitor MySQL Master/Slave synchronization latency There are usually two ways to monitor the latency between MySQL master and slave: Seconds_Behind_Master and mk-heartbeat. Method 1: monitor the value of the Seconds_Behind_Master parameter output by

UNDO log systems

UNDO log systems The log system is the basic mechanism to ensure that the database management system correctly executes transactions. Based on different functions, the log system can be divided into UNDO and REDO. This article describes the

Compile MySQL source code using Eclipse-cpp in Ubuntu

Compile MySQL source code using Eclipse-cpp in Ubuntu 1. Download The eclipse-cpp-mars-2-linux-gtk-x86_64.tar.gz package, decompress it in Ubuntu, and run it. Jdk errors may occur because jdk is not installed or the jdk version is too low. Jdk1.8

Installing Oracle 11g R2 silently in CentOS

Installing Oracle 11g R2 silently in CentOS I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage Ii. System RequirementsMemory: 1 GB (minimum

MySQL Order By Principle and Optimization

MySQL Order By Principle and Optimization 1 IntroductionFor business (MySQL) DBAs or business developers, order by is a common business function that sorts the results based on specified fields to meet front-end display requirements. However,

Resolving MySQL time conversion exceptions

Resolving MySQL time conversion exceptions To connect to the MySQL database, an exception is thrown by default when the timestamp type with an operation value of 0 cannot be correctly handled:Java. SQL. SQLException: Cannot convert value '2017-00-00

MySQL Performance Test-Sysbench practice

MySQL Performance Test-Sysbench practiceSysbench Industry-renowned performance testing tools Allows you to test disks, CPUs, and databases. Supports multiple databases: Oracle, DB2, and MYSQL Download, compile, and install the SDK by yourself.

Typical paging code in Oracle

Typical paging code in Oracle Since there is no top keyword in Oracle, the paging code in SQL Server does not apply to Oracle. How can paging be implemented in Oracle? -- Query all data STUNO STUNAME STUAGE STUID STUSEAAT-----------------------------

Use SQL to split and combine data in the database

Use SQL to split and combine data in the database Using SQL to split and combine data in a database provides the following solutions: Method 1: With cte (Select a. Id, A. [Uid], UserName FROM (Select a. [id], REPLACE (Split. a. value ('.', 'nvarchar

Problems arising from over-using DBLINK for system integration

Problems arising from over-using DBLINK for system integration Excessive use of DBLINK for system integration may cause many problems, mainly due to the following: 1. A large amount of database resources are consumed; Each time the local system

PL/SQL Developer connects to the local Oracle 11g 64-bit database and shortcut key settings

PL/SQL Developer connects to the local Oracle 11g 64-bit database and shortcut key settings1. log on to PL/SQL Developer The installation steps of Oracle Database and PL/SQL Developer are omitted here. Note that the PL/SQL Developer software should

Total Pages: 1013 1 .... 50 51 52 53 54 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.