exit mysql

Create an automatic backup scriptHere, in order to make the database tutorial backup and recovery meet our actual requirements, use a Shell script that meets the requirements to automate the entire backup process.[Root @ CentOS ~] # Vi mysql

This section describes automatic database backup and restoration methods after database destruction. Here, we use mysqlhotcopy and define a Shell script to implement automatic database backup. In addition, the entire process of automatic data backup

Backup features: A quick copy of the file, which can only run on the machine where the database directory is located, perform lock tables and UNLOCK tables online, and restore with only copy backup files to source directory coverage. Insufficient:

When the database server is established, the first thing we need to do is not to consider what MySQL-enabled programs are running on this database-supporting server, but how to recover to the last normal state after the database has been compromised,

1. Install MySQL in CentOS [root @ sample ~] # Yum-yinstallmysql-serverlarr; install MySQL and then install the PHP tool ld for accessing the MySQL database 1. Install MySQL in CentOS [root @ sample ~] # Yum-y install mysql-server larr; install

How to configure MySQL database server on CentOS BitsCN.com accidentally found CentOS Professional Forum, remember: http://www.centospub.com As a result, the initial learning configuration This environment: CentOS system, Mysql-server (version

How to configure MySQL database server on CentOS This environment: CentOS system, Mysql-server (version forgot, because it was installed using yum) The process is as follows (reprinted, according to detailed installation requirements, slightly add

Establish an automatic backup scriptHere, in order to make the database tutorials backup and restore meet our actual requirements, use a qualifying shell script to automate the entire backup process.[Root@centos ~]# vi mysql Tutorial-backup.sh← set

Install MySQL. [Root @ sample ~] # Yum-yinstallmysql-server Plugin install MySQL[Root @ sample ~] # Yum-yinstallphp-mysql plugin install php-mysql Configure MySQL [Root @ sample ~] # Vim/etc/my. cnf plugin edit the MySQL configuration

I. Preface: After the database server is set up, the first thing we need to do is not to consider which MySQL-carried servers should be running on the server that supports the database.ProgramBut how to recover to the last normal state after the

Today in the company, the morning was engaged for one hours, MySQL Single instance startup script is done.[[email protected] scripts]# cat test3.sh #!/bin/bashretval=0. /etc/init.d/

Install MySQL. [Root @ sample ~] # Yum-y install mysql-Server Plugin install MySQL[Root @ sample ~] # Yum-y install PHP-mysql plugin install PHP-MySQL Configure MySQL [Root @ sample ~] # Vim/etc/My. CNF plugin edit the MySQL configuration

MySQL disables the remote logon permission by default. The following operations allow users to log on to any location: 1. go to MySQL and grant all privileges on *. * To 'root' @ '%' identified by ''with grant option; identified by is followed by a

MySQL by default to turn off Telnet permissions, the following actions allow users to log in any location: 1. Enter mysql,grant all privileges on * * to ' root ' @ '% ' of ' identified by ' with the GRANT option;identified by followed by a password

1. Enter mysql,grant all privileges on * * to ' root ' @ '% ' identified by ' with the GRANT option;identified by followed by a password that can be set to null. 2. FLUSH privileges; Update MySQL for security, by default the user is allowed to log

First, confirm that the firewall does not block port 3306 (the general server will be blocked by default)Windows Firewall Exception Setting methodControl Panel (select View as large icon in upper right corner)---Firewall---Advanced

MySQL by default to turn off Telnet permissions, the following actions allow users to log in any location: 1. Enter mysql,grant all privileges on * * to ' root ' @ '% ' of ' identified by ' with the GRANT option;identified by followed by a password

All of the following steps are performed using the command line method. 1. Start and close MySQL (1) Start MySQL service netstartmysql (2) Stop MySQL service netstopmysql 2. log on and exit MySQL. First, let's take a look at some important mysql

Original Website: Http://hi.baidu.com/feifei435/item/f6bf260c62c82373bee97ed6 MySQL disables the remote logon permission by default. The following operations allow users to log on to any location: 1. go to MySQL and grant all privileges on *. * To

MYSQL remote logon permission settings Mysql disables remote logon by default. The following operations allow users to log on to any location: 1. go to mysql and grant all privileges on *. * TO 'root' @ '%' identified by ''with grant option;