Помогите MySQL с установкой на Mandriva 2008 Spring Free (Mandriva 2008.1)

[FreeOwl]

Помогите MySQL с установкой на Mandriva 2008 Spring Free (Mandriva 2008.1)

Здравствуйте!

Прошу помощи в установке MySQL на Mandriva 2008 Spring Free (Mandriva 2008.1)
Устанавливаю так:

urpmi MySQL MySQL-client libmysql15-devel

Для удовлетворения зависимостей будут установлены следующие пакеты:
Пакет Версия Релиз Платформа
(источник "main")
perl-DBD-mysql 4.006 2mdv2008.1 i586
(источник "main_updates")
libmysql-devel 5.0.51a 8.1mdv2008.1 i586
mysql 5.0.51a 8.1mdv2008.1 i586
mysql-client 5.0.51a 8.1mdv2008.1 i586
mysql-common 5.0.51a 8.1mdv2008.1 i586
Будет использовано 29МБ дополнительного дискового пространства.
Будет загружено 13МБ пакетов.
Установить 5 пакетов? (Y/n) Y

ftp://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/official/2008.1/i586/media/main/release/perl-DBD-mysql-4.006-2mdv2008.1.i586.rpm
ftp://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/official/2008.1/i586/media/main/updates/libmysql-devel-5.0.51a-8.1mdv2008.1.i586.rpm
ftp://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/official/2008.1/i586/media/main/updates/mysql-client-5.0.51a-8.1mdv2008.1.i586.rpm
ftp://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/official/2008.1/i586/media/main/updates/mysql-common-5.0.51a-8.1mdv2008.1.i586.rpm
ftp://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/official/2008.1/i586/media/main/updates/mysql-5.0.51a-8.1mdv2008.1.i586.rpm
устанавливается libmysql-devel-5.0.51a-8.1mdv2008.1.i586.rpm mysql-client-5.0.51a-8.1mdv2008.1.i586.rpm perl-DBD-mysql-4.006-2mdv2008.1.i586.rpm mysql-common-5.0.51a-8.1mdv2008.1.i586.rpm mysql-5.0.51a-8.1mdv2008.1.i586.rpm из /var/cache/urpmi/rpms
Подготовка... #############################################
1/5: mysql-client #############################################
2/5: perl-DBD-mysql #############################################
3/5: mysql-common #############################################
4/5: libmysql-devel #############################################
5/5: mysql #############################################
Warning: fuse is needed by mysqld in runlevel 2
Warning: netfs is needed by mysqld in runlevel 2

......................................................................

Warning: fuse is needed by mysqld in runlevel 2
Warning: netfs is needed by mysqld in runlevel 2
----------------------------------------------------------------------
Дополнительная информация о пакете mysql-5.0.51a-8.1mdv2008.1.i586

The initscript used to start mysql has been reverted to use the one shipped
by MySQL AB. This means the following changes:

* The MYSQLD_OPTIONS="--skip-networking" option in the /etc/sysconfig/mysqld
file has been removed, this is now set in the /etc/my.cnf file.

* The MySQL Instance Manager is used by default, set use_mysqld_safe="1" in
the /etc/sysconfig/mysqld file to use the old mysqld_safe script.

* The generation of the initial system mysql database is now done when mysql
is started from the initscript and only if the /var/lib/mysql/mysql
directory is empty (mysql_install_db). Previousely this was quite hidden and
silently done at (rpm) install time.

The extra MySQL-NDB server package has been merged into the MySQL-Max package
and ndb related pieces has been split into different sub packages as done by
MySQL AB. The MySQL libraries and the MySQL-common sub package uses the
MySQL-Max build so that no functionality required by for example the NDB
parts are lost.

The MySQL-common package now ships with a default /etc/my.cnf file that is
based on the my-medium.cnf file that comes with the source code. The
/etc/my.cnf file is constructed at build time of this package.

To connect to the Instance Manager you need to pass the correct command line
options like in the following examples:

* mysql -u root --password=my_password --port=2273 --protocol=TCP
* mysql -u root --password=my_password --socket=/var/lib/mysql/mysqlmanager.sock

Please note you also need to add a user in the /etc/mysqlmanager.passwd file and
make sure the file is owned by the user under which the Instance Manager service
is running under.

----------------------------------------------------------------------

Вопрос 1: а что такое "Warning: fuse is needed by mysqld in runlevel 2 и Warning: netfs is needed by mysqld in runlevel 2"
Далее коментируем skip-networking (причина)

vi /etc/my.cnf

[...]
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
[...]

chkconfig mysqld on

запускаем

/etc/init.d/mysqld start

получаем

Starting MySQL: [ OK ]

проверяем

netstat -tap | grep mysql

получаем

tcp 0 0 *:mysql-im *:* LISTEN 11825/mysqlmanager
tcp 0 0 *:mysql *:* LISTEN 11833/mysqld
getnameinfo failed

Вопрос 2: А что такое "подчёркнутое"?
Далее я должен был сделать:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
но:

mysqladmin -u root password myrootsqlpassword

а в ответ:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Вопрос 3: почему как исправить?

mysqladmin -h my.server.com -u root password myrootsqlpassword

mysqladmin: connect to server at 'my.server.com' failed
error: 'Host 'localhost' is not allowed to connect to this MySQL server'

Вопрос 4: почему как исправить? :| и при чём тут localhost ?!?!?!??!

Помогите, ПЛЗ. Где чего отредактировать, подправить? а?

Спасибо

-~{}~ 05.08.08 13:49:

Вопрос 3 - решён.
Решение:

MySQL при запуске на localhost выдает ошибку Mandriva 2008.1

Это ошибка самой версии MySQl 5.0.3, которая дает сбой, если имя хоста совпадает с localhsot. Для решения проблемы достаточно запустить следующие команды:

[root@localhost ~]# rpm -e mysql 

[root@localhost ~]# rm -f /var/lib/mysql/mysql/*

[root@localhost ~]# /bin/hostname 127.0.0.1

[root@localhost ~]# urpmi mysql

Хотя кто бы обьяснил, при чём тут локалхост....
PS полный вариант здесь