。cant find any matching row in the user table
當將資料庫整個匯出入到另一系統時,存取資料庫連不上?
帳號密碼都在,想說是不是 old_password的問題,
指令一執行下去,出現can't find any matching row in the user table訊息,
原來要 flush privileges;
。MySQL如何升級
http://freesf.tnc.edu.tw/modules/newbb/viewtopic.php?topic_id=13&forum=1
。total memory等於
total memory = key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
。匯入資料庫出現MySQL server has gone away錯誤訊息
修正方式
vi /etc/my.cnf
[mysqld]
set-variable = max_allowed_packet=16M
。mysqdump時遇到 Out of memory問題
參考: http://plog.longwin.com.tw/post/1/407
作法一,設定 my.cnf, 設定以下參數, max_allowed_packet=16M 可隨機再調大.
[mysqldump] quick max_allowed_packet = 16M
作法二,使用 -q (–quick) 的參數, 使用此參數就不會使用到 Memory.
使用範例: mysqldump -q -u root DB_NAME > DB_NAME.sql
原廠的說明是如下:
–quick, -q
This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
。Function not implemented
71006 11:09:47 mysqld started
071006 11:09:47 [ERROR] bdb: unable to initialize mutex: Function not implemented
071006 11:09:47 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
071006 11:09:47 InnoDB: Started; log sequence number 0 43634
071006 11:09:47 [ERROR] Can't init databases
071006 11:09:47 [ERROR] Aborting071006 11:09:47 InnoDB: Starting shutdown…
071006 11:09:49 InnoDB: Shutdown completed; log sequence number 0 43634
071006 11:09:49 [Note] /usr/libexec/mysqld: Shutdown complete071006 11:09:49 mysqld ended
Quote: http://rimuhosting.com/howto/mysqlinstall.jsp
Resolving: [ERROR] bdb: unable to initialize mutex: Function not implemented.
You may see this on Debian systems upgrading to MySQL 4.1. It results from your server not having the Berkely database library files necessary to support that table type in MySQL. The BDB table type is not that common. So you can just skip support for it. Add a skip-bdb line to your my.cnf file (/etc/mysql/my.cnf on Debian and /etc/my.cnf on RedHat boxes).
ref: http://www.centos.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=551&forum=31
。在 phpmyadmin 上看到的 大小 多餘
Quote: http://phorum.study-area.org/viewtopic.php?t=37736&view=previous&sid=492ddd895a9e2ab23ac9cdce4bc5609e
當你刪除資料表內的資料, 那些資料原來佔用的空間就會空在那裏…
這些空間就是所謂"多餘"的… 如果是 MySQL 可以用 OPTIMIZE TABLE 來清理這些空間
。解決Client does not support authentication protocol requested by server
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('123456');
或者
use mysql;
UPDATE user SET PASSWORD=OLD_PASSWORD('123456') WHERE Host='localhost' AND User='root';
FLUSH PRIVILEGES;
留言