1. Database Security Initialization[[email protected] my.cnf.d]# mysql_secure_installation #安全初始化命令NOTE: RUNNING All PARTS of this SCRIPT is RECO mmended for all MariaDB SERVERS in PRODUCTION use! Please READ each STEP carefully! In order to log
1. To optimize the query, to avoid full table scanning, first consider the where and order by the columns involved in the index.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to discard full-table scans using the index,
I used ms SQL Server all the time. The first time I used MySQL, I encountered a problem.
MySQL server installed on Windows XP and then remotely connected to MySQL using the client tool EMS SQL manager for MySQL always prompts failure. No problem
Original post address: http://www.itpub.net/forum.php? MoD = viewthread & tid = 1773550 & page = 3 & extra = # pid21190340
As a MySQL dBA, I have given my own understanding. Let's talk a lot about it:
1: as a technical interviewer, which
Original article: http://www.ningoo.net/html/2008/how_mysql_proxy_works.html
The MySQL proxy is located between the client application and the MySQL server, and implements its function by truncating, changing, and forwarding the communication
You can back up Mysql Data in either of the following ways:1) copy files. This is of course the simplest. Copy the folder of the corresponding database and then copy the file ibdata1.2) mysqldump
Of course, the 2nd methods are better. For example,
Environment:MySQL database versions of A and B are 5.0.24.
A: master serverOperating System: Windows XPIP Address: 192.168.0.81B: slave serverOperating System: Windows XPIP Address: 192.168.0.82
Configuration process:1. Create a backup account in
Today, a colleague asked me to help me read a report. This report was generated by an open-source system and the background database uses MySQL. the problem is that the data in one report is incorrect. At that time, the other report was correct.
Happy to see MySQL 5.5.8 GA, and upgrade 5.5 today, I am unable to connect to MySQL remotely, and the error message is as follows:
Error 1042 (hy000): Can't Get hostname for your ad[Root @ localhost ~] # Mysql-H 192.168.1.10-u root-PEnter
Go to the command line, Windows cmd, and connect:
Mysql-u username-P password-H Server IP address-P server MySQL port number-D database name
Note:
(1) The server port flag-P must be larger to distinguish it from the user-P. If you directly connect
Generally, when our database uses GBK encoding, it is okay to query Chinese in PHP and phpMyAdmin. However, once we log on from the command line using the DOS window. If the query results contain Chinese characters, garbled characters may occur. To
Many problems may occur when configuring the JSP development environment. Thanks to the experiences of many predecessors on the internet, the author cl41's JSP connection to the MySQL database strategy and the author's saulzy's MySQL study notes and
Data Table imported from Excel to MySQL database
I simply sorted it out:
Import Excel Data to MySQL database:1: select the data block to be imported. (Some people say there is an extra column. I don't need to do that after the test. I have exported
Note: This article is from the blog "afei". If you want to repost this article, please contact the author! And indicate the source: http://blog.csdn.net/faye0412/article/details/8817021
When verboice is installed today, MySQL/Writing File error
Using python to regularly update Mysql Data first describes this requirement: the server has two tables, album_item and album_item_inc. One is the full table, which is generated every morning and the other is the incremental table. Real-time update.
Program Introduction: Sometimes we want to know which tables are in a database and what fields are in the table. I wrote a small program to implement this function.
Ideas:1: connect to the database (nonsense)
2: obtain all the tables in the
If it is reprinted, please indicate the source. Thank you.
1. DISPLAY variable values related to character sets
Mysql> show variables like 'chara % ';
+ -------------------------- + ------------------------------------------- +
| Variable_name |
I. Basic Common commands for MySQL Databases1. Start and Stop a serviceNet stop MySQLNet start MySQL
2. log on to MySQLMysql-uroot-P press enter to enter the passwordNote: to connect to another machine, you need to add the parameter-H Machine ip110.1
---------------------------------------------
I don't know how other people can judge it. I usually check whether there is a MySQL folder under var/lib.
-------------------------------------------
1. Start the MySQL Service
Run/etc/init.
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