Hallo zusammen, am Freitag, 3. Oktober 2008 meinte Pitt Leidner um 15:08:
doch bevor ich mich jetzt ausdrücklich bedanke und den Thread als gelöst kennzeichne, fahre ich mal mit der Einrichtung von MySQL fort ;)
Der Weise übt sich in Demut! :-)
war nicht ganz unberechtigt. Schon nach einem Versuch, ein root Passwort zu setzen, war alles wieder platt und das Spiel ging von vorn los. :( Habe jetzt wieder von vorn angefangen, und mysql_multi in Yast|Syssconfig abgeschaltet. Der Start sieht schon mal anders aus. Ich will mal versuchen, alles Weitere in dieser eMail zu dokumentieren: § # rcmysql start Creating MySQL privilege database... Installing MySQL system tables... OK Filling help tables... OK PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux-vsd5.site password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com Updating MySQL privilege database... Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.func OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.proc OK mysql.procs_priv OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... OK Starting service MySQL done $ # rcmysql status Checking for service MySQL: running $ # Start erstmal wieder gelungen :) Jetzt ein Passwort setzen: $ # /usr/bin/mysqladmin -u root password 'new-password' wird ohne Ausgabe quittiert und nach einmal mit: $ # /usr/bin/mysqladmin -u root -h linux-vsd5.site password 'new-password' /usr/bin/mysqladmin: connect to server at 'linux-vsd5.site' failed error: 'Host 'linux-vsd5.site' is not allowed to connect to this MySQL server' wird gemeckert?? jetzt mal mysql stoppen: $ # rcmysql stop Shutting down service MySQL done und neu starten und wieder beenden: $ # rcmysql start Starting service MySQL done $ # rcmysql status Checking for service MySQL: running $ # rcmysql stop Shutting down service MySQL done mal sehen ob der user mysql MySQL starten kann? $ # mysqld_safe --user=mysql & [1] 9867 $ # nohup: ignoriere Eingabe und leite Standardfehlerausgabe auf Standardausgabe um Starting mysqld daemon with databases from /var/lib/mysql ab jetzt geht nichts mehr, auch rcmysql startet den Dienst nicht mehr $ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) linux-vsd5:/usr/bin # rcmysql start Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds done mal sehen was passiert ist: $ # rcmysql status Checking for service MySQL: unused hier mal einm Auszug aus /var/lib/mysql/mysld.log, bis zu dem Zeitpunkt, als dann nichts mehr ging: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 081003 15:52:34 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081003 15:52:34 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081003 15:52:34 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081003 15:52:34 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081003 15:52:34 InnoDB: Started; log sequence number 0 0 081003 15:52:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.51a' socket: '/var/lib/mysql/.protected/mysql.sock' port: 0 SUSE MySQL RPM 081003 15:52:35 [Note] /usr/sbin/mysqld: Normal shutdown 081003 15:52:35 InnoDB: Starting shutdown... 081003 15:52:37 InnoDB: Shutdown completed; log sequence number 0 43655 081003 15:52:37 [Note] /usr/sbin/mysqld: Shutdown complete 081003 15:52:37 mysqld ended 081003 15:52:37 mysqld started 081003 15:52:37 InnoDB: Started; log sequence number 0 43655 081003 15:52:37 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.51a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 081003 16:03:24 [Note] /usr/sbin/mysqld: Normal shutdown 081003 16:03:24 InnoDB: Starting shutdown... 081003 16:03:25 InnoDB: Shutdown completed; log sequence number 0 43655 081003 16:03:25 [Note] /usr/sbin/mysqld: Shutdown complete 081003 16:03:25 mysqld ended 081003 16:03:31 mysqld started 081003 16:03:31 InnoDB: Started; log sequence number 0 43655 081003 16:03:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.51a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 081003 16:04:01 [Note] /usr/sbin/mysqld: Normal shutdown 081003 16:04:01 InnoDB: Starting shutdown... 081003 16:04:01 InnoDB: Shutdown completed; log sequence number 0 43655 081003 16:04:01 [Note] /usr/sbin/mysqld: Shutdown complete 081003 16:04:01 mysqld ended 081003 16:04:06 mysqld started nohup: ignoriere Eingabe 081003 16:04:06 InnoDB: Started; log sequence number 0 43655 081003 16:04:06 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.51a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 081003 16:06:13 mysqld started InnoDB: Unable to lock ./ibdata1, error: 11 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ und das Ende dieser Datei: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 081003 16:27:42 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 081003 16:27:42 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 081003 16:27:42 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 081003 16:27:42 [ERROR] Do you already have another mysqld server running on port: 3306 ? 081003 16:27:42 [ERROR] Aborting 081003 16:27:42 [Note] /usr/sbin/mysqld: Shutdown complete 081003 16:27:42 mysqld ended ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ die datei mysqld.log gibt es mit identischem Inhalt auch noch einmal unter /var/log/mysqld.log Ich gehe mal davon aus, dass hier wohl ein Bedienfehler vorliegt, sonst würde mysql ja bei euch nicht laufen. Ich habe mich mit der Befehlsrefenrenz u.a. nach der Ausgabe beim ersten Start von rcmysql gerichtet und dann auch nach "Schritte nach der Installation von MySQL: http://dev.mysql.com/doc/refman/5.1/de/unix-post-installation.html Was mache ich hier falsch? -- Beste Grüße Christian Gut, das XMMS gerade Eric Burdon & The Animals - House of rising sun spielt :music: The Bat! 4.0.34.6 unter SuSE 11.0 und Wine 1.0 -- Um die Liste abzubestellen, schicken Sie eine Mail an: opensuse-de+unsubscribe@opensuse.org Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken Sie eine Mail an: opensuse-de+help@opensuse.org