Co jest z mysql?

[Tomasz Wittner]

Jest dobrze.

On Tue 7. of September 2004 01:27, Piotr Szymanski wrote:
> Hi,
> [root w djurban][01:21:20](~/rpm/SPECS)$ /etc/rc.d/init.d/mysql restart
> Stopping MySQL /var/lib/mysql service..............................[ DONE ]
> Starting MySQL /var/lib/mysql service..............................[ DONE ]
> [root w djurban][01:21:29](~/rpm/SPECS)$ grep grant
> /var/lib/mysql/mysqld.conf skip-grant-tables
> [root w djurban][01:21:36](~/rpm/SPECS)$ mysqladmin  -u mysql password
> 'glupiehaslo'
> mysqladmin: unable to change password; error: 'You must have privileges to
> update tables in the mysql database to be able to change passwords for
> others'
> [root w djurban][01:21:39](~/rpm/SPECS)$
> A w mysql:
> mysql> select host,user,password,update_priv from user;
> +-----------+-----------------+----------+-------------+
>
> | host      | user            | password | update_priv |
>
> +-----------+-----------------+----------+-------------+
>
> | localhost | mysql           |          | Y           |
> | djurban   | mysql           |          | Y           |
> | localhost | mysql_logrotate |          | N           |
>
> +-----------+-----------------+----------+-------------+
> 3 rows in set (0.02 sec)
>
> mysql>
>
> Mysql z 4.0.20-4, potem mysql init i mysql start. Ktos ma pomysl?
[inter w lucky 1:54 ~/rpm/SOURCES]$ mysqladmin  -u mysql password 'aqq'
[inter w lucky 1:54 ~/rpm/SOURCES]$ mysqladmin  -u mysql password 'aqq'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql w localhost' (Using password: NO)'
[inter w lucky 1:55 ~/rpm/SOURCES]$ mysqladmin  -u mysql -p password
Enter password: aqq
[inter w lucky 1:55 ~/rpm/SOURCES]$
Świeża instalacja, bez skip-grant-tables.
mysql>  select host,user,password,update_priv from user;
+------------------+-----------------+------------------+-------------+
| host             | user            | password         | update_priv |
+------------------+-----------------+------------------+-------------+
| localhost        | mysql           | 7cdd7f192c1b3d7b | Y           |
| lucky.server.dom | mysql           |                  | Y           |
| localhost        | mysql_logrotate |                  | N           |
+------------------+-----------------+------------------+-------------+

Btw: cvs up mysql.init - bez zdef. mysqld.conf w /etc/mysql/clusters.conf nie 
działało i nie było żadnych komunikatów.
-- 
Tomasz Wittner