Various MySQL management tools

MySQL management tools 1. mysql, mysqladmin, mysqldump www.2cto.com mysql client program 1. common format for connecting to the database server: mysql-u root-p enter the password to log on to the MySQL server. 2. Import the database backup file: mysql-u root-p create newdbnamepasswd: * ** mysql-u root-p newdbname <backupfile. sqlpasswd: *** the mysqladmin program is mostly used for system management tasks. 1. create a database: createmysqladmin-u root-p create newdatabase2. delete a database: dropmysqladmin-u root-p drop newdatabase3, modify the MySQL user password: mysqladmin-u root-p password "ne W password "password: old possword www.2cto.com mysqldump is mostly used for database backup mysqldump-u root-p dbname> backfile. SQL can back up the database into a text file named "、phpmyadmin(phpmyadmin-3.5.4-all-languages.zip), which is very convenient and powerful, but must be used together with apache and php. Decompress the file and put the folder into the apache htdocs directory. Open http: // localhost/phpMyAdmin/index. php In the browser to conveniently manage the mysql database.