When using Docker we often encounter an application where I need two or more containers, some of which require services from other containers. For example, we need a container to provide the MySQL database service, while the other two containers are
ObjectiveThis article focuses on springboot integration of Kafka and Storm and some of the problems and solutions encountered in this process.Knowledge of Kafka and StormIf you are familiar with Kafka and Storm , this section can be skipped directly!
Heterogeneous data sources interact with Oracle database. Figure 1 is an Oracle heterogeneous Connection processing architecture diagram where we can see that the main non-data source modules include the HS (heterogeneous Service), Agent. There is
Today in MySQL want to use a self-contained function to detect the length of the field content as
The code is as follows
Copy Code
Select ID from BB where len (field) >5
Results appear
FUNCTION xxx. LEN does
In the previous share of this article: CentOS 7.0 under the use of Yum installation of MySQL method, small set feel not detailed, today to everyone through this article to make a supplement, interested friends can refer to.
1. Download the MySQL
1, the installation of good Wamp, run the Wampserver program, into the MySQL console;
2, enter the console, prompted to enter the password (do not enter any password, because the password is empty), press ENTER enter;
3, input "use MySQL;" Then
Security Configuration One(1) Open PHP Safe modePHP's security model is a very important embedded security mechanism to control some functions in PHP, such as System (),At the same time, a lot of file operation functions have permission control,
1, SSH login to the Linux server, send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), the file that holds the process ID is usually in the directory where the MySQL database resides. (The command Input section is marked in red)
See if SSL is supported
First, execute the following command on MySQL to query whether MySQL supports SSL:
Mysql> show VARIABLES like ' Have_ssl ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| Have_ssl |
Inadvertently also found CentOS professional forum, remember: http://www.centospub.com
So, the beginning of the learning configuration
This environment:
CentOS System,
Mysql-server (version forgotten, because it was installed using Yum)
Process
See if SSL is supported
First, execute the following command on MySQL to query whether MySQL supports SSL:
Mysql> show VARIABLES like ' Have_ssl ';+---------------+-------+| variable_name | Value |+---------------+-------+| Have_ssl |
MySQL root password is correct, but how can not log in MySQL from the local, prompted
1 ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)
Here, after a high point to find the user table in the MySQL library
First, verify that MySQL is configured and correct
Re-configure
If you are reinstalling MySQL, please confirm that after the installation of MySQL after the first configuration, otherwise will be missing My.ini files, configuration method, can be
When the development and production environment on the same machine, or need to deploy more than one set of test environment on a machine, often need to start multiple mysqld processes, and recently to help test the environment encountered this
Operation Steps:
Method One
1, installation P7zip: Because the source does not have this package, directly download the source code installation.
Address: http://p7zip.sourceforge.net/
The code is as follows
Copy Code
Error
ERROR 1418 (HY000): This function has none of the deterministic, NO SQL, or reads SQL DATA in its declaration and binary Loggi NG is enabled (for your *might* want to use the less safe log_bin_trust_function_creators variable)ERROR 1418 (HY000
CentOS install MySQL is very simple as follows command
Yum install MySQL installed,
Running MySQLERROR 2002 (HY000): Can ' t connect to the local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2). There is an article that is a matter of
Today, follow the depot example of the agile Web Development with Rails to automatically generate scaffold from a database table.
That day in the company to do this example, feel quite smooth, did not expect to change to the home today after the
Each installation is always a little different, this time try it this way, also recorded.
1, first need to download the RPM package:
Mirrored address:http://mysql.mirrors.pair.com/Downloads/
According to different versions of the download can be
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.