Hi mysql-listers
mysql> select version(); +--------------------+ | version() | +--------------------+ | 4.1.7-standard-log | +--------------------+ 1 row in set (0.10 sec)
mysql>
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>
following mysql-behaviour made me loose several hours yesterday:
1. a root user is installed with password having overall permission over the database.
i can access the db through this root user in the following manner:
[EMAIL PROTECTED]:~> mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 4.1.7-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
2. for the sake of an application i added a second user named "root", but this one from the host rosetta. i added the password for this second root user using
use mysql;
update user set password ... where user = "root" and host = "rosetta.ayni.com";
flush privileges;
the password i attributed to this root-user is the same as that one for the original root user.
my intention was to access the database in the following manner:
[EMAIL PROTECTED]:~> mysql -h rosetta -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.7-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
3. this second root-user, however, presented the following strange behaviour:
i could access the database in the manner described in 2. several times. and then, at once, access was denied, and i had to redo the
flush privileges;
from then on, i could access the db again several times as described in 2., but again after some time, access was denied and i had to redo the
flush privileges;
4. what i did then:
4.a took a mysqldump of the entire mysql installation. 4.b stopped the mysql daemon 4.c removed the entire directory where the database had been 4.d uninstalled mysql-server 4.e re-installed mysql-server 4.f re-created the database from the mysqldump
5. remains to be seen if now mysql is stable
suomi
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]