[Rezolvat] Mysql in Mandriva 2011

Corec,

Am dezinstalat tot ce aveam mysql si am instalat din nou, iata pasii

[root@localhost viorel]# urpmi mysql
To satisfy dependencies, the following packages are going to be installed:
Package Version Release Dist DEpoch Arch
(medium "Main")
lib64aio1 0.3.109 3 mdv 2011.0 x86_64
mysql 5.5.15 1 mdv 2011.0 x86_64
mysql-client 5.5.15 1 mdv 2011.0 x86_64
mysql-common 5.5.15 1 mdv 2011.0 x86_64
mysql-common-core 5.5.15 1 mdv 2011.0 x86_64
mysql-core 5.5.15 1 mdv 2011.0 x86_64
72MB of additional disk space will be used.
Proceed with the installation of the 6 packages? (Y/n) y
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/mysql-common-5.5.15-1-mdv2011.0.x86_64.rpm
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/mysql-core-5.5.15-1-mdv2011.0.x86_64.rpm
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/mysql-client-5.5.15-1-mdv2011.0.x86_64.rpm
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/mysql-5.5.15-1-mdv2011.0.x86_64.rpm
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/mysql-common-core-5.5.15-1-mdv2011.0.x86_64.rpm
rsync://ftp.iasi.roedu.net/mirrors/ftp.mandrake.com/official/2011/x86_64/media/main/release/lib64aio1-0.3.109-3-mdv2011.0.x86_64.rpm
installing mysql-common-5.5.15-1-mdv2011.0.x86_64.rpm mysql-core-5.5.15-1-mdv2011.0.x86_64.rpm mysql-client-5.5.15-1-mdv2011.0.x86_64.rpm mysql-common-core-5.5.15-1-mdv2011.0.x86_64.rpm mysql-5.5.15-1-mdv2011.0.x86_64.rpm lib64aio1-0.3.109-3-mdv2011.0.x86_64.rpm from /var/cache/urpmi/rpms
Preparing... ###########################################################################
1/6: mysql-common-core ###########################################################################
2/6: mysql-client ###########################################################################
3/6: lib64aio1 ###########################################################################
4/6: mysql-common ###########################################################################
5/6: mysql-core ###########################################################################
6/6: mysql ###########################################################################
----------------------------------------------------------------------
More information on package mysql-5.5.15-1-mdv2011.0.x86_64
The initscript used to start mysql has been reverted to use the one shipped
by MySQL AB. This means the following changes:
* 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. As a consequence to this change you may
have to perform some manual tasks to upgrade the mysql system database and
such. So, doing something like this might help you:
/etc/rc.d/init.d/mysqld stop
TMPDIR=/var/tmp mysql_install_db
mysql_upgrade
The cluster functionalities (ndb) has been deactivated and will be removed in
future mysql versions. A new product named mysql-cluster has been added (in
contrib) that replaces the cluster functionalities.
The mysql-common-core package ships with a default /etc/my.cnf file that is
based on the my-medium.cnf file that comes with the source code.
Starting from mysql-5.1.43-2 the storage engines is built as dynamically
loadable modules. You can either load the engines using the /etc/my.cnf file or
at runtime. Please look at these lines in the /etc/my.cnf file to enable
additional engines or disable one or more of the default ones:
plugin_dir=/usr/lib64/mysql/plugin
plugin-load=ha_archive.so;ha_blackhole.so;ha_federated.so
Starting from mysql-5.1.44-3 the html documentation and the mysql.info is not
shipped with the Mandriva packages due to strict licensing.
----------------------------------------------------------------------
[root@localhost viorel]# /etc/init.d/mysqld status
[FAILED]
[root@localhost viorel]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): [ OK ]
[root@localhost viorel]# /etc/init.d/mysqld stop
Stopping mysqld (via systemctl): [ OK ]
[root@localhost viorel]# mysqld_safe --skip-grant-tables &
[1] 10486
[root@localhost viorel]# 110910 17:08:09 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'.
110910 17:08:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.15 Mandriva Linux - MySQL Community Edition (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD ("pass") where User='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@localhost viorel]# /etc/init.d/mysqld stop
Stopping mysqld (via systemctl): [ OK ]
[root@localhost viorel]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
[root@localhost viorel]# /etc/init.d/mysqld restart
Restarting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
[root@localhost viorel]# /etc/init.d/mysqld stop
Stopping mysqld (via systemctl): [ OK ]
[root@localhost viorel]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
[root@localhost viorel]# /etc/init.d/mysqld stop
Stopping mysqld (via systemctl): [ OK ]
[root@localhost viorel]# /etc/init.d/mysqld status
[ OK ]
[root@localhost viorel]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
[root@localhost viorel]# /etc/init.d/mysqld restart
Restarting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
[root@localhost viorel]#

si dupa cum se vede tot nu merge, unde oare sa fi gresit, ca nu instalez prima data mysql...

Multumesc de orice sugestie

Multumesc, de corectare...

am reusit ceva....
problema era cand editez /etc/my.cnf
randul acesta: master-host = localhost, asa nu merge
daca il pun: #master-host = localhost, merge fara probleme
eu mai inainte configuram asa si nu era probleme dar acum vad ca nu merge...
o sa mai incerc si alte obtiuni, multumesc de ajutor


[root@localhost viorel]# ps aux | grep mysql
root 19931 0.0 0.0 12732 1652 ? S 17:50 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
mysql 20278 0.0 1.1 472396 42012 ? Sl 17:50 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/localhost.localdomain.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root 22185 0.0 0.0 105596 900 pts/1 S+ 17:53 0:00 grep --color mysql
[root@localhost viorel]#

in my.cnf randul #master-host = localhost e comentariu,
daca scot comentariu, iata ce imi arata

[root@localhost viorel]# ps aux | grep mysql
root 23255 0.0 0.0 105592 900 pts/1 S+ 17:54 0:00 grep --color mysql
[root@localhost viorel]#

cred ca in my.cnf e problema, nu fac setarile corect

Multumesc de ajutor