點擊鏈接No thanks, just start my download.直接下載。
下載完成後將Yum庫導入到妳的本地:
sudo yum localinstallmysql-community-release-el6-*.noarch.rpm
這個Yum庫包含了MySQLServer,MySQL工作臺管理工具以及ODBC驅動,現在可以通過下面的命令簡單地安裝MySQLServer:
sudo yum install mysql-community-server
至此我就可以使用Yum簡單地管理MySQL更新,並能確保總是從官網軟件庫得到最新的發布版。
附錄:
1、root password update failed
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
解決辦法:
[**@localhost ~]# mysql
mysql> set global read_only=0;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
[**@localhost ~]# /usr/bin/mysql_secure_installation
如此便可以重新更新root密碼了!
2、[ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
解決辦法:進入妳的mysql數據存放目錄,刪除ibdata1文件即可,例如在我的環境下
#cd /var/lib/mysql
#mv ibdata1 ibdata1.bak
3、[ERROR] InnoDB: space header page consists of zero bytes in data file ./ibdata1
解決辦法:修改配置文件my.cnf
根據個人環境空間大小和需求調節如下參數的值
innodb_buffer_pool_size = 256M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
添加壹條:
innodb_flush_method=normal
4、ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解決辦法:Google上有很多,我遇到這個情況的時候只是使用/usr/bin/mysql_secure_installation 重新設置壹次。