I didn"t join to server

[UncleRus]

https://drive.google.com/open?id=1eCMTn1xlKse1CNZCHGKz2MLNhGPLOQRr see this video what i don"t do

[habi]

You need to set a password to root in mysql. the password should not be empty.
then use that password in script. It will work.

Also, i recommend Notepad++ for scripting.

[UncleRus]

help me fix it where to find it and how to change it

[habi]

you need to go to localhost/phpmyadmin. --> User accounts ----> find root with localhost as hostname. Click on Edit Privileges---> Change password-----> **Enter new password **--> Go
https://imgur.com/a/5YectGI

[UncleRus]

https://prnt.sc/s1xiww i set password what fix it

[habi]

We need to give the password to Apache.
Go to Xampp, click config of Apache--> phpMyAdmin
A notepad file will open. Edit it as below.
['password'] = 'password';

https://imgur.com/a/P8n7CI5

[UncleRus]

https://prnt.sc/s1xooy

[UncleRus]

what fix it

[habi]

You need to access the "config.inc.php" file at C:\xampp\phpMyAdmin
Put your new password and save
https://prnt.sc/s1xttq

[UncleRus]

give me this code on your screenshott

[habi]

this is mine.
C:\xampp\phpMyAdmin

Code Select Expand

<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'pass';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

/*
 * End of servers configuration
 */

?>


[UncleRus]

i set my password see this https://prnt.sc/s1ypd4

[UncleRus]

What fix this

[UncleRus]

i fix it  what i can do to be admin in the server?

[habi]

Download plugin cmdinputrel32.dll https://bitbucket.org/ysc3839/0.4-cmdinput/downloads/cmdinput1.3.2-apiv2.zip
Copy it to plugins folder. Add cmdinputrel32 to server.cfg. Example below.

Code Select Expand

gamemode Default
plugins xmlconf04rel32 announce04rel32 squirrel04rel32 mysql04rel32 cmdinputrel32
port 8192
sqgamemode scripts/main.nut
maxplayers 100
Now add the following code to the bottom of the script.

Code Select Expand

function onConsoleInput(cmd, arg)
{
local script = compilestring( cmd );
script();
}It will look like this- https://prnt.sc/s23tgc
Now save and run the server. You join the server also. i.e. VCMP Browser-->Connect
Now on the console type stats[0].level=2 and press enter.
https://prnt.sc/s23wcu
Now you are admin!