MYSQL Error Hilfe

Network · 1. Juli 2016

Hey, ich habe MYSQL Error, wenn ich SAMP-Server.exe starte, kommt so 100 mal Error und das gleicher immer?
Ich habe alle Daten in Script eingetragen für MYSQL, wo liegt das Problem?

Das wird so 100 mal angezeigt bei der Server.log

[18:51:35] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp5630' localhost (using password: YES).

Jeffry · 1. Juli 2016

Zitat von Network

Access denied for user 'samp5630' localhost (using password: YES).

Deine Login Daten scheinen nicht zu passen.

Network · 1. Juli 2016

Zitat von Jeffry

Deine Login Daten scheinen nicht zu passen.

Aber die sollten passen? ....

Jeffry · 1. Juli 2016

Wenn die zu 100% stimmen, dann setze dich mal mit deinem SA-MP Server Host in Verbindung, möglicherweise fehlt deinem User samp5630 eine/mehrere Berechtigung(en), das kommt hin und wieder vor.

Network · 1. Juli 2016

Zitat von Jeffry

Wenn die zu 100% stimmen, dann setze dich mal mit deinem SA-MP Server Host in Verbindung, möglicherweise fehlt deinem User samp5630 eine/mehrere Berechtigung(en), das kommt hin und wieder vor.

Ich habe noch keinen Server host, den Script habe ich vor kurzem gekauft.
Brauche ich neue Mysql Daten?

Jeffry · 1. Juli 2016

Du musst die Daten angeben, mit denen du dich in deine Datenbank einloggen kannst.
Dazu gehören:

Host (IP)
User
Passwort
Datenbankname

In dem Tutorial habe ich beschrieben, wie man das anlegen kann:
[jTuT] MySQL R39-3 (Installation, XAMPP, Verwendung, Bedienung & Registrations-System)

Network · 1. Juli 2016

Zitat von Jeffry

Du musst die Daten angeben, mit denen du dich in deine Datenbank einloggen kannst.
Dazu gehören:

Host (IP)

User

Passwort

Datenbankname

In dem Tutorial habe ich beschrieben, wie man das anlegen kann:
[jTuT] MySQL R39-3 (Installation, XAMPP, Verwendung, Bedienung & Registrations-System)

Ok Danke ich werde diesen Tutorial mal Anschaun, hoffe es wird Funkunieren

@Jeffry Habe dein Tutorial nach gemacht aber nicht geholfen? hab auch bei Script die Daten eingefügt?...

#if defined serverrootorlocal
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""

#else
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""

Server log:

Spoiler anzeigen

Jeffry · 1. Juli 2016

Da du das 2.1.1 Plugin nutzt muss der Benutzer ein Kennwort haben (Fehler im Plugin).

Ändere das Passwort des root Benutzers wie im Tutorial beschrieben, dann sollte es gehen.

Network · 1. Juli 2016

Zitat von Jeffry

Da du das 2.1.1 Plugin nutzt muss der Benutzer ein Kennwort haben (Fehler im Plugin).

Ändere das Passwort des root Benutzers wie im Tutorial beschrieben, dann sollte es gehen.

Wo genau ist es im Tutorial? Sorry, aber ich finde es nicht? ..

Jeffry · 1. Juli 2016

Direkt vor Beginn des 5. Kapitels befindet sich der Spoiler für diese optionale Änderung.

Network · 1. Juli 2016

Ok habe es Geändert, und es in Script rein geschrieben, und Compilen

Server log:

Spoiler anzeigen

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team

[17:12:09]
[17:12:09] Server Plugins
[17:12:09] --------------
[17:12:09] Loading plugin: streamer
[17:12:09]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[17:12:09] Loaded.
[17:12:09] Loading plugin: mysql
[17:12:09] SA:MP MySQL Plugin v2.1.1 Loaded.
[17:12:09] Loaded.
[17:12:09] [MySQL] Thread running. Threadsafe: Yes.
[17:12:09] Loading plugin: filemanager
[17:12:10] Failed.
[17:12:10] Loaded 2 plugins.

[17:12:10]
[17:12:10] Filterscripts
[17:12:10] ---------------
[17:12:10] Loading filterscript 'ANIMATION.amx'...
[17:12:10] Loaded 1 filterscripts.

[17:12:10] [MySQL] Error (0): Failed to connect. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:10] [MySQL] Error (1): Failed to connect. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:10] [MySQL] Error (2): Failed to connect. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:10] [MySQL] Error (3): Failed to connect. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:10] ** Config data sucessfully set **
[17:12:11] [SERVER] Das Wetter wurde geändert.
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] Incoming connection: 127.0.0.1:52896
[17:12:11] Incoming connection: 127.0.0.1:52899
[17:12:11] Incoming connection: 127.0.0.1:52898
[17:12:11] Incoming connection: 127.0.0.1:52897
[17:12:11] Incoming connection: 127.0.0.1:52900
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).
[17:12:11] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'samp3330_gtaserv' localhost (using password: YES).

Jeffry · 1. Juli 2016

Nutze den User root, nicht samp3330_gtaserv.

Network · 1. Juli 2016

Zitat von Jeffry

Nutze den User root, nicht samp3330_gtaserv.

Ich habe bei alle beiden root
#if defined serverrootorlocal
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""

#else
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""

Aber ich habe hier ncoh was, soll ich hier was ändern?

#if defined serverrootorlocal
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""
#define NEWSERVERNAME "[Projekt Laberstuebchen]"
#define NEWSERVERMAP "test"
#define NEWSERVERLOGIN "asdfmovie123321"
#define NEWSERVERURL "www.laberstuebchen.de"
#define NEWSERVERMODE "Laberstuebchen"

#else
#define dbhost "127.0.0.1"
#define dbuser "root"
#define dbdb "samp_db"
#define dbpw ""
#define NEWSERVERNAME "[Projekt Laberstuebchen]"
#define NEWSERVERMAP "San Andreas"
#define NEWSERVERLOGIN "asdfmovie123321"
#define NEWSERVERURL "www.laberstuebchen.de"
#define NEWSERVERMODE "Laberstuebchen"

Jeffry · 1. Juli 2016

Irgendwo im Code muss auch samp3330_gtaserv stehen, und das muss abgeändert werden.

Network · 1. Juli 2016

Zitat von Jeffry

Irgendwo im Code muss auch samp3330_gtaserv stehen, und das muss abgeändert werden.

Werde ich dann suchen,

Ok ich habe das Kennwort geändert bei Apacher, nun kann ich nicht mehr in den Phpmyadmin Website betreten? Da kommt eine Fehlermeldung?

Jeffry · 1. Juli 2016

Wenn du alle Schritte in dem Spoiler gemacht hast, dann klappt das mit der Anmeldung nach der Passwortänderung auch wieder.
Du musst das Passwort in der config.inc.php ändern.

Zitat von Jeffry
Öffne in dem Verzeichnis nun die config.inc.php Datei mit einem Texteditor.
Suche dort die Zeile
PHP
$cfg['Servers'][$i]['password'] = '';
und ersetze diese durch
PHP
$cfg['Servers'][$i]['password'] = 'meinPW';
wobei Du natürlich "meinPW" mit dem von Dir vergebenen Passwort ersetzt.
Anschließend speichere und schließe die Datei. Jetzt kannst Du phpMyAdmin wieder über einen Klick auf "Admin" bei MySQL starten. Du wirst nun wieder automatisch korrekt angemeldet.
Alles anzeigen

Network · 2. Juli 2016

@Jeffry der Script findet samp3330_gtaserv nicht, wo kann es nur stehen?

Nun der Server.log:

Spoiler anzeigen

Und wegen phpmyadmin kann ich nicht rein, da kommt dieses Fehlermeldung:
Unbenannt.PNG Unbenannt.PNG

Jeffry · 3. Juli 2016

Die Fehlermeldung ist auch der Grund, warum du mit dem Server keine Verbindung herstellen kannst.
Du hast irgendwas an den Einstellungen verbogen, sodass keine Verbindung mehr hergestellt werden kann. Was genau kann ich dir nicht sagen.

Am besten du entfernst nochmal alles was zu XAMPP gehört (De-Installieren und Installationspfad komplett leeren) und installierst es nach dem Tutorial noch einmal, Schritt für Schritt. Dann sollte es wieder klappen.

MYSQL Error Hilfe

breadfish.de 12. März 2022

Ähnliche Themen

Scripter Gesucht brauche Hilfe

Hilfe bei Server

bei einem Kompletten Script das MYSQL Updaten

Error 2006

Problem Mit Mysql Update

MySql Connected nicht...