Mysql funzt nicht !

Cr4shedx · 10/03/2013, 16:50

Hallo,

Hab schon einiges probiert, funktioniert hatt aber leider nichts.
Ich hab mir vor kurzem einen neuen Server gekauft und alles installiert.
jetzt will ich mit navicat connecten dann kommt folgendes :

Code:

1130-Host 'xxxx' is not allowed to connect to this MySQL server

Konnte außerdem den befehl:

Code:

mysql -u root -p

nicht ausführen fehlermeldung:

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Bitte helft mir bin am verzweifeln!

Mfg Cr4shedx

iXN'22 · 10/03/2013, 18:42

User anlegen

1. Mysql Server stoppen: Service mysql-server stop

2. Tabelle abspeichern: mysqld_safe --skip-grant-tables

Putty oder die Console die du benutzt neu Öffnen und einloggen ( mit user root)

3. Einloggen mit dem User root einloggen in die MySQL Console: mysql --user=root mysql

4. Wenn du einen User hast dan Passwort ändern was du in diesem fall nicht hast: update user set Password=PASSWORD('hier-neues-passwort-eintragen') where user='root';

In deinem Fall User anlegen:

4. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' Enter drücken
IDENTIFIED BY 'Dein Passwort' WITH GRANT OPTION;

5. Aus der MySQL Console ausloggen: exit;

6. Mysql neustarten: service mysql-server restart

und mit deinem User und Passwort einloggen.

Quelle: Elitepvpers von .Nouce

EisTee, · 10/03/2013, 18:54

Falls dein Problem weiter hin besteht "Melde dich bei mir oder nochmal im Thread.

Cr4shedx · 10/03/2013, 21:24

Hab sufu schon benutzt

Wenn ich mysql --user=root mysql in die Console eingebe kommt

Code:

RROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Coniesan · 10/03/2013, 21:25

Hierzu kann ich nur eins sagen (FACEPALM)

Spoiler

1. einen Admin User legt man über die Console folgendermaßen an:

Code:

GRANT ALL PRIVILEGES ON *.* to 'user'@'%' IDENTIFIED BY 'password';

2. Bei der oben genannten Fehlermeldung wird ausschließlich gesagt, dass MySQL nicht läuft! D.h. aus irgend einem Grund wurde es nicht gestartet, oder hat es sich nach dem Start direkt beendet, oder kam erst gar nicht so weit!
ERGO: wir gucken in der Error Datei nach! Zu finden unter:

Code:

/var/db/mysql/hostname.err

Wie bekomm ich heraus, wie mein Hostname lautet? Ganz einfach mit folgendem Command (in Putty)

Code:

hostname

Wenn wir also nun unseren Fehler kennen (steht ja in der .err File) dann kann man entweder good old Google befragen, oder den Log hier rein posten!

Cr4shedx · 10/03/2013, 21:29

Hier die Fehler:

Spoiler

Code:

131002 23:42:03 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131002 23:42:03 InnoDB: The InnoDB memory heap is disabled
131002 23:42:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131002 23:42:03 InnoDB: Compressed tables use zlib 1.2.3
131002 23:42:03 InnoDB: Initializing buffer pool, size = 128.0M
131002 23:42:03 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
131002 23:42:03  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131002 23:42:03  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...
131002 23:42:04  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: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131002 23:42:04  InnoDB: Waiting for the background threads to start
131002 23:42:05 InnoDB: 5.5.34 started; log sequence number 0
131002 23:42:05 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131002 23:42:05 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
131002 23:42:05 [Note] Server socket created on IP: '0.0.0.0'.
131002 23:42:05 [Note] Event Scheduler: Loaded 0 events
131002 23:42:05 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.34'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
131002 23:42:13 [Note] /usr/local/libexec/mysqld: Normal shutdown

131002 23:42:13 [Note] Event Scheduler: Purging the queue. 0 events
131002 23:42:13  InnoDB: Starting shutdown...
131002 23:42:14  InnoDB: Shutdown completed; log sequence number 1595675
131002 23:42:14 [Note] /usr/local/libexec/mysqld: Shutdown complete

131002 23:42:14 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131002 23:43:05 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131002 23:43:05 InnoDB: The InnoDB memory heap is disabled
131002 23:43:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131002 23:43:05 InnoDB: Compressed tables use zlib 1.2.3
131002 23:43:05 InnoDB: Initializing buffer pool, size = 128.0M
131002 23:43:05 InnoDB: Completed initialization of buffer pool
131002 23:43:05 InnoDB: highest supported file format is Barracuda.
131002 23:43:05  InnoDB: Waiting for the background threads to start
131002 23:43:06 InnoDB: 5.5.34 started; log sequence number 1595675
131002 23:43:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131002 23:43:06 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
131002 23:43:06 [Note] Server socket created on IP: '0.0.0.0'.
131002 23:43:06 [Note] Event Scheduler: Loaded 0 events
131002 23:43:06 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.34'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
131003 14:43:17 [Note] /usr/local/libexec/mysqld: Normal shutdown

