MySQL

Change the port number of the MySQL database in XAMPPIf you have a MySQL database installed on your computer and you want to use a database that comes with XAMPP, you need to change the port number of the database in the XAMPP to avoid conflicts

BackgroundMaster-Slave Switching is a necessary step for a highly available MySQL architecture (i.e., use does not occur and is prepared). Generally set to double m (M1, M2), assuming the current state is write M1, and M2 read-only, the approximate

In the MySQL database mirroring post, the data of the primary database A is mirrored to the one-way from database B, and the data read and write of the Zen cart store must be done in database A, and the results will be automatically mirrored into

MySQL Point-in-time data recovery test steps (based on position):1. View the name and location of the current binary logMysql> Show master status;|      master-bin.000001 | 1072, modify the database information and record the corresponding changes

Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p

InnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application. The basic difference is that the MyISAM type does not support advanced processing such as

The role of data types1: Reduce error rate2: Speed up the operationDefines the meaning of a numeric representation inside a characterLike whatThe ID int (10) indicates that the ID can store up to 10 digits, for example, 1234567890 of these values

Java and MySQL call code Focus recordsUsing development tools: IdeaUse platform: Ubuntu 14.10Java sectionJDBC driver name and database urlstatic final string jdbc_driver = "Com.mysql.jdbc.Driver"; static final String db_url = "Jdbc:mysql://lo

MySQL Query statementCommon SELECT commandsPrint the current date and timeSelect Now ();Print the current dateSelect Curdate ();Print Current timeSelect Curtime ();View current versionSelect version ();Print Current UserSelect User ();View Current

In MySQL, you will often see some processing of dynamic strings, such as: Dynamic_string.In order to record the actual length of the dynamic string, the maximum length of the buffer, and each time the string needs to be adjusted, the new memory is

1, display the current encoding informationMysql>show variables like '%character% '+--------------------------+----------------------------+| variable_name | Value |+--------------------------+----------------------------+| character_set_client |

In the first two, the installation of a basic Web server, but only to provide static Web view, to make a dynamic Web site, you must have a database or other programming language support, here first describes the installation of MySQL database.MySQL

1. Create with Mysql_config_editor tool. mylogin.cnf# Mysql_config_editor Set--login-path=client--host=localhost--user=www--passwordEnter password after carriage return2, at this time in the/root/directory to generate a hidden file, viewing is

1.1 Solutions for forgetting user passwordsOrdinary users, directly with the root Super Administrator login to change the password can be, but if the root password is lost, how to do?1.1.1 Msyqld_saft Way to retrieve passwordStop Mysql:service

1, after the installation of MySQL and service startup, System Preferences have started the MySQL service button to see that running is available 2. Access MySQL via terminalGo to the MySQL path first (the default installation does not configure the

A, sub-tableHorizontal DivisionVertical DivisionSecond, read and write separationThird, choose a reasonable data type, especially the primary keyIv. files, pictures and other large files using file system storageFive, database parameter

Two-level linkage drop-down menu selection application in many places, such as the provincial and municipal pull linkage, commodity size category pull-down selection linkage. This article will use the Jquery+php+mysql to achieve the size

Mysql master-slave configuration, mysql master-slave Configuration There can be many slave databases. We assume one master M and one slave S.   Add the master M configuration file: Server-id = 1 Bin-log = logbin This name is random Remember to

MySQL Study Notes 01 _ basic database knowledge, mysql Study Notes01_1 mysql database Start and Stop Start cmd with ; Enter net stop mysql to stop mysql service; Enter net start mysql to start the mysql service; Enter mysql-u root-p and press

Pt-pmp, mysqlptpmp Pt-pmp has two functions: Obtain the stack information of a process, and summarize the stack information. The stack information of a process is obtained using gdb. Therefore, the performance of the mysql server may be affected