you use the terminal emulator in the X environment, the list is listed in the title bar. The list of Windows is generally like this:
0$ bash 1-$ bash 2*$ bash
In this example, I opened three windows, where the * number indicates that the window 2,-is currently in window 1 when the last window was switched.
Screen by default gives the window a combination of numbering and running program names in the window, in the example above, where the window is the default name. Practicing the way you
mysql_connect, On this wait-timeout effect you can see in the MySQL process list (show processlist), you can set this wait-timeout to larger, such as 300 seconds, oh, generally speaking 300 seconds enough to use, In fact, you can also not set, MySQL default is 8 hours. The situation is determined by your server and site.
The second method:
This is what I personally think is the best way to check the MySQL link state to make it relink.
Perhaps everyone knows that there is a mysql_ping such a
, and then reconnect.
Error 797Problem: ADSL modem connection device not foundReason: ADSL modem power is not open, network card and ADSL modem connector problems, software installation after the corresponding agreement is not properly bound, in the establishment of dial-up connection, the establishment of the wrong empty connectionResolve: Check the power supply, connectors, check Network properties, PPPoE related protocols are properly installe
Today, when you connect to the server remotely, prompt
Break Remote Desktop Connection
---------------------------
The client could not connect to the remote computer because of a protocol error.
Please reconnect to the remote computer. If the client is still unable to connect, contact your network administrator.
Remote Desktop Connection server times error: The session will be interrupted due to a protocol error. Please
This document references XRDP Tip:how to reconnect to the existing session while using the XRDP package from Ubuntu Repository
The first connection to remote Desktop is the port at which the connection is observed:
Then run:
sudo vim/etc/xrdp/xrdp.ini
Insert under [XRDP1]:
[XRDP8]
Name=reconnect
lib=libvnc.so
username=ask
password=ask
ip=127.0.0.1
port=5910
Where 5910 is the port number observed just
reconnect chance to re-connect the database, and then continue to verify (this check does not pass the error). Other validity checks return the connection if the error is not passed
The core of the return connection is to put the removed connection back into the connection pool, but before putting it back in the pool, a series of checks are made: for example, if the maxage is exceeded, validation is passed, etc. If the pre-checksum is not true, then
configuration file[email protected] ~]# vim/etc/my.cnf #编辑my. CNFSkip-grant #删除这一行Restart MySQL, and then re-enter, you will be prompted to require a password to enter.Reset the password to the end.———————————————————————————————————————————————MySQL Log in[[email protected] ~]# MYSQL-UROOT-PZAQ12WSX # Local Login[Email protected] ~]# MYSQL-UROOT-H10.72.4.30-P3306-PZAQ12WSXERROR 1130 (HY000): Host ' 10.72.4.30 ' isn't allowed to connect to this MySQL server[[Email protected] ~]# telnet 10.72.4.
-N,--skip-column-names//Do not display column information-O,--set-variable=name//Set Variable usage is--set-variable=var_name=var_value--sigint-ignore//Ignore SIGINT symbol (results of control-c when logging out)-O,--one-database//ignores statements except for the default database named in the command line. You can help skip updates to other databases in the log.--pager[=name]//Use a pager to display the query output, this to Linux can be used more,less and so on.--no-pager//Do not use a paging
Use UTF8 encoding allMySQL Chinese garbled solution
To view the default encoding format:
Mysql> Show variables like "%char%";
To set the encoding format:
SET character_set_client= ' UTF8 '; SET character_set_connection= ' UTF8 '; SET character_set_server= ' UTF8 ';
To view the encoding format of the database test:
To set the encoding format for database test:
ALTER DATABASE ' test ' DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;
,--quick//Do not cache the results of the query, sequentially print each row. If the output is suspended, the server slows down and MySQL does not use the history file.-R,--raw//writes the value of the column without escaping the conversion. Typically used in conjunction with the--batch option.--reconnect//If the connection to the server is broken, automatically attempt to reconnect. No reconnection, use--d
established. The time that this state occurs is very short. 4) registering slave on Master This state occurs when a connection to master is established. The time that this state occurs is very short. 5) Requesting Binlog dump This state occurs when a connection to master is established. The time that this state occurs is very short. In this state, the I/O thread sends a request to master requesting Binlog, starting at the position location of the specified binglog name and Binglog. 6) waiting t
to re-connect a databaseDelphiTadoconnnection and tadoquery do not have broken nets.automatic re-connectFunction.Procedure Tform1.formcreate (sender:tobject);
Begin
ADOcon: = Tadoconnection.create (nil);
ADOcon: = sconnect_sting; Database connection string
end;
Procedure Tform1.btnqueryclick (sender:tobject);
Begin
Try
if not adocon. Connected then
ADOcon. Open;
Adoqry. Connection: = ADOcon;
Adoqry. Connection: = ADOcon;
Adoqry.commandtext: = PSQL;
Adoqry.command
Tags: PAC change variable log ASCII process Vbscrip Timeout nbspNeed to import a SQL to user library of around 200M due to work needsExecute commandsource /tmp/user.sqlA MySQL server has gone away error occurred during the import process and the data import failed.The error message is as follows:ERROR2006 (HY000): MySQLServer has gone awayERROR2006 (HY000): MySQL server has gone awayno connection. Trying to reconnect ... Connection ID: 11current datab
location to the primary serverWaiting to reconnect after a failed Binlog dump request#如果二进制日志转储请求失败 (because there is no connection), the thread goes to sleep, and the new connection, you can use the--master-connect-retry option to specify the interval between retriesReconnecting after a failed Binlog dump request#线程正尝试重新连接主服务器3 , from the library SQL Thread State:Reading event from the relay log#线程已经从中继日志读取一个事件, the event can be processed.Have read
. HEADIMAGEVIEW.FRAME.ORIGIN.Y = self. headimageview.frame.origin.y-10; - - //should be indirectly modified - //1. Remove Structure Properties inCGRect rect =Self . Headimageview.frame; - //2, modify the members inside the structure, at this time after the frame is not an object toRECT.ORIGIN.Y-= -; + //3, the value of the return, is the three steps. Must have this step. -Self. Headimageview.frame =rect; the } * $ @endThree steps: Take out the structure properties, modify
current access point
enablenetwork (int netid,boolean disableothers)
Establish a connection to a previously provisioned network
Getconfigurednetworks ()
Client Gets network connection status
Getconnectioninfo ()
Get Current connection Information
Getdhcpinfo ()
Get DHCP information
Getscanresult ()
Get scan test Results
Getwifistate ()
Gets whether a Wi-Fi access point is valid
It is very convenient to configure ADSL In Ubuntu. You can configure sudopppoeconf all the way. Then run the pondsl-provider command to start the dial-up and use the manual poff to disconnect the dial-up connection. In addition, we can use the plog command to view the connection log information. However, I recently encountered a particularly strange problem. Each time the last time, generally 4 ~ 5 minutes, sometimes 2 ~ In 3 minutes, the network is disconnected. You can use the pondsl-provider
, long) checks to see if a node is ready to send a new request. Because it's for the client, "node" here is the broker.public Boolean Ready (node node, long Now) is the connection to the specified Node that has been created and can send the request. If the connection is not created, create a connection to this node.Public long Connectiondelay (Node, Long) is based on the connection state and returns the time to wait. There are three states of connection: disconnected, connecting, connected. If i
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.