Пожалуйста, очень нужна помощь с MySQL

[PROGRAMMATOR]

Интересно вы подключаетесь, может все же так:

PHP код:

<?php
    $dbconnect = mysql_connect($mysql_connect["host"].':'.$mysql_connect["port"], $mysql_connect["login"], $mysql_connect["password"]); 
    mysql_select_db($mysql_connect['db'], $dbconnect) or die (mysql_error()); 
?>

[KitKat]

Теперь кроме Can't connect to mysql on ............ добавилась еще

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in

[PROGRAMMATOR]

Ну это потому, что не подключилось к mysql серверу. Не знаю, конфиг хоть покажите что-ли.

[KitKat]

PHP код:

<?php

//-------------------------------Настройки MySQL базы сервера-------------------------------

$mysql_connect["host"]="xxx.xx.xxx.xx";   //IP адрес MySQL-сервера
$mysql_connect["port"]="3306";        //Порт
$mysql_connect["db"]="l2rt";         //Имя игровой базы
$mysql_connect["login"]="baka";       //Логин
$mysql_connect["password"]="666666";    //Пароль

//-----------------------------Настройки адресов сервера------------------------------------

$servergame="xxx.xx.xxx.xx";   //ip адрес сервера                   
$portgame="7777";          //порт игрового сервера

[PROGRAMMATOR]

Видимо доступ сейчас ограничили, но подключается и сервер отдает ответ:

Access denied for user 'baka'@'%' to database 'l2rt'

[KitKat]

А вот и нет, все осталось, как и было. Вы ведь в тот раз не к l2rt коннектились, вот и получилось....

[PROGRAMMATOR]

Жесть. Я же говорил, привилегии проверяйте, к серверу подключается, вы пишете что не подключается. Базы не видит ваш юзверь. Смотрите вкладку привилегий.

[KitKat]

Все привелегии вам дал. Пробуйте.

[PROGRAMMATOR]

Все окей, дали привилегии и я прочитал таблицы.

Array
(
    [0] => Array
        (
            [Tables_in_l2rt] => access_levels
        )
 
    [1] => Array
        (
            [Tables_in_l2rt] => account_data
        )
 
    [2] => Array
        (
            [Tables_in_l2rt] => accounts
        )
 
    [3] => Array
        (
            [Tables_in_l2rt] => admin_command_access_rights
        )
 
    [4] => Array
        (
            [Tables_in_l2rt] => armor
        )
 
    [5] => Array
        (
            [Tables_in_l2rt] => armorsets
        )
 
    [6] => Array
        (
            [Tables_in_l2rt] => auction
        )
 
    [7] => Array
        (
            [Tables_in_l2rt] => auction_bid
        )
 
    [8] => Array
        (
            [Tables_in_l2rt] => auction_watch
        )
 
    [9] => Array
        (
            [Tables_in_l2rt] => auto_announcements
        )
 
    [10] => Array
        (
            [Tables_in_l2rt] => auto_chat
        )
 
    [11] => Array
        (
            [Tables_in_l2rt] => auto_chat_text
        )
 
    [12] => Array
        (
            [Tables_in_l2rt] => castle
        )
 
    [13] => Array
        (
            [Tables_in_l2rt] => castle_door
        )
 
    [14] => Array
        (
            [Tables_in_l2rt] => castle_doorupgrade
        )
 
    [15] => Array
        (
            [Tables_in_l2rt] => castle_functions
        )
 
    [16] => Array
        (
            [Tables_in_l2rt] => castle_manor_procure
        )
 
    [17] => Array
        (
            [Tables_in_l2rt] => castle_manor_production
        )
 
    [18] => Array
        (
            [Tables_in_l2rt] => castle_siege_guards
        )
 
    [19] => Array
        (
            [Tables_in_l2rt] => char_creation_items
        )
 
    [20] => Array
        (
            [Tables_in_l2rt] => char_templates
        )
 
    [21] => Array
        (
            [Tables_in_l2rt] => character_friends
        )
 
    [22] => Array
        (
            [Tables_in_l2rt] => character_hennas
        )
 
    [23] => Array
        (
            [Tables_in_l2rt] => character_macroses
        )
 
    [24] => Array
        (
            [Tables_in_l2rt] => character_quest_global_data
        )
 
    [25] => Array
        (
            [Tables_in_l2rt] => character_quests
        )
 
    [26] => Array
        (
            [Tables_in_l2rt] => character_raid_points
        )
 
    [27] => Array
        (
            [Tables_in_l2rt] => character_recipebook
        )
 
    [28] => Array
        (
            [Tables_in_l2rt] => character_recommends
        )
 
    [29] => Array
        (
            [Tables_in_l2rt] => character_shortcuts
        )
 
    [30] => Array
        (
            [Tables_in_l2rt] => character_skills
        )
 
    [31] => Array
        (
            [Tables_in_l2rt] => character_skills_save
        )
 
    [32] => Array
        (
            [Tables_in_l2rt] => character_subclasses
        )
 
    [33] => Array
        (
            [Tables_in_l2rt] => character_tpbookmark
        )
 
    [34] => Array
        (
            [Tables_in_l2rt] => characters
        )
 
    [35] => Array
        (
            [Tables_in_l2rt] => clan_data
        )
 
    [36] => Array
        (
            [Tables_in_l2rt] => clan_notices
        )
 
    [37] => Array
        (
            [Tables_in_l2rt] => clan_privs
        )
 
    [38] => Array
        (
            [Tables_in_l2rt] => clan_skills
        )
 
    [39] => Array
        (
            [Tables_in_l2rt] => clan_subpledges
        )
 
    [40] => Array
        (
            [Tables_in_l2rt] => clan_wars
        )
 
    [41] => Array
        (
            [Tables_in_l2rt] => clanhall
        )
 
    [42] => Array
        (
            [Tables_in_l2rt] => clanhall_functions
        )
 
    [43] => Array
        (
            [Tables_in_l2rt] => class_list
        )
 
    [44] => Array
        (
            [Tables_in_l2rt] => connection_test_table
        )
 
    [45] => Array
        (
            [Tables_in_l2rt] => cursed_weapons
        )
 
    [46] => Array
        (
            [Tables_in_l2rt] => custom_armor
        )
 
    [47] => Array
        (
            [Tables_in_l2rt] => custom_armorsets
        )
 
    [48] => Array
        (
            [Tables_in_l2rt] => custom_droplist
        )
 
    [49] => Array
        (
            [Tables_in_l2rt] => custom_etcitem
        )
 
    [50] => Array
        (
            [Tables_in_l2rt] => custom_merchant_buylists
        )
 
    [51] => Array
        (
            [Tables_in_l2rt] => custom_merchant_shopids
        )
 
    [52] => Array
        (
            [Tables_in_l2rt] => custom_notspawned
        )
 
    [53] => Array
        (
            [Tables_in_l2rt] => custom_npc
        )
 
    [54] => Array
        (
            [Tables_in_l2rt] => custom_spawnlist
        )
 
    [55] => Array
        (
            [Tables_in_l2rt] => custom_teleport
        )
 
    [56] => Array
        (
            [Tables_in_l2rt] => custom_weapon
        )
 
    [57] => Array
        (
            [Tables_in_l2rt] => dimensional_rift
        )
 
    [58] => Array
        (
            [Tables_in_l2rt] => droplist
        )
 
    [59] => Array
        (
            [Tables_in_l2rt] => enchant_skill_trees
        )
 
    [60] => Array
        (
            [Tables_in_l2rt] => etcitem
        )
 
    [61] => Array
        (
            [Tables_in_l2rt] => fish
        )
 
    [62] => Array
        (
            [Tables_in_l2rt] => fishing_skill_trees
        )
 
    [63] => Array
        (
            [Tables_in_l2rt] => fort
        )
 
    [64] => Array
        (
            [Tables_in_l2rt] => fort_doorupgrade
        )
 
    [65] => Array
        (
            [Tables_in_l2rt] => fort_functions
        )
 
    [66] => Array
        (
            [Tables_in_l2rt] => fort_siege_guards
        )
 
    [67] => Array
        (
            [Tables_in_l2rt] => fort_spawnlist
        )
 
    [68] => Array
        (
            [Tables_in_l2rt] => fort_staticobjects
        )
 
    [69] => Array
        (
            [Tables_in_l2rt] => fortsiege_clans
        )
 
    [70] => Array
        (
            [Tables_in_l2rt] => forums
        )
 
    [71] => Array
        (
            [Tables_in_l2rt] => four_sepulchers_spawnlist
        )
 
    [72] => Array
        (
            [Tables_in_l2rt] => games
        )
 
    [73] => Array
        (
            [Tables_in_l2rt] => gameservers
        )
 
    [74] => Array
        (
            [Tables_in_l2rt] => global_tasks
        )
 
    [75] => Array
        (
            [Tables_in_l2rt] => grandboss_data
        )
 
    [76] => Array
        (
            [Tables_in_l2rt] => grandboss_list
        )
 
    [77] => Array
        (
            [Tables_in_l2rt] => helper_buff_list
        )
 
    [78] => Array
        (
            [Tables_in_l2rt] => henna
        )
 
    [79] => Array
        (
            [Tables_in_l2rt] => henna_trees
        )
 
    [80] => Array
        (
            [Tables_in_l2rt] => heroes
        )
 
    [81] => Array
        (
            [Tables_in_l2rt] => item_attributes
        )
 
    [82] => Array
        (
            [Tables_in_l2rt] => items
        )
 
    [83] => Array
        (
            [Tables_in_l2rt] => itemsonground
        )
 
    [84] => Array
        (
            [Tables_in_l2rt] => locations
        )
 
    [85] => Array
        (
            [Tables_in_l2rt] => lvlupgain
        )
 
    [86] => Array
        (
            [Tables_in_l2rt] => mapregion
        )
 
    [87] => Array
        (
            [Tables_in_l2rt] => merchant_areas_list
        )
 
    [88] => Array
        (
            [Tables_in_l2rt] => merchant_buylists
        )
 
    [89] => Array
        (
            [Tables_in_l2rt] => merchant_lease
        )
 
    [90] => Array
        (
            [Tables_in_l2rt] => merchant_shopids
        )
 
    [91] => Array
        (
            [Tables_in_l2rt] => merchants
        )
 
    [92] => Array
        (
            [Tables_in_l2rt] => minions
        )
 
    [93] => Array
        (
            [Tables_in_l2rt] => mods_wedding
        )
 
    [94] => Array
        (
            [Tables_in_l2rt] => npc
        )
 
    [95] => Array
        (
            [Tables_in_l2rt] => npc_buffer
        )
 
    [96] => Array
        (
            [Tables_in_l2rt] => npcskills
        )
 
    [97] => Array
        (
            [Tables_in_l2rt] => olympiad_data
        )
 
    [98] => Array
        (
            [Tables_in_l2rt] => olympiad_nobles
        )
 
    [99] => Array
        (
            [Tables_in_l2rt] => olympiad_nobles_eom
        )
 
    [100] => Array
        (
            [Tables_in_l2rt] => pets
        )
 
    [101] => Array
        (
            [Tables_in_l2rt] => pets_skills
        )
 
    [102] => Array
        (
            [Tables_in_l2rt] => pets_stats
        )
 
    [103] => Array
        (
            [Tables_in_l2rt] => pledge_skill_trees
        )
 
    [104] => Array
        (
            [Tables_in_l2rt] => posts
        )
 
    [105] => Array
        (
            [Tables_in_l2rt] => quest_global_data
        )
 
    [106] => Array
        (
            [Tables_in_l2rt] => raidboss_spawnlist
        )
 
    [107] => Array
        (
            [Tables_in_l2rt] => random_spawn
        )
 
    [108] => Array
        (
            [Tables_in_l2rt] => random_spawn_loc
        )
 
    [109] => Array
        (
            [Tables_in_l2rt] => record
        )
 
    [110] => Array
        (
            [Tables_in_l2rt] => seven_signs
        )
 
    [111] => Array
        (
            [Tables_in_l2rt] => seven_signs_festival
        )
 
    [112] => Array
        (
            [Tables_in_l2rt] => seven_signs_status
        )
 
    [113] => Array
        (
            [Tables_in_l2rt] => siege_clans
        )
 
    [114] => Array
        (
            [Tables_in_l2rt] => skill_learn
        )
 
    [115] => Array
        (
            [Tables_in_l2rt] => skill_residential
        )
 
    [116] => Array
        (
            [Tables_in_l2rt] => skill_spellbooks
        )
 
    [117] => Array
        (
            [Tables_in_l2rt] => skill_trees
        )
 
    [118] => Array
        (
            [Tables_in_l2rt] => spawnlist
        )
 
    [119] => Array
        (
            [Tables_in_l2rt] => special_skill_trees
        )
 
    [120] => Array
        (
            [Tables_in_l2rt] => teleport
        )
 
    [121] => Array
        (
            [Tables_in_l2rt] => temporaryobjecttable
        )
 
    [122] => Array
        (
            [Tables_in_l2rt] => topic
        )
 
    [123] => Array
        (
            [Tables_in_l2rt] => transform_skill_trees
        )
 
    [124] => Array
        (
            [Tables_in_l2rt] => walker_routes
        )
 
    [125] => Array
        (
            [Tables_in_l2rt] => weapon
        )
 
    [126] => Array
        (
            [Tables_in_l2rt] => zone_vertices
        )
 
)

[KitKat]

хм..... *ударился об клавиатуру* и как так может быть?.........

вы через

PHP код:

<?php
    $dbconnect = mysql_connect($mysql_connect["host"].':'.$mysql_connect["port"], $mysql_connect["login"], $mysql_connect["password"]); 
    mysql_select_db($mysql_connect['db'], $dbconnect) or die (mysql_error()); 
?>

подключались?