Symptoms:Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: Yes)
Solution: change the password
Open a terminal once and enter:->/etc/init. d/MySQL stop-> Mysqld_safe -- user = MySQL -- skip-grant-tables --
Step 1: Download mysql-4.0.14b-win.zip?mysqlcc-0.9.4-win32.zip
Step 2: Find the driverProgramMySQL currently provides the Java driver for connection/J, can be downloaded from the MySQL official website, extract and find the mysql-connector-java-3.0.
Run the following command in the DOS MySQL installation directory/bin directory:Mysql-u username-P databasename use database_nameRun the following command:Mysql> source 111. SQLThe default 111. SQL path must be placed in the bin of MySQL.Import
I. What are MySQL table shards and partitions?
What is table sharding? On the surface, it means dividing a table into N small tables. For details, see the three methods of MySQL table sharding.
What is a partition? partition refers to dividing data
Linux selected in the last semester, because the last semester is relatively time-consuming, so there is no time to sort it out, now it is well organized, keep it for future use.
1. Download Apache libxml2 PHP MySQL files.
2. install Apache
Tar-zxvf
The MySQL version used in this article is 5.1.48
Select SQL _no_cache * from one where ID
#0 my_qsort2 (base_ptr=0x1b2176c0, count=4, size=8, cmp=0x869220,cmp_argument=0x4670ea38) at mf_qsort.c:115#1 0x00000000008690ea in my_string_ptr_sort
Content transferred from Sohu gulei PPT
Originally edited from old gold: http://www.mysqlops.com/2012/05/15/mysql-sql-analyze.html
Preface:• Without accumulating steps or even thousands of miles; without accumulating small streams, there is no way
Self-opening place
MySQL has a function to log down and run slow SQL statements. This log is not available by default. To enable this function, modify my. CNF or start MySQL.When adding some parameters.
If you modify it in my. CNF, add the
(1) Implement result set a-result set B: -- use not
Exists. Union is available for merging.
Exists, not
Exists: used to determine whether or not result set a exists in result set B!
=========== Result set:
Select
D. device_id, D. device_name, A.
For some database queries, you not only want to get the query results, but also want to conveniently count the number of records in the query results. My usual practice is:$ Q = "select * from $ fromTable where $ where limit $ start, $ pageSize ";$
The MyISAM engine is a non-transactional engine that provides high-speed storage and retrieval, as well as full-text search capabilities. It is suitable for applications with frequent queries such as data warehouses. In MyISAM, a table is actually
1) when compiling MySQL, a default character set is specified, which is Latin1;
(2)
When installing MySQL, you can specify a default character set in the configuration file (My. INI). If it is not specified, this value is inherited from the value
1. Go to mysql and create a new user, xuys. Format: grant permission on Database Name. table name user @ login host identified by "User Password"; grant select, update, insert, delete on *. * to xuys@192.168.88.234 identified by "xuys1234"; view the
Source: China 163 Shinkansen
Summary:Summary of installing resin + mysql + IIS + JDK1. Install JDK first:One worker downloads j2re-1_4_1_02-windows-i586-i.exe, and then installs it directly.2) environment variables after installation:PATH:
1 Chinese problem, when using MySQL instance Configuration tool, set the character set to GBK instead of UTF-8
2. The password cannot be accessed after MySQL is installed:
Mysql> SET PASSWORD-> 'Some _ user' @ 'some _ host' = OLD_PASSWORD ('newpwd ')
I accidentally deleted the root user of mysql and found a lot of solutions on the Internet. Due to the large number of mysql databases and the trouble of reinstalling them, I have been trying various methods, finally, it succeeded. The procedure is
1. Cause of error: modified the MySQL configuration file my. ini.
2. Check the error:
Some code of the my. ini configuration file:
[Mysqld] # The TCP/IP Port the MySQL server will listen on Port = 3306 # path to installation directory. all
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