In daily work, protecting data from unauthorized users is a special concern of system administrators. If you are currently using MySQL, you can use some convenient functions to protect the system, greatly reducing the risk of unauthorized access to
1. MySQL command line parameters
Usage: MySQL [Options] [database] // command Method-?, -- Help // display help information and exit-I, -- help // display help information and exit-- Auto-rehash // The auto-complement function is similar to the
1:
Navicat
Http://navicat.com/cn
2:
Mysql-front 3.2 Simplified Chinese version
3:
MySQL interface operating software: sqlyog Enterprise Special Edition ~! No installation required. It can be used after decompression!
Software
ArticleDirectory
2.1.1 phpMyAdmin
2.1.2 use mysqldump command line
2.3.1 use phpMyAdmin
2.3.2 use MySQL Command Line
1. Overview
There are two ways to import a MySQL database:
1) Export the database SQL script first and then
Transferred from: Http://koda.iteye.com/blog/788862http://koda.iteye.com/blog/682547
Use MySQL to forward read/write requests to the Master/Slave server.
1. Install MySQL proxy The binary version of MySQL proxy is very convenient and can
Preface
Mysqlreplicaion is a simple architecture, that is, a MySQL Server (slave) replicates logs from another MySQL Server (master), then parses the logs and applies them to itself. In a replication environment, only two hosts running mysqlserver
Registration Code of navicat for MySQL v8.0.27
Navicat is a powerful MySQL database management and development tool. Navicat provides professional developers with a powerful enough cutting-edge tool, but it is still easy to learn for new users.
Default installation directory of MySQL
Linux:/var/lib/MySQL/Windows: C: \ Program Files \ mysql \
MySQL command line history file
~ /. Mysql_history
Start MySql in Linux.
#/Etc/init. d/MySQL stop#/Etc/init. d/MySQL start
Restart
After the remote connection to SQL Server 2005 was completed last time, it is now MySQL's turn... think back to the connection string connecting to the MySQL database:
Server =Localhost; Database = gyl; uid = root; Pwd = 111111;
The value of the
Address: http://hi.baidu.com/%D4%E7%B9%C8%C9%E7%C7%F8/blog/item/1fd6f3d04927fd86a1ec9c44.html
MySQLPerformanceHow high is it? UsedPHPFor more than half a year, it was still from the day before yesterday to think deeply about this issue. Have
Group_concat () is a function provided by the MySQL database. It is usually used together with group by. For details, refer to the MySQL official document: commit.
Syntax:
Group_concat ([distinct] expr [, expr...] [order by {unsigned_integer |
A while ago, I visited MySQL through oracle in the company. The test environment is centos5_x64, oracle10g_x64, and mysql5.Share some experiences with you!
1. First, install the mysql client software on the computer where oracle is located, and
The specific usage of the command line is as follows: mysqldump-u uses the anonymous name-P password-D Data Warehouse name table name Script Name;
1. Export the table structure of the database named dbname (the database name is root, the password
Abstract:
By default, the iptables information filtering system is installed in centos. Currently, You need to configure the system to allow remote access to MySQL.
Related Knowledge:
Iptables Problems
1. iptables service/etc/init.
(1)Reduce Database AccessStatic pages are possibleStatic parts of a dynamic pageSome data can be generated as XML or saved as text filesUse data caching technology, such as memcached
(2)Optimization Detection Method
1. User Experience Detection2.
Test Table Structure:
CREATE TABLE `a` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cnt` INT(11) NULL DEFAULT NULL,PRIMARY KEY (`id`))COLLATE='utf8_general_ci'ENGINE=MyISAMROW_FORMAT=DEFAULT
Several permissions related to stored
For operations on the string position, the first position is marked as 1.
ASCII(str)
Returns a string.strASCII code value of the leftmost character.If
strIs a null string and returns
0. If
strYes
NULL, Return
NULL.
mysql>
Connection: mysql-h host address-u user name-p User Password (Note: u and root do not need to add spaces, the same is true for others)Disconnected: exit (Press ENTER)
Create authorization: grant select on database. * to username @ login host
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