131003 14:43:17 [Note] Event Scheduler: Purging the queue. 0 events
131003 14:43:17  InnoDB: Starting shutdown...
131003 14:43:18  InnoDB: Shutdown completed; log sequence number 1595675
131003 14:43:18 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 14:43:18 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131003 14:43:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131003 14:43:31 InnoDB: The InnoDB memory heap is disabled
131003 14:43:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131003 14:43:31 InnoDB: Compressed tables use zlib 1.2.3
131003 14:43:31 InnoDB: Initializing buffer pool, size = 128.0M
131003 14:43:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131003 14:43:31 [ERROR] Plugin 'InnoDB' init function returned error.
131003 14:43:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131003 14:43:31 [ERROR] Unknown/unsupported storage engine: InnoDB
131003 14:43:31 [ERROR] Aborting

131003 14:43:31 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 14:43:31 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131003 14:46:00 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131003 14:46:00 InnoDB: The InnoDB memory heap is disabled
131003 14:46:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131003 14:46:00 InnoDB: Compressed tables use zlib 1.2.3
131003 14:46:00 InnoDB: Initializing buffer pool, size = 128.0M
131003 14:46:00 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131003 14:46:00 [ERROR] Plugin 'InnoDB' init function returned error.
131003 14:46:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131003 14:46:00 [ERROR] Unknown/unsupported storage engine: InnoDB
131003 14:46:00 [ERROR] Aborting

131003 14:46:00 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 14:46:00 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131003 14:57:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131003 14:57:53 InnoDB: The InnoDB memory heap is disabled
131003 14:57:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131003 14:57:53 InnoDB: Compressed tables use zlib 1.2.3
131003 14:57:53 InnoDB: Initializing buffer pool, size = 128.0M
131003 14:57:53 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131003 14:57:53 [ERROR] Plugin 'InnoDB' init function returned error.
131003 14:57:53 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131003 14:57:53 [ERROR] Unknown/unsupported storage engine: InnoDB
131003 14:57:53 [ERROR] Aborting

131003 14:57:53 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 14:57:53 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131003 15:06:59 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131003 15:06:59 InnoDB: The InnoDB memory heap is disabled
131003 15:06:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131003 15:06:59 InnoDB: Compressed tables use zlib 1.2.3
131003 15:06:59 InnoDB: Initializing buffer pool, size = 128.0M
131003 15:06:59 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131003 15:06:59 [ERROR] Plugin 'InnoDB' init function returned error.
131003 15:06:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131003 15:06:59 [ERROR] Unknown/unsupported storage engine: InnoDB
131003 15:06:59 [ERROR] Aborting

131003 15:06:59 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 15:06:59 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended
131003 19:23:00 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
131003 19:23:00 InnoDB: The InnoDB memory heap is disabled
131003 19:23:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131003 19:23:00 InnoDB: Compressed tables use zlib 1.2.3
131003 19:23:00 InnoDB: Initializing buffer pool, size = 128.0M
131003 19:23:00 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131003 19:23:00 [ERROR] Plugin 'InnoDB' init function returned error.
131003 19:23:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131003 19:23:00 [ERROR] Unknown/unsupported storage engine: InnoDB
131003 19:23:00 [ERROR] Aborting

131003 19:23:00 [Note] /usr/local/libexec/mysqld: Shutdown complete

131003 19:23:00 mysqld_safe mysqld from pid file /var/db/mysql/root1672.pid ended

Coniesan · 10/03/2013, 21:34

Code:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!

hier is das Problem!
Lösch einfach mal folgende Dateien aus dem Verzeichnis:

Code:

ib_logfile0
ib_logfile1
ibdata1

So und wenn du ne my.cnf verwendest würd ich dir empfehlen, diese mal richtig ein zu stellen sodass sowas nimmer passiert

Cr4shedx · 10/03/2013, 21:39

Danke, aber jetzt bekomme ich einen neuen Fehler:
Der kommt jz in navicat und in putty.

Code:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Coniesan · 10/03/2013, 21:46

jou das bedeutet einfach, dass der User, oder das Passwort falsch ist, mit dem du versuchst, dich auf den aktuellen Host einzuloggen
D.h. wenn du in Putty einfach nur

Code:

mysql

eingibst, versucht er auf 'root'@'localhost' ohne PW ein zu loggen!
Wenn du dich mit PW einloggen willst, füg noch den Parameter -p dazu also:

Code:

mysql -p

Dann musst nurnoch das PW eingeben und du bist drin

Cr4shedx · 10/03/2013, 22:50

habe nun beim Starten von meinen Server ein Problem,

Code:

PUBLIC_IP: 185.***.***.xx interface em0
HOSTNAME: channel2
mysql_real_connect: Access denied for user 'm2user'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected

.tehSource · 10/03/2013, 23:22

Meld dich mal bei dem Skype Account: amp.justin.amp

Kann Dir sicher helfen

Lg. tehSource