NAV: SLTechnology News&Howtos > Database >

• 

  How to realize mysql remote login in centos system

  There are two main steps to realize remote login: (1) grant remote login rights to mysql users (table change method or authorization law); (2) the firewall opens port 3306. (1) Grant login permission mysql-u root-p to enter the password into the mysql.

  2022-06-01 18:54:41 Views: 243
• 

  What are the main tools for mysql backup

  The following mainly brings you what are the main tools for mysql backup. I hope these contents can bring you practical use, which is also the main purpose of this article for editing mysql backup tools. All right, don't talk too much nonsense, let's just read the following. Backup and restore scripts and tools 1)

  2022-06-01 18:54:30 Views: 249
• 

  How to better understand the mysql architecture

  This article mainly introduces the mysql architecture, the content of the article is carefully selected and edited by the author, with a certain pertinence, the reference significance for you is still relatively great, the following with the author to understand the v bar. The Mysql architecture overview is shown in the architecture diagram above, and we can view the

  2022-06-01 18:54:27 Views: 206
• 

  Detailed introduction of Mysql Grant user rights

  The following to understand the Mysql Grant user rights, I believe that we will benefit a lot after reading, the text in the essence is not much, hope that the Mysql Grant user rights of this short content is what you want. MySQL permission chart: it is obvious that there are a total of 27 permissions: here are the details

  2022-06-01 18:54:27 Views: 214
• 

  Is there any way to delete the mysql column?

  Let's talk about how to delete mysql columns. The secret of the text is to be close to the topic. So, no gossip, let's go straight to the following, I believe that after reading the mysql column to delete this article, you will certainly benefit. MySQL is a kind of relational database management.

  2022-06-01 18:53:56 Views: 223
• 

  Understand the EXPLAIN interpretation command in MySQL

  This article mainly gives you a brief introduction to the EXPLAIN interpretation command in MySQL. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope the article on EXPLAIN interpretation command in MySQL can give you

  2022-06-01 18:53:55 Views: 247
• 

  Detailed introduction to string types in MySQL column types

  The following mainly brings you the knowledge of string types in MySQL column types. I hope these contents can bring you practical use, which is also the main purpose of this article when I edit the knowledge of string types in MySQL column types. All right, don't talk too much nonsense, let's just read the following. Column type (data class

  2022-06-01 18:53:50 Views: 208
• 

  Comparison of several methods for inserting or modifying batch data in MySQL

  This article mainly introduces the comparison of several methods for inserting or modifying MySQL bulk data. The content of the article is carefully selected and edited by the author, which is of certain pertinence and is of great significance to everyone's reference. Let's learn about several ways of inserting or modifying MySQL bulk data together with the author.

  2022-06-01 18:53:49 Views: 254
• 

  How to query the processes being executed by mysql

  Let's talk about how to query the processes being performed by mysql. The secret of the text is that it is relevant to the topic. So, no more gossip, let's go straight to the following, and I'm sure you'll benefit from reading this article on how to query the processes being executed by mysql. There are two ways to view the mysql process

  2022-06-01 18:53:48 Views: 301
• 

  What are the common MySQL errors made by PHP developers?

  1. There are many database engines using MyISAM instead of InnoDBMySQL, and MyISAM and InnoDB are generally used. MyISAM is used by default. But unless you are building a very simple database or just an experimental one, then most of them

  2022-06-01 18:53:48 Views: 269
• 

  [basic] password storage mode of MySQL5.6

  Environment: CentOS6.8x86_64MySQL 5.6Community Edition selectuser,host,password from mysql.user where user = 'rpl';+-+--

  2022-06-01 18:53:31 Views: 231
• 

  What is the mysql view? How do you do that?

  The mysql view concept view itself is a virtual table that does not hold any data. When using SQL statements to access the view, the data obtained is generated by MySQL from other tables, and the view and the table are in the same namespace. View query data is relatively safe, and some data and structures can be hidden

  2022-06-01 18:53:28 Views: 257
• 

  How do I change the default path of mysql data files in linux?

  After installing the MySQL database using the rpm installation, the default path for the data file is / var/lib/mysql, but the root directory is not suitable for storing the data file, so we need to change the default path for the database file. The change method is as follows: environment introduction: original path: /

  2022-06-01 18:53:28 Views: 289
• 

  Introduction to stored procedures of mysql

  What is a mysql stored procedure? A stored program is a combined SQL statement stored in the server, which is compiled, created and saved in the database, and the user can call and execute it through the name of the stored procedure. The core idea of stored procedure is the encapsulation and reusability of database SQL language. Using stored procedures

  2022-06-01 18:53:24 Views: 300
• 

  What is the master-slave replication of Redis, and what is the principle of master-slave replication?

  Redis is a key-value storage system. Similar to Memcached, it supports relatively more value types for storage, including string (string), list (linked list), set (collection), and zset (sorted set)

  2022-06-01 18:53:03 Views: 256
• 

  Quickly write and operate the tablespace cleanup scheme

  1. Query database table space usage select total.tablespace_name,round (total.gb, 2) total_gb,round (total.gb, 2)-round (nvl)

  2022-06-01 18:53:00 Views: 204
• 

  Using yum to quickly build zabbix2.2

  System version: CentOS 6.9yum installed software version is: zabbix2.2.16,apache2.2.15,mysql5.1.73 (permanent address of this article: http://woymk.blog.51cto.com/

  2022-06-01 18:52:39 Views: 251
• 

  Mysql utility

  Mysql Command Line completion tool mycli Preface We use gui graphical interface tools in most cases when we connect to mysql databases. However, sometimes it is convenient to connect to the database on the command line, so we usually need to master a little command line operation of the database.

  2022-06-01 18:52:38 Views: 246
• 

  SQLserver2017 installed on Linux system forgot SA password

  Operating system version: ubuntu16.04 database version: SQLserver 2017 temporarily maps the intranet database to the external network through the router port due to the company's business needs. In a short period of one hour, the password of SA was changed by an unknown organization, resulting in abnormal events.

  2022-06-01 18:52:38 Views: 228
• 

  Oracle 11G uses statspack to view the performance of the database

  1. Install the Statspack tool (the script for the statspack tool is in the $ORACLE_HOME/rdbms/admin directory, all files that start with sp) [oracle@oracle ~] $sqlplus / a

  2022-06-01 18:52:37 Views: 291