Creating server issue with starting database

[downtime89 2]

So im trying to set up my server again, i have the server built xammp installed and running , every time i try to go into hedi or navicat and create a new session i get "access denied for admin@localhost using password yes" if i leave password blank it lets me in but i dont feel thats right.

 

[Beowulfv 305]

XAMPP has a lacal admin login that doesn't use a password. Use the PHP MyAdmin console that comes with XAMPP to create another user with a password.

[downtime89 2]

so what does the password in the extdb-conf i set during setup do? Its been so long since i built a server i cant remember do i have to link xammp or the database to my local server files somehow or just having xammp and the server running at the same time link them? Here is what is in my extdb-conf

 

Type = MySQL
Name = exile
Username = admin
Password = admin
IP = 127.0.0.1
Port = 3306

 

Edited March 28 by downtime89

[downtime89 2]

ok so i can get the server launching but when it launches im just staring at grass for a while then it crashes. This is whats in my rpt log. Any idea?

Spoiler

>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.
 

 

Edited March 28 by downtime89
forgot to add error

[Beowulfv 305]

Open PHPMyAdmin console, it's a part of XAMPP, create a new username with a password and give it full privileges. Then edit your extdb-conf.ini with the new Username and Password. Everything else in the ini can stay default. 

[downtime89 2]

still same error attaching pics do you see anything wrong?

[Beowulfv 305]

You have the user set to a wildcard. Need to have the Host Name set to 127.0.0.1

[downtime89 2]

So do I need to delete one of the admin and set the host name on the remaining one to that?  Away from my pc so can’t test right now.

[Beowulfv 305]

You can edit the one you made. The Username can be anything you want, the Host Name is 127.0.0.1, full privileges, and whatever password you want.

[downtime89 2]

Still having same errors here is a update on what it looks like error and screen shots of user names. What else could it be. Server launches but when ya load in its just that screen of grass on the ground.

 

Spoiler

  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
Call extension 'extDB2' could not be loaded: The specified module could not be found.

Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
  Error position: <_result select 0) do
{
case 0:
{
(format>
  Error Undefined variable in expression: _result
File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
  Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
  Error Undefined variable in expression: _clanids
File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20

 

Edited March 29 by downtime89