Проблема Ошибка подключения БД

[NIKRUS 70]

Здравствуйте! Подключил бд к моду, захожу, но постоянно выдает ошибку: Обнаружена ошибка в выполнении запроса к БД.

Вот MYSQL log:

[14:25:14] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'admin_sgtest'@'localhost' (using password: YES)
[14:25:14] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'admin_sgtest'@'localhost' (using password: YES)
[14:26:19] [WARNING] CMySQLHandle::Create - connection already exists

Вот лог сервера:

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

SA-MP Dedicated Server
----------------------
v0.3b R2, (C)2005-2010 SA-MP Team

[14:25:13] filterscripts = ""  (string)
[14:25:13] weburl = "www.sa-mp.com"  (string)
[14:25:13] 
[14:25:13] Server Plugins
[14:25:13] --------------
[14:25:13]  Loading plugin: streamer
[14:25:13] 

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

[14:25:13]   Loaded.
[14:25:13]  Loading plugin: sscanf
[14:25:13] 

[14:25:13]  ===============================

[14:25:13]       sscanf plugin loaded.     

[14:25:13]          Version:  2.8.1        

[14:25:13]    (c) 2012 Alex "Y_Less" Cole  

[14:25:13]  ===============================

[14:25:13]   Loaded.
[14:25:13]  Loading plugin: CRP
[14:25:13] 

[14:25:13] ______________________________________

[14:25:13]  Convert Rus To Pwn v0.1.1 loaded
[14:25:13] ______________________________________

[14:25:13]  By: Fro (c) Copyright <TBG> 2009-2011
[14:25:13] ______________________________________

[14:25:13]   Loaded.
[14:25:13]  Loading plugin: mysql
[14:25:13]  >> plugin.mysql: R33 successfully loaded.
[14:25:13]   Loaded.
[14:25:13]  Loading plugin: crashdetect
[14:25:13]   CrashDetect v4.15.1 is OK.
[14:25:13]   Loaded.
[14:25:13]  Loading plugin: TOTP
[14:25:13] TOTP plugin v1.0.0 by Games loaded.
[14:25:13]   Loaded.
[14:25:13]  Loaded 6 plugins.

[14:25:13] 
[14:25:13] Filter Scripts
[14:25:13] ---------------
[14:25:13]   Loaded 0 filter scripts.

[14:25:14] foreach called
[14:25:14] ВНИМАНИЕ!!! Подключение к базе данных отсутствует! Ошибка №: 1045
[14:25:14] SET NAMES 'cp1251'
[14:25:14] sscanf error: System not initialised.
[14:25:14] sscanf error: System not initialised.
[14:25:14] sscanf error: System not initialised.
[14:25:14] ------------------------------------------------

[14:25:14] 
----------------------------------
[14:25:14]  Сервер включен
[14:25:14] ----------------------------------

[14:25:14] Number of vehicle models: 27
[14:25:14] Дома => 0. Времени затрачено: <0 мс>

[#Storm 29]

Покажи подключение к БД.

[NIKRUS 70]

,

if(GetServerVarAsInt("port") == 8904)
	{
		ConBD = mysql_connect("127.0.0.1","admin_sg","admin_sg", "KHkPALvfJv");
	}
	else ConBD = mysql_connect("127.0.0.1","root","sgcomeback", "");
	ConBD = mysql_connect("127.0.0.1","root","sgcomeback", ""); 

[#Storm 29]

Убери вообще пароль, ты на локалке же запускаешься..

 

У тебя проверка звучит так : Если(Получаем порт) равен 8904

БД подключается с паролем, а ты на локале.

Изменено 8 декабря, 2018 пользователем Swile

[NIKRUS 70]

, Выдает :

[18:23:01] foreach called
[18:23:05] ВНИМАНИЕ!!! Подключение к базе данных отсутствует! Ошибка №: 2003
[18:23:06] SET NAMES 'cp1251'
[18:23:06] [debug] Server crashed while executing new1.amx
[18:23:06] [debug] AMX backtrace:
[18:23:06] [debug] #0 native mysql_set_charset () from mysql.DLL
[18:23:06] [debug] #1 00018044 in public Itter_OnGameModeInit () at C:\Users\NToria\Downloads\sg (2)\gamemodes\new1.pwn:1914
[18:23:06] [debug] #2 native CallLocalFunction () from samp-server-cr.exe
[18:23:06] [debug] #3 00012bf4 in public Streamer_OnGameModeInit () at C:\Users\NToria\Downloads\sg (2)\pawno\include\foreach.inc:381
[18:23:06] [debug] #4 native CallLocalFunction () from samp-server-cr.exe
[18:23:06] [debug] #5 0000e028 in public OnGameModeInit () at C:\Users\NToria\Downloads\sg (2)\pawno\include\Streamer.inc:250
[18:23:06] [debug] Native backtrace:
[18:23:06] [debug] #0 0272810f in ?? () from LIBMYSQL.dll
[18:23:06] [debug] #1 0272833d in ?? () from LIBMYSQL.dll
[18:23:06] [debug] #2 026ac6af in ?? () from LIBMYSQL.dll 

Исправил на:

if(GetServerVarAsInt("port") == 8904)
	{
		ConBD = mysql_connect("127.0.0.1","root","sgcomeback", "");
	}
	else ConBD = mysql_connect("127.0.0.1","root","sgcomeback", "");
	ConBD = mysql_connect("127.0.0.1","root","sgcomeback", "");
	switch(mysql_errno ()) 

[#Storm 29]

@NIKRUS,Напиши мне в личные сообщения ВК. Ссылка сам знаешь где. 

[none 18]

ConBD = mysql_connect("localhost","root","sgcomeback", "");
if(mysql_errno()==0) printf("Подключение к базе успешно");
else return printf("Подключение к базе не удалось");

Намного лучше, ну и подключение само проще.

Изменено 8 декабря, 2018 пользователем Aleksandr_Pavlov

[NIKRUS 70]

@Aleksandr_Pavlov, проще-то проще, но косяк в другом.

[NIKRUS 70]

ап

[MOP TTEX 144]

Порт на локалке 8904 ставишь?

И ещё:

 

 

причина возникновения MySQL error 1045 - неправильная комбинация трех параметров: имени пользователя, хоста и пароля.

[NIKRUS 70]

@MOP TTEX,да

[MOP TTEX 144]

Попробуй на локалке поставить 7777 или другой порт (кроме 8904)

[NIKRUS 70]

@MOP TTEX,не дает толку никакого. 

[Smolin 1,410]

sscanf error: System not initialised. обнови sscanf

[NIKRUS 70]

@Smolin,обновил, не помогло. Вообще без понятия что с модом.