Compile and install MySQL
Prepare before installation
If the MySQL user does not exist, then add the MySQL user
Groupadd MySQLuseradd-g MySQL MySQL
MySQL Compile installation
wget
Modify the data content in the MySQL database to delete:
[Root@hk ~]#/usr/local/mysql/bin/mysql-uroot-p ' admin ' #进入mysqlMysql> CREATE DATABASE GBK default Character set GBK collate gbk_chinese_ci; #建立一个名字叫做gbk的数据库Mysql> Use GBKmysql> show
Regular expressions are widely used in various program programming places, in the MySQL SQL statements using regular expressions can also solve a lot of query problems, to simplify, and clever use can improve the efficiency of MySQL query. This
This error occurs if you want to connect to your MySQL:
ERROR 1130:host ' 192.168.33.60 ' isn't allowed to connect to this MySQL server
Workaround:
1. Change Table method. Your account may not be allowed to log in remotely, only in localhost.
About the process
In MySQL, set the password to open IE input URL localhostphpadmin, point users see the root user, pull down, find the place to modify the password, enter the password, carry out the operation, and finally go to your XAMPP
Workaround:
Start--> run-->cmd--> into the DOS command form: (if the command cannot be executed, place the MySQL installation path at the front of the system variable path)
1. Character set settings for fields in a database table. Show CREATE
Master-Slave configuration We need to have two MySQL servers, we have to clear two points
1, the MySQL configuration file my.cnf location
2, how to start, stop MySQL, find a good startup file
Assuming that there are two machines, MySQL has been
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
Warning:mysql_connect () [Function.mysql-connect]: Can ' t connect to the local MySQL server through socket '/var/lib/mysql/mys Ql.sock ' (2) in/home/content/63/8523763/html/deng/fqlbnet/admin/inc/db.php on line 34Can ' t connect to the local MySQL
MySQL Tutorial group BY, sort the largest record of time in each record
Select A.* from Test A,(Select Aid, Max (day) Max_day from test Group by aid) bwhere A.aid = B.aid and A.day = B.max_dayORDER BY A.install Desc
Here is the test table, which
MySQL tutorial forget root password correct solution
Describes the MySQL forgot root password correct solution, we all know in the actual operation forgot the password
is a very troubling thing, the following is the correct solution to this
1, download
The code is as follows
Copy Code
Wgethttp://www.percona.com/redir/downloads/XtraBackup/LATEST/binary/redhat/6/x86_64/ percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm
2, installation
The
(1) First development package group and server flat platform Development package Group
(2) Yum installation needs of the dependent package
(3) Compile and install Pam_mysql module
(4) Configure MySQL
MySQL supports SQL subqueries. This technique can use the SELECT statement to create a single column query result, and then use this result as a filter condition in another query. Subqueries can be used to complete SQL operations that require
Why is the master-slave architecture used?1. Server load balancing;2. Remote data backup through replication;3. Improve the availability of the database system;4. You can split databases vertically and tables horizontally ];Prerequisites for
When using mysql to create and call stored procedures, functions and triggers, the error code is 1418.ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you *
MYSQL enable log[Root @ jianshe99] # whereis my. ini[Root @ jianshe99] # vi/etc/my. cnf[Mysqld]Datadir =/var/lib/mysqlSocket =/var/lib/mysql. sockUser = mysql# Default to using old password format for compatibility with mysql 3.x# Clients (those
1. Use the official PPA to install the latest Nginx version. Run the following command: The code is as follows:Copy code Sudo add-apt-repository ppa: nginx/stableSudo apt-get updateSudo apt-get install nginx Nginx control commands:Start
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