MySQL

1. Use the MySQL command line:A. Connect MySQL: Open mysql command line clientInput password, enterB. Creating a database, displaying a database, deleting a database, working with a databaseMysql> CREATE DATABASE pet;ERROR 1007 (HY000): Can ' t

1. configuration file add filter password option#vim/etc/my.cnf　　　　Skip password Check2. Restart MySQL Service#/etc/init.d/mysqld restart3, #mysql-uroot-p (direct return)Mysql>update user Set Authntication_string=password (' PASSWORD ') where user= "

First, view and uninstall the original MySQLrpm-qa | grep mysql //This command will check if the MySQL database is already installed on the operating system.rpm-e MySQL //Normal Delete moderpm-e--nodeps MySQL //brute force Delete mode, if you use

A. Monitor Web server and MySQL methods1. monitoring port (nginx is same )1.1 Local monitoringNetstat-tunlp|grep 3306|wc-lSs-tunlp|grep 3306|wc-l1.2 Remote MonitoringNmap 10.117.33.98-p 3306|grep open|wc-lEcho-e "\ n" |telnet 10.117.33.98 3306

Errors encountered while making configuration from the server.mysql> Change Master to master_host= ' 192.168.136.129 ', master_user= ' repl ', master_password= ' 123456 ', Master_log_ File= ' mysql-bin.000003 ', master_log_pos=2610;ERROR 1201 (HY000)

MySQL master-slave configuration means a primary MySQL server, one from the MySQL server, a total of two servers to use. The main server added an account to allow access to the synchronization from the server, the master-slave configuration is

The usual, ctrl+alt+t exhale terminal,Inputsudo apt-get updateUpdate the source, or run the following code will be reported that a few packages can not be downloaded, you still have to come back to execute this code,Inputsudo apt-get install

1. InstallationSee if you have installed: Yum list installed mysql*See if there is an installation package: Yum List mysql*Installing Mysqlclient:yum install MySQLInstall MySQL server side: Yum install mysql-server yum install Mysql-devel2. Start &&

System Environment: CentOs6.7 i386MySQL version: mysql-5.6.36Root Login Linuxcdpwd#/root/wgethttp//mirrors.sohu.com/mysql/mysql-5.6/mysql-5.6.36-linux-glibc2.5-i686.tar.gz

Introduction: In the local access to the database, the general use of localhost, 127.0.0.1来 for database access, but I have encountered these days only through 127.0.0.1来 access, but not based on localhost to access, very strange .....Environment

Environment:JDBC Driver: Mysql-connector-java-5.1.7-binjmeter:jmeter3.01. Import the JDBC Driver: test Plan-Browse-select Mysql-connector-java-5.1.7-bin ""2. Add thread Group: test Plan right--add-->threads (Users)--Thread Group2. Thread group Right-

First, error logWhen a database fails to work, the first time to view the log1, the server starts the shutdown process information2. Error messages during server operationLog storage path, which can be viewed by command:Log file naming format:

SELECT hou.*,uname from Hos_house as HouINNER JOIN Sys_user as usrINNER JOIN Hos_type as HtyOn Hou.uid=usr.uidAnd Hty.htname= ' three rooms and one hall 'and Hou.htid=hty.htidand Hou.sid in(SELECT SID from Hos_street as street INNER joins

Isolation Level Dirty Reads (Dirty read) non-repeatable read (nonrepeatable Read) Phantom Read (Phantom Read) Uncommitted read (READ UNCOMMITTED) possible possible possible Read

Large web site in order to soft solution a large number of concurrent access, in addition to the site to achieve distributed load balancing, far from enough. To the data service layer, the data access layer, if the traditional data structure, or

Mysql database operations Easy operation with basic knowledge // Create a database Create database databasename; // Enter the database Use databasename; // Display the table name (you can use this statement to check the number of tables to

Reset the root password for mysql and set the root password for mysql. 1. KILL the MySQL process in the system;Killall-TERM mysqld 2. Run the following command to start MySQL without checking its permissions;Mysqld -- skip-grant-tables & 3. Use

Mysql logbin Data Log Recovery database, mysqllogbin ========================================================== ==================== BINLOG export SQL File========================================================== ==================== C: \ Program

Add, query, modify, and delete Mysql tables, columns, and databases Below are some basic SQL knowledge I have summarized, mainly to better check and help other beginners and record their own growth in the future, I also wrote some SQL interview

MYSQL replacement time (year, month, day) field, the time and minute remain unchanged, mysql minute and second Statement 1: update sas_order_supply_month_pay set RECEIVE_TIME = REPLACE (RECEIVE_TIME, DATE_FORMAT (RECEIVE_TIME, '% Y-% m-% D '),