MySQL

One, view the status value of the profiles1. To see if the profiles is already open, the default is not to open it.Mysql> Show Profiles;Empty Set (0.02 sec) Mysql> show variables like '%pro% '; +---------------------------+-------+ | variable_name 

1. First verify that the server is in a secure state, that is, no one can connect to the MySQL database arbitrarily.Because the MySQL database is completely password-protected during the reset of the root password of MySQLStatus, other users can

Just contact MySQL, today received the task to backup the database. From the Internet to find a half-day information, but still always error:Mysqldump:unknown option '--no-beep '。 There are many people on the internet who have said the solution to

See if Binlog is turned on:win+r = cmd = connect mysql=>show variables like ' log_% ';Mysql> Show variables like ' log_% '; +---------------------------------+-------------+| Variable_name | Value |+---------------------------

Use Hibernate + MYSQL database development, link timeout problem: Com.mysql.jdbc.CommunicationsException:The last packet successfully received from the server was58129 seconds ago. The last packet sent successfully to the server were 58129 seconds

Most of this article is from the simple MySQL primer. Integer type Number of bytes Range of negative values Range of non-negative values Float 4 -3.402823466e+38~-1.175494351e-38 0 and 1.17549

Mysql> DESC MYSQL. USER \g***************************1. Row ***************************Field:hostType:Char( -)Null:noKey:priDefault:Extra:***************************2. Row ***************************Field:userType:Char( -)Null:noKey:priDefault:Extra:

Version control software has svn git and so on, these tools control the source version is very useful, but the database version control it? The traditional approach is to export the entire database, so that team collaboration is very inefficient. Is

Match type for MySQL index/*Create a test tabledrop table T_index;CREATE TABLE T_index (TID int not null PRIMARY key auto_increment,Tname varchar (+) NOT NULL,Tage TINYINT Default 0,Tadd varchar (+) Default ',Tel int default 0,Tmob varchar ("DEFAULT"

First trick, start and stop of MySQL servicenet stop MySQLnet start MySQLSecond move, login MySQLThe syntax is as follows: Mysql-u user name-p user PasswordType the command mysql-uroot-p, enter the password after entering, enter 12345, and then

Early in the morning open the Navicat Lite for MySQL client, prompting 1045 Access denied for user ' root ' @ ' localhost ' using password yes, too much power , online search A lot of information, the final problem to be resolved, the following

Virtual User:The so-called virtual user, that is, all virtual users will be unified mapping to a designated system account, access to the shared location is the home directory for this system account. Very easy to manage.Experiment Title:

Primary server:10.236.51.151From server:10.236.51.152Install MySQLYum-y Install Mysql-devel Mysql-serverRun the Security Settings WizardMysql_secure_installationPrimary serverCP/USR/SHARE/MYSQL/MY-LARGE.CNF/ETC/MY.CNF (My-large is a file that notes

1. Environmental Statement and preparation [[email protected] ~]# yum list | egrep -i  "(httpd|mysql|php)"  |  grep  ' installed ' This system is not registered with rhn. rhn support will be disabled.httpd.i386                           

MySQL Configuration detailed:1, error log--log-error[=file_name] Specifies the location of the mysqld (MySQL server) where the error log file is saved.2, binary log--log-bin[=file_name]mysqld writes the SQL command that contains all the updated

When using the MySQL command to import mysqldump generated SQL files, in order to improve the import speed, often need to modify the dump file, but in the face of a dozens of GB file, this thing is too broken, the quickest way is to do this:(

Note: This article is dedicated to those who still do not understand the injection of learning!Target Station: http://www.51team.cn/Injection point: http://www.51team.cn/newmess.php?id=138find the injection point after guessing field, available

Environment:salt_master:192.168.100.228salt_client1:192.168.100.245Master client version consistent [[email protected]_server base]# Salt--versions-report salt:0.17.5 python:2.6.6 (R2  66:84292, June, 14:18:47) Jinja2:unknown m2crypto:0.20.2 msgpack-

Now you need to export some data from the MySQL library to Excel and print it. In fact, implementation of the above-mentioned requirements is very simple, as long as you write out the SQL statement, and then exported as Excel canThe specific

Change the Ubuntu MySQL Data directory locationMost of the time, MySQL data will be very large, the data by default in/var/lib/mysql, because/var partition space is not large enough, so we need to change the MySQL data storage path, put into the