MySQL

1. CREATE USERGrammar:CREATE USER ' username ' @ ' host ' identified by ' password ';Example: CREATE USER ' dog ' @ ' localhost ' identified by ' 123456 ';CREATE USER ' pig ' @ ' 192.168.1.101_ ' idendified by ' 123456 ';CREATE USER ' pig ' @ '% '

1. Connecting to the database server$./mysql-h Host_name-u User_name-p -H HOST_NAME (--host=host_name), the connected database hostname, can be omitted if it is on the local host. -U user_name (--user=user_name), database user name, on

WIndowsServer2008 Configuring MySQL Proxy:1.MYSQL Proxy: http://dev.mysql.com/downloads/mysql-proxy/, select the version of Windows.2. After decompression, configure the bin directory of the Mysql-proxy folder to the environment variable.3. When the

InstallationIn order to make the article more complete, we choose to install MySQL from the source code, we need to note that the earlier version has a memory leak, so it is recommended to install the latest stable version, as of this time, the

There are many PHP integrated development environments, such as XAMPP, Appserv ... Just one click to install the PHP environment to build. But this kind of installation method is not flexible, the free combination of software is inconvenient, but

MySQL installation of the initial installation, the longest encountered problem is the configuration parameter compatibility problem, because the database parameters have changed, resulting in the database is not recognized the situation is very

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

The customer prepares some data to be stored in Excel and lets us import into MySQL. I'll go first. I copied the data into the TXT file, parsing the TXT file myself and inserting it into the database using the JDBC loop.It was later discovered that

When we connect MySQL database, we usually add useunicode=true&characterencoding=utf-8 after the URL, but ask what to add?The purpose of the addition is to specify the encoding and decoding format of the characters. For example: the MySQL database

1. Optimize your MySQL query cacheQuerying on the MySQL server enables high-speed query caching. Having the database engine quietly handled in the background is one of the most effective ways to improve performance. When the same query is executed

1. Installing the JDKZrsz upload to server install JDK 7u552. Install TomcatDownload Tomcat 73. Installing NginxNginx installation relies on three packages3.1 openssl-1.0.1c.tar.gz3.2 pcre-8.36.tar.gz3.3 zlib-1.2.8.tar.gz3.4 Yum Install

The server is unresponsive (or the socket for the local MySQL server is not configured correctly)   The first case: (Deep cleanup garbage causes host.) MyD lost)   Like many netizens! With Wamp (or XAMPP, speedphp) It is easy to quickly build a

Original: MySQL optimistic lock summary and practiceThe previous article, "MySQL pessimistic lock summary and practice" talked about the MySQL pessimistic lock, but pessimistic lock is not suitable for any scenario, it also has some shortcomings,

Use Geovindu, #函数DELIMITER $ $drop function if exists f_getdepartmentname $ $CREATE function f_getdepartmentname (did int) Returns nvarchar (+) begindeclare str nvarchar (+); Select Departmentname into str from departmentlist where Departmenti D=did;

CENTOS6 Source installs the latest nginx php mysql (iptables selinux prior shutdown )1, Php5.6 installation Remi Sourcehttp://rpms.famillecollet.com/Yuminstall http://rpms.famillecollet.com/enterprise/remi-release-6.rpmThis action also installs the

Windows7 under Php+mysql+apache+phpmyadminThis is I copy from, because fixed my phpmyadmin, so reproduced, the original article see: http://blog.sina.com.cn/s/blog_6876deb201019ysu.htmlThese two days because I want to write a PHP environment

Comparison functions and operators in MySQL:1, [not] between ...  And ... Check whether a value is within a range of valuesDescription: Expr between min and MaxReturns 1 if expr is greater than or equal to whether the expression is less than or

Http://dev.mysql.com/doc/refman/5.6/en/memory-use.htmlThe following list indicates some of the ways that the mysqld server uses memory. Where applicable, the name of the system variable relevant to the memory use is given: All threads share the

Wampserver the password is empty after installation,There are two common ways to modify :First, through the phpMyAdmin directly modified;The second is to modify the MySQL console using Wamp.The first type:① in the phpMyAdmin interface, click "User",

MySQL High-availability Solution MHA Introduction   Overview  mha is a Japanese MySQL Daniel written in Perl a set of MySQL failover scheme to ensure that the database system is highly available. During downtime (typically within 10-30 seconds),