Configure the data source file mysql-ds.xml, put it into the directory $ {jboss_home}/Server/default/deploy, here by the way record the mysql-ds.xml format, as shown below:
http://www.mysql.com/downloads/api-jdbc-stable.html -->
Client does not support Authentication Protocol requested by Server
1 -- error Cause Analysis
A problem encountered when the system was launched today: executableProgramUse static library compilation provided by mysql4.0.22. The database server
By default, MySQL cannot be accessed through a remote machine. The following configuration allows you to enable remote access.
On the MySQL server:
Run the MySQL command to enter the MySQL command mode, SQL
Code
mysql> use MySQL;
Note that this article is not a principle, but a simple summary. If you have any questions, pay attention to the following two sites:
Http: // I
MySQL . CN/
Http://dev.mysql.com/doc/refman/5.1/zh/index.html
1. Modify RootUserPasswordBy default,
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
MySQL
>
Create
Database
If
Not
Exists
My_db
Default
Charset utf8 collate utf8_general_ci;
# Pay attention to the
(EnterMySQL \ binDirectory)Note thatMySQLAdd points after each sentence in the console; Elementary
1. Enter mysql-u username-P Password
2. Export Database mysqldump-u user name-P Password Database Name (Table Name)> path backup. SQL
3. Import
Statement: ThisArticleReprinted from:
Http://blog.csdn.net/shuicaohui5/archive/2009/12/16/5015218.aspx
Install MySQL version: mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
Step 1:
When mysql5.1.30 is started for the first time, the manager of
[Switch] MySQL performance check and Optimization Method
Source: http://www.sudone.com/linux/mysql_debug.htmlAuthor: Ayou I have been using the MySQL database software, which is stable and highly efficient. There are several possible causes
Prerequisites for creating a foreign key: the columns in the table must be of the same type as the foreign key (the foreign key must be the external primary key ).
Foreign key: Associate two tables. A foreign key can only reference the values of
Data Too long for column XXX Solution
Update: Statement executed by mysql5 when phpMyAdmin cannot be connected:Set password for 'root' @ 'localhost' = old_password ('[newpassword]');
When importing data, navicat reported the following
Internal join: Check the data corresponding to the data in the two tables.External join: Check the corresponding data based on a table
First, create a table in the database.CodeAs follows:
/* Navicat Mysql Data transfersource server: localhost_3
When inserting big data, indexes will be slow. You can disable keys or directly add delay_key_write to the table.
Note:
Delay_key_write is only valid for MyISAM tables.This parameter is useful if you need to update a table frequently!However,
When I modified a table field yesterday, I found that the master-slave replication synchronization failed, but the synchronization process was not faulty, and the MySQL Log was not faulty. I carefully searched for the cause, it is found that the
MySQLConfiguration Optimization
I. Environment Introduction
MySQLVersion: 5.5.27
Ii. Content Optimization
Field
Introduction
Recommended Value
Skip-locking
AvoidMySQLTo reduce the probability of errors and
MySQL writes data through common insert statements, such
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
Insert
Into
Person
Values
(John,
20
), (Li Si,
21
), (Wang
Recently, all the original programs have been migrated to nginx, and Ubuntu has been used for a while. I am getting used to the Linux operations. In addition, the performance of Linux is really good, the configuration starts.
Configured
Ubuntu 9.10
MySQL master-master solution 1. Environment Installation
Same as the former2. Configuration
1. MySQL master-master Configuration
1. Modify the MySQL configuration file
To enable the BINLOG function for both MySQL instances, enable the function by
Prepare PDF files. net Framework open-source project "Supermarket Management System" is transplanted to Linux to run (demonstration address: http: // 221.123.142.196), using the jexus server and MySQL database, compared with SQLite, mySQL has many
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service