This information comes from the mysql.cn forum, thank you for your friends who have contributed! 1. About MySQL5MYSQL5 series database is the latest version of the database of MySQL, and the popular release is mysql-5.0.18. MySQL English official website is http://www.mysql.com II. Get all the mysql databases for all the mysql databases, you can download it in its English official website, but given the English in all people, So I suggest that I don't find the procedure you need, if I can't find it, I will find English. MySQL5 has a score of installation and free installation, as the name suggests, the installation version is to use after you need to install; you can use it after the installation version of MySQL download, or make simple settings. MySQL5 installation version download address: Windows version: http://download.mysql.cn/src/2006/0218/199.htmllinux version (source package): http://download.mysql.cn/src/2006/0208/ 62.htmlmlMysql5 free installation version download address: Windows version: http://download.mysql.cn/src/2006/0302/205.html three, mysql5 installation Windows Installation Manual: http://bbs.mysql.cn/ Thread-261-1-1.htmllinux version (source package) Installation manual: http://bbs.mysql.cn/thread-493-1-2.htmlWindows Free installation version manual: http: //bbs.mysql. CN / Thread-552-1-1.html 4, backup and recovery regular backup commands are mysqldump, here is a TM database as an example, make a brief introduction, detail reference http://info.mysql.cn/install/2006/ 0410 / 5521.html Backup: #mysqldump -u root -p TM> TM_20060101.SQL Enter the password by prompt, backed up all TM databases to TM_20060101.SQL, because always backup work, if The data volume is a large space, which can utilize Gzip compressed data, the command is as follows: #mysqldump -u root -p TM | Gzip> TM_20060101.SQL.GZ can also be backed up to the remote machine, using -H, such as #mysqldump -u root -p tm> TM_20060101.sql -h xxx.xxx.xxx.xxx can be backed up directly to the IP address for remote computers for xxx.xxx.xxx.xxx.
When the system crashes, rebestructs the system, or restores the database, you can restore data: #mysql -u root -p TM If it is phpMyadmin 2.8.0.2 or higher, this will be reported because the default does not have the configuration file config.default.php required for this software, and this file is in version 2.6.x, just password is wrong. For version 2.6.x versions, you can open this file directly with the text editor, modify the contents of the first $ cfg into your own username and password: $ cfg ['Servers'] [$ I] [ 'auth_type'] = 'config'; // Authentication Method (config, http or cookie based)? $ cfg ['servers'] [$ I] ['user'] = 'root'; // mysql user $ cfg [ 'Servers'] [$ I] ['password'] = 'own password'; if you don't set a password, the system will prompt: Access Denied for user 'root' @ 'localhost' (using password: no) if it is 2.8. 0.2 Versions, programs will be prompted to run Scripts / setup.php to generate config.inc.php files. Q: Why did I use mysql garbled? A: The default character set when installing mysql5 is Sweden Code Latin1, and Chinese does not support Chinese. And there are many reasons for garbled, it is recommended to find answers to the bbs.mysql.cn forum. If you are posted, please specify your own environment, installation process and information for you to quickly analyze your questions quickly. Q: Why can't my phpmyadmin prompt not load MySQL extension? A: 1. Look at your PHP directory and PHP / EXT has a PHP_MYSQL.DLL this file. Second, formulate the environment variable to add the directory where PHP_MYSQL.DLL is in the PATH. Third, some PHP installations are installed, under the installation path, there is no EXT folder (do not know why), it is best to download a configured PHP, then copy the exe folder to the installation directory, then make the corresponding Configuration. Fourth, look at the php_mysql.dll in the php_mysql.dll under the PHP.ini file under the PHP.INI file under WINDOW; if you don't get it, then put libmysql.dll The root directory of the installation of PHP is generally c: / php, and it is also placed under C: / Windows, and then restart IIS or Apache. Sometimes I always refresh one page, even if I go to the semicolon, I still can't load mySQL extension, and finally open a window, try again. Q: Why can't I see hatching pool? A: MySQL.CN's hatching pool is a place specializing for beginners. I will not introduce it here. For details, please visit: http://bbs.mysql.cn/thread-369-1-1.html. Q: Can you be a Chinese database name? A: Yes, but not recommended, it is inconvenient. Q: If I have forgotten the root password, what should I do? A: Under Windows: Open the Command Line window, stop MySQL service: Net Stop MySQL Start MySQL, generally to MySQL installation path, find mysqld-nt.exe execution: mysqld-nt --skip-grant-Tables Except for another command Row window, execute mysql> use mysql> update user set password = password ("new_pass") where user = "root";> Flush privileges;> EXIT with Ctrl Alt Del, find MySQLD-NT process to kill it, On restarting the MySQL-NT service, you can log in with the new password under Linux: If mysql is running, first kill: killall -term mysqld. Start mysql: bin / safe_mysqld --skip-grant-tables & you can enter MySQL without a password. Then it is> Use mysql> update user set password = password ("new_pass") where user = "root";> flush privilege; re-mysql, start MySQL with normal method. Q: Why is the following tips: [root @ 0-8-2-df-fa-ee ~] # mysqlerr 2002 (HY000): can't connect to local mysql server through socket '/tmp/mysql.sock' 2) Note: It may also be the mysql.socka under other paths: Description MySQL service is not started, mysql.sock is started after the MySQL service starts, usually killed the MySQL service first: killall mysql then, then according to your own installation The situation is started with MySQL. For example, when installing, use ./configure --prefix = / usr / local / mysql starts: / usr / local / mysql / bin / mysqld_safe --user = mysql & then go to execute / USR / local / mysql / bin / mysql -u root -p login Enter the mysql database Q: Why appear below the following error # 1251 - Client Does Not Support Authentication Protocol Requested by Server; Consider Upgrading MySQL Clienta: The database you use is 4.1 or more After connecting the MySQL database with the command line, execute the following command: update mysql.user set password = Old_password ("Your_password") where host = "Your_host" and user = "Your_username"; can be resolved.
