The notes here are for the first time the people who use MySQL can get started quickly ... are very basic instructions. My environment is MySQL server installed on Ubuntu, client side on Windows 7, the most popular client software is Toad for MySQL,
Environment-based library is 111.111.111.110 from library to 111.111.111.1111. Main Library CREATE database replication dedicated user-- executed on the main library, Create user ReplMySQL – UrootGrant replication Slave,replication Client on * *
Given a "point address" (such as 127.0.0.1) for a network address as a string, returns an integer representing the value of the address. The address can be either a 4 or a 8-bit address.mysql> SELECT Inet_aton (' 209.207.224.40 ');3520061480The
Environment: There are two sets of MySQL master and slave (A and B), now requires a set of MySQL from the library to restore to the B set of MySQL Master library and from the library. The execution process is as follows:
First, a set of
Modify User namemysql> use MySQL; Select DatabaseDatabase changedmysql> Update user set user= "DNS" where user= "root"; Change the user name root to DNSChange PasswordMethod OneUsing phpMyAdmin, this is the simplest, modify the MySQL library's user
1. Login and exit(1) LoginMysql–u User name –p passwordThis command password is clear textMysql–u User name –pEnter PasswordLog in at the same time indicate the host number:Mysql–h Host name –u user name –p passwordSpecify port number while logging
MySQL will appear in Chinese garbled reason is the following points:The 1.server itself sets the problem, for example still staying in Latin12.table language setting problem (including character and collation)3. The connection language setting
First, export the database:mysqldump command1. Export Data and table structure :Mysqldump-u User name-p password database name > database name. sql#/usr/local/mysql/bin/mysqldump-uroot-p ABC > Abc.sqlYou will be prompted to enter your password after
MySQL Learning--mysql startup failure caseSystem environment:Operating system: Linux RH6Database: Mysql 5.6Startup failure when starting MySQL server[[Email protected] mysql]# service MySQL startStarting MySQL ... The server quit without updating
Statement: The database is MySQL, I only to the extent of writing SQL statements (no saving process), C # will be the basic ADO Database Access, LINQ Foundation.This one only does personal study | review function. Novice can refer to, also please
Usually the main programming language is Java, the development of the main use of MySQL, often in order to test, debugging purposes need to operate the database, such as backup, insert test data, modify test data, some times can not be simple with
Monitor MySQLProbably logicalThere's a library where we get the ports for all the libraries,There's a table that records the IP address ports and roles for each database.Some databases are both the main library and the library (not the actual slave,
Modify MySQL user passwordDirectory
Mysqladmin command
UPDATE User Statement
SET PASSWORD Statement
Root password loss (to be verified)
mysqladmin Command (headings)The format is as follows (where user is
Reference documentshttp://nlp.solutions.asia/?p=362http://blog.csdn.net/fby98710/article/details/10367175http://blog.csdn.net/itufo/article/details/21519593Environments that require jdk1.71. mysql Database configurationL My.ini ConfigurationAdd
Long wanted to write an article about database master-slave replication, today, using some trivial time to manipulate and record it:First of all, we must think about the master-slave replication of the approximate steps, even if you do not
mysql-master1:192.168.72.128mysql-master2:192.168.72.129OS Version: CentOS 5.4MySQL version: 5.5.9 (master and master copy are the same as the MySQL version in the slave server or the master version is higher than the slave version)First, MySQL
How should MySQL add fields be implemented? This is a lot of new contacts MySQL database has been mentioned, the following is to introduce you to MySQL add fields and delete the field method, I hope you can be enlightened. MySQL add field: ALTER
Mysql Error 1146 Tabel doen't exist Error caused by high-Case sensitivity in MySql, tabeldoen
MySql Error 1146 Tabel doen't exist. Generally, the table does not exist, or the table name is incorrect and the permission is incorrect.
I encountered
Data Conversion Program from Mysql to MongodbThe previously written data conversion program from Mysql to Mongodb has been turned over, and is sufficient in the case of a small amount of data.
# -*- coding: utf-8 -*-import sys, osimport
Connect phpmyadmin to remote mysqlPhpmaadmin: connect to remote mysql to connect to remote mysql. Make sure phpmyadmin is available. Go to the phpmyadmin installation directory, where C: \ wamp \ apps \ phpmyadmin4.1.14,. Create the config folder;
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