MySQL database business in some data similar to data dictionary, such as configuration file configuration, common business configuration or table with little change in data volume, these tables are often not particularly large, but most of the
Mysql common command lines
Mysql common command lines
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Syntax: mysql-u user name-p User Password
Enter the mysql-uroot-p command, press enter and prompt
MySQL Format statement specificationHow do I log into your database?Example!If you are compiling the installation of the flowers, then you have to compile the installation of the directory to go, my is installed into the/usr/local/mysql database: Cd/
In daily work, mysql is used simply, so the Common commands are summarized as follows:
In daily work, mysql is used simply, so the Common commands are summarized as follows:
1. Start and exit
1. Go to MySQL: Start MySQL Command Line Client
At noon, I understood the backup and recovery of the MYSQL cluster. Write it down. You don't have to waste time on this issue.
At noon, I understood the backup and recovery of the MYSQL cluster. Write it down. You don't have to waste time on this
Mysqlndb cluster backup database and restore database methods Mysql Cluster
BitsCN.com
At noon, I understood the backup and recovery of the MYSQL Cluster.
Write it down. you don't have to waste time on this issue.
1. back up data on the management
1. Back up data on the Management node.Ndb_mgm> start backupNdb_mgm> shutdownNdb_mgm> exit2. Delete SQL node data.Drop database TEST_CLUSTER;3. Disable the MYSQLD server.[Root @ localhost bin] # service mysqld stopShutting down MySQL... SUCCESS!4.
first, start and exit
1, into MySQL: Start the MySQL Command line Client (MySQL's DOS interface), directly enter the installation of the password can be. The prompt at this point is:mysql>
2, Exit Mysql:quit or exit
Second, the library operation1.
First, start and stop the MySQL Service
Net stop MySQL
Net start MySQL
Second, log on to MySQL
Syntax: mysql-u user name-P User Password
Enter the mysql-uroot-p command, press enter and prompt you to enter the password, enter 12345, and
First, start and stop the MySQL Service
Net stop MySQL
Net start MySQL
Second, log on to MySQL
Syntax: mysql-u user name-P User Password
Enter the mysql-uroot-p command, press enter and prompt you to enter the password, enter 12345, and then press
Troubleshooting of data tables:
1. When you access the webpage, an error is displayed, indicating that the database cannot be connected.
2. Start the mysql service and uninstall and disable the mysql service installed by rpm.(Install postfix
Troubleshooting of data tables:
1. When you access the webpage, an error is displayed, indicating that the database cannot be connected.
2. Start the mysql service and uninstall and disable the mysql service installed by rpm.
(Install postfix
An instance that causes damage to the mysql data table after an illegal shutdown solves bitsCN.com
Troubleshooting of data tables:
1. when you access the webpage, an error is displayed, indicating that the database cannot be connected.
2. start the
This article introduces an instance that causes damage to the mysql DATA table and the database cannot run properly due to an illegal hardware shutdown. The next step is the troubleshooting process of the author, hoping to help you.
This article
MySQL error: Ignoring the redo log due to missing mlog_checkpoint between the CHECKPOINT 63593957 and the end 63593472.MySQL version: 5.7.19System version: centos7.3MySQL running on VMware virtual machine hangs and cannot be restarted due to company
Here are the MySQL commands that we often use and are very useful. Below you see # means execute command on UNIX command line, see Mysql> is currently logged on to MySQL server, execute MySQL command on MySQL client.Login to MySQL, if you are
Common commands for MySQL database operations and Common commands for mysql
Common commands for MySQL database operationsDOS Connection database1. Install MySQL to configure the environment2. Run the cmd command. net start mysql3. Find the root
I. SQLSQL: the abbreviation of StructuredQueryLanguage Structured Query Language SQL industrial standard: SQL compiled by ANSI (ISO (core member of internationalstandardorgnation) According to industrial standards can run on any database. Dialect:
Login MySQL:
Mysql-h localhost-u root-ptest Password must have no space before you re-enter the password
Mysql-h110.110.110.110-u Root-p 123; (Note: There is no space between you and root, and so are the others.)
MySQL Commands collection
Test environment: MySQL 5.0.45
"Note: You can view the database version in MySQL by mysql> SELECT version ();"
one, the connection MySQL.
Format: mysql-h host address-u user name-P user Password
1, connected to the MySQL on the computer.
First
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